In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions [Solved] formula for negative amounts in GI (Adding Calculated Columns – Example #2)
Hi, Why doesn't Acumatica automatically use the negative calculation to view negative numbers in a GI? Why does this have to be a manual user function to remember to do?
Perhaps an example might make your issue apparent.
It looks like you're referencing one of the examples from the Course.
I agree that it's a little weird to have to do a formula to flip the [APInvoice.CuryOrigDocAmt] value from positive to negative for Debit Adjustments. But, if you look at the value in that field on the Bills and Adjustments (AP301000) data entry screen, it's always positive. It might be weird if it were negative on the data entry screen just for the sake of reporting.
In some cases, there is a field that automatically flips the sign for you though. Take a look at [ARTran.NetSalesAmount] for an example.
You can use the [APInvoice.DrCr] field to make the sign flip formula trivial.