RE: Question on Subsets

[lisa.thomas@xxxxxxxxxxx]

We definitely need condition statements in creating logical fields.  That's
a Mapics enhancement I would love to see.

-----Original Message-----
From: Buckingham, Ed [mailto:ebuckingham@xxxxxxxxxx]
Sent: Tuesday, March 09, 2004 3:30 PM
To: MAPICS ERP System Discussion
Subject: RE: Question on Subsets


That is another thought that was suggested.  I don't have any extra
fields in the file, so I would have to create a tag along file and
create a trigger to keep it in sync.  I was hoping that I could use an
Alias for the debit/credit field as a C = -1 and D = 1 and create a
logical expression that would simply multiply the amount field by the
alias value to give me the desired result.  This did not work so I am
left only with the extra file and trigger.  Seems like there should be
an easier way to solve this.