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