Question on Subsets

["Buckingham, Ed" <ebuckingham@xxxxxxxxxx>]

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