Re: [U2] Attribute Problem
Done. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 05/02/2012 04:45 PM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
I don't think so. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Boydell, Stuart stuart.boyd...@spotless.com.au To: U2 Users List u2-users@listserver.u2ug.org, Date: 05/02/2012 04:32 PM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org can you DLIST a V type in UD to see how it's compiled? From: charles_shaf...@ntn-bower.com Sent: 03-May-12 5:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
Could it be that MATL is being subtracted from F ? Which of course would not work unless MATL and F had numeric values george -Original Message- From: charles_shaf...@ntn-bower.com Sent: Thursday, May 03, 2012 7:25 AM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Attribute Problem Done. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 05/02/2012 04:45 PM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
I think so. I went with the underscore. Charles Shaffer Senior Analyst NTN-Bower Corporation From: George R Smith geo...@grsmith.arcoxmail.com To: U2 Users List u2-users@listserver.u2ug.org, Cc: u2-users-boun...@listserver.u2ug.org Date: 05/03/2012 07:31 AM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org Could it be that MATL is being subtracted from F ? Which of course would not work unless MATL and F had numeric values george -Original Message- From: charles_shaf...@ntn-bower.com Sent: Thursday, May 03, 2012 7:25 AM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Attribute Problem Done. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 05/02/2012 04:45 PM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
Isn't the DICT at risk of treating the - in F-MATL as a minus? Just a thought. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, May 02, 2012 3:13 PM To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, May 02, 2012 2:13 PM To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
F minus Mail Are you confident the V processer is that brilliant that it can distinguish between a name and an operator ? -Original Message- From: Charles_Shaffer charles_shaf...@ntn-bower.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, May 2, 2012 12:15 pm 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 xtended amount on hand by taking the frozen material cost times the on and amount. The problem is when I use F_MATL for the frozen material cost, MATL.AMT is ood. When I use F-MATL for the frozen material cost, it returns 0 verytime. F_MATL and F-MATL are identical and if you list them both work fine. But hen they are used in the calculation F_MATL works, but F-MATL. doesn't. an anyone see what the problem is? ** AE DICT INVENTORY-LOCATION_18 MATL.AMT op of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters. --: P 01: V 02: ON.HAND * F-MATL 03: MR25, 04: MATERIAL.AMT 05: 13R 06: S ottom. ** AE DICT INVENTORY-LOCATION_18 F_MATL op of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. --: P 01: V 02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 03: MD5, 04: MATERIAL/UNIT 05: 13R 06: S ottom. *** AE DICT INVENTORY-LOCATION_18 F-MATL op of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. --: P 01: V 02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 03: MD5, 04: MATERIAL/UNIT 05: 13R 06: S ottom. harles Shaffer enior Analyst TN-Bower Corporation __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
Not at this point. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 05/02/2012 02:24 PM Subject:Re: [U2] Attribute Problem Sent by:u2-users-boun...@listserver.u2ug.org F minus Mail Are you confident the V processer is that brilliant that it can distinguish between a name and an operator ? -Original Message- From: Charles_Shaffer charles_shaf...@ntn-bower.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, May 2, 2012 12:15 pm 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 xtended amount on hand by taking the frozen material cost times the on and amount. The problem is when I use F_MATL for the frozen material cost, MATL.AMT is ood. When I use F-MATL for the frozen material cost, it returns 0 verytime. F_MATL and F-MATL are identical and if you list them both work fine. But hen they are used in the calculation F_MATL works, but F-MATL. doesn't. an anyone see what the problem is? ** AE DICT INVENTORY-LOCATION_18 MATL.AMT op of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters. --: P 01: V 02: ON.HAND * F-MATL 03: MR25, 04: MATERIAL.AMT 05: 13R 06: S ottom. ** AE DICT INVENTORY-LOCATION_18 F_MATL op of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. --: P 01: V 02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 03: MD5, 04: MATERIAL/UNIT 05: 13R 06: S ottom. *** AE DICT INVENTORY-LOCATION_18 F-MATL op of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters. --: P 01: V 02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66) 03: MD5, 04: MATERIAL/UNIT 05: 13R 06: S ottom. harles Shaffer enior Analyst TN-Bower Corporation __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
can you DLIST a V type in UD to see how it's compiled? From: charles_shaf...@ntn-bower.com Sent: 03-May-12 5:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Attribute Problem
i can't remember ever using a dash in a dict, or wanting to. that there are two entries for the same dict kinda does imply whoever made it has already punted I think I have finally gone insane. welcome to MY world!!! ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: Wednesday, May 02, 2012 2:46 PM To: U2 Users List Subject: Re: [U2] Attribute Problem You've already got the answer. Use F_MATL instead of F-MATL and stop thinking about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 02 May 2012 20:13 To: u2-users@listserver.u2ug.org 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users