showing AR credits and AP debits as negative numbers in GI by default.

Hi @mna10! The reason for this is that when you are running a GI you are querying the values seen in the database, which are stored in positive numbers.

The Acumatica UI will adjust this on the screens you may see negative numbers, based on document type or account type usually.

So in a GI you are typically grabbing the value directly from the DB and so it is displayed as it is seen in SQL, which is a positive number

Hi. Thank you. You would just think since they are pulling from the database, they would automatically add the formula to make it a negative number as if we rely on this this and export, the information is not correct. 

Makes it impossible to create pivot tables off the AP and AR inquiries without writing several formulas.

Yes this. How do we overcome this issue?

For AP Bills use ADR for Debit Adj and for AR Invoices us CRM for credit memos in Generic Inquiries. 

Use where in the GI?

Life saver

This, along with other document naming issues really an issue that Acumatica needs to take a hard look at.

All documents that have a reversing action should reflect that in tables where both negative and positive documents are show. Showing both with a positive number is considered an error by our accounting team(and myself). It doesn’t make sense.