By using this website, you agree to our Terms of Use (click here)
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).
Sincerely,
Tim Rodman
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.
Hi Marisa,
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.
@timrodman Hi Tim, yes, that is what I'm talking about. Thanks for sending the ARTran.NetSalesAmount example. Does something like that exist on the AP side?
You can use the [APInvoice.DrCr] field to make the sign flip formula trivial.
@roycelithgo Thanks for pointing that out. That's totally another way to do it.
@mandreottola Oh wait, it looks like the [APInvoice.DrCr] field returns a D or a C so you'd still need to use an IIf statement.
I was thinking it returned a 1 or -1 like the [INTran.InvtMult] field does which allows you to multiply the amount that you want by [INTran.InvtMult] to get the appropriate positive or negative value.