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" <cstew...@tri-sysconsulting.com>
To:     "'U2 Users List'" <u2-users@listserver.u2ug.org>, 
Date:   05/02/2012 02:16 PM
Subject:        Re: [U2] Attribute Problem
Sent by:        u2-users-boun...@listserver.u2ug.org



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

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to