Skip to main content

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? 

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.

 

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?

Reply


Terms & ConditionsCookie settings