|
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. -----Original Message----- From: lisa.thomas@xxxxxxxxxxx [mailto:lisa.thomas@xxxxxxxxxxx] Sent: Tuesday, March 09, 2004 3:03 PM To: mapics-l@xxxxxxxxxxxx Subject: RE: Question on Subsets Do you have another field available in the file, perhaps a user field, that you can load with -1 with a trigger program depending on the account type? Then this field could be used in the logical expression. -----Original Message----- From: WRamos@xxxxxxxxxxxx [mailto:WRamos@xxxxxxxxxxxx] Sent: Monday, March 08, 2004 4:20 PM To: MAPICS ERP System Discussion Subject: RE: Question on Subsets That code field is called Account Type. AS-Asset IC- Income EX-Expense LI-Liability "Ann Neal" <aneal@letourneau- To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx> inc.com> cc: Sent by: Subject: RE: Question on Subsets mapics-l-bounces@m idrange.com 03/08/2004 12:46 PM Please respond to MAPICS ERP System Discussion I think the GL records have a code as to whether it was an Asset or LIability account and we wrote queries to get reports. Pulled all the asset accounts multiplying the credits with a -1, then all the liabilites, etc. We have IFM, or I would look at it with our Browser. If you can identify that code field, you could subset by type of account? Ann -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx Behalf Of Buckingham, Ed Sent: Monday, March 08, 2004 12:21 PM To: mapics-l@xxxxxxxxxxxx Subject: Question on Subsets Hi, I am new to this list. We are currently running MAPICS XA6. I have a browser question. Currently some of the subsets in the General Ledger are setup with a view that contains totals on the Amount column. Since these totals are represented by positive numbers, the totals are not correct. My questions is there any way to convert the amount field to a positive or negative value based on the Debit/Credit column. I have tried to experiment with Aliases and logical expressions, but this did not work. Has any one run into this problem? See below for an example: Subset Before: Company number Account number Journal reference number Description Amount D/C Year Month Day -------------- --------------- ------------------------ --------------- --------------- --- ---- ----- --- 1 10001 CR1051700002 00673700-479314 3,297.48 Debit 0 0 0 1 10001 CR1051700004 02036100-478870 504.63 Debit 0 0 0 1 10001 CR1051700006 02042000-481109 347.29 Credit 0 0 0 1 10001 CR1051700008 05018800-479099 281.88 Debit 0 0 0 Total 4431.28 Subset After: Company number Account number Journal reference number Description Amount D/C Year Month Day -------------- --------------- ------------------------ --------------- --------------- --- ---- ----- --- 1 10001 CR1051700002 00673700-479314 3,297.48 Debit 0 0 0 1 10001 CR1051700004 02036100-478870 504.63 Debit 0 0 0 1 10001 CR1051700006 02042000-481109 -347.29 Credit 0 0 0 1 10001 CR1051700008 05018800-479099 281.88 Debit 0 0 0 Total 3736.70 Would like to show negative signs in the Amount column so that the total columns are correct. Any help or suggestions would be appreciated. Thanks! Ed Buckingham _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
