I tried enclosing F-MATL in single quotes. It didn't throw an error, but it still returned 0.
I guess I can just avoid it. It's odd though, I don't remember this ever happening before. Charles Shaffer Senior Analyst NTN-Bower Corporation From: "Curt Stewart" <[email protected]> To: "'U2 Users List'" <[email protected]>, Date: 05/02/2012 02:16 PM Subject: Re: [U2] Attribute Problem Sent by: [email protected] I would guess that the calculation is trying to subtract MATL from F. Could it be enclosed in quotes or something? Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions (p) 262-432-3897 (c) 262-227-9619 Real-World Solutions for Real-World Problems! www.tri-sysconsulting.com View my LinkedIn R Profile -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, May 02, 2012 2:13 PM To: [email protected] Subject: [U2] Attribute Problem Hi. I think I have finally gone insane. I am having a problem with the attribute MATL.AMT. It calculates the extended amount on hand by taking the frozen material cost times the on hand amount. The problem is when I use F_MATL for the frozen material cost, MATL.AMT is good. When I use F-MATL for the frozen material cost, it returns 0 everytime. F_MATL and F-MATL are identical and if you list them both work fine. But when they are used in the calculation F_MATL works, but F-MATL. doesn't. Can anyone see what the problem is? ****************************************** :AE DICT INVENTORY-LOCATION_18 MATL.AMT Top of "MATL.AMT" in "DICT INVENTORY-LOCATION_18", 6 lines, 43 characters. *--: P 001: V 002: ON.HAND * F-MATL 003: MR25, 004: MATERIAL.AMT 005: 13R 006: S Bottom. ****************************************** :AE DICT INVENTORY-LOCATION_18 F_MATL Top of "F_MATL" in "DICT INVENTORY-LOCATION_18", 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, "G0*1"); OCONV(@2, "TINVENTORY-MASTER*18;X;66;66") 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. ******************************************* :AE DICT INVENTORY-LOCATION_18 F-MATL Top of "F-MATL" in "DICT INVENTORY-LOCATION_18", 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, "G0*1"); OCONV(@2, "TINVENTORY-MASTER*18;X;66;66") 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
