By using this website, you agree to our Terms of Use (click here)
In an Acumatica Financial Report, I have a request to block the default behavior of presenting Credit Balances as a positive value and instead show the 'natural' direction. A liability account with a Credit Balance should show as a Negative.
I don't find any discussion in the manuals regarding support for such a request.
Is this something a reporting add-on such as Velixo can support?
In FRx and Management Reporter, there was a flag (C) in the row set that could be applied on a line by line basis to accomplish this outcome.
Hi Michael,
The Analytical Report Manager of Acumatica always uses the 'natural' direction when retrieving balances and ignores what you have configured in General Ledger Preferences for the trial balance sign. This can be quite problematic if you are summing up multiple accounts in a range, and one of the accounts is of a different type (ex: an expense account numbered like an income account).
Velixo originally followed the exact same pattern as Acumatica, but after wrestling with so many chart of accounts that had irregular numbering I decided to make it easy for users to set an option that would always show a credit as negative and a debit as positive, regardless of the account type. This is the account balance sign that can be sign in the Options screen.
• Normal (Default value): The credit balances for liability and income accounts are displayed as positive numbers, and the debit balances are displayed as negative numbers. In this mode, the total balance of all asset accounts is equal to the total balance of all liability accounts (and Assets + Expenses = Liabilities + Income).
• Reversed: The credit balances of liability and income accounts are displayed as negative numbers, and the debit balances are displayed as positive numbers. In this mode, the total balance of all accounts is equal to zero (i.e., Assets + Expenses + Liabilities + Income = 0)
Happy to give you a full demo and a trial license if you'd like to try it out with your own data and reports.
Online Members
