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?
+4Hi
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.
+1Makes it impossible to create pivot tables off the AP and AR inquiries without writing several formulas.
sroberts29 wrote:
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.
1 person likes this
tommaricle43 wrote:
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?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.