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)