Showing debits and credits as positive or negative

This page is for MYOB Acumatica consultants

Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.

If you want to show a debit or a credit as a positive or negative vale within your generic inquiry the following expression yields faster results.

=Switch( [GLTran.DebitAmt]>0, [GLTran.DebitAmt]*1, [GLTran.CreditAmt]>0, [GLTran.CreditAmt]*-1)