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

  • 30 January 2023
  • 3 replies
  • 175 views

Userlevel 3
Badge

It seems so many build in GIs don’t do this by default. We have to modify the GI for it to show as a negative number. Would be helpful if this was built into the GIs automatically. 

Is there any plan to do this in the future? 


3 replies

Userlevel 7
Badge +4

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

Userlevel 3
Badge

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. 

Userlevel 3
Badge +1

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

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved