Client has the following accounts setup –
Account A is an Expense Account with a Credit Balance
Account B is an Expense Account with a Debit Balance
They would like Account A to show as a positive on the P&L even though it is a Credit Balance
They would like Account B to show as a negative on the P&L even though it is a Debit Balance
The client is on the latest version of Acumatica
How can I make this work?
Thanks
Mike
Hi
Are referring to the ARM report for P&L. or is this a new report built using reports designer? I don't seen an option to manipulate the sign on same line on ARM report. I Will check if we can insert a new line or column and manipulate original value.
Regards,
Yeah, I was referring to the ARM report. I ended up creating a new line and multiplying by -1. I was hoping there was a different way.
Thanks
Mike
This is especially annoying when you want to sum up multiple accounts in one ARM row and one of the accounts has a different type. I’ve run into many cases where the chart of accounts was not properly setup, or customers that mix asset/liabilities and revenue/expense accounts on purpose in the same numerical range.
In Velixo Reports for Acumatica we resolved this by allowing users to configure the Account Balance Sign at the workbook level - we default to the Acumatica behaviour but users that want to override it can change the configuration easily per Excel workbook:
Thank you for the input. I have 2 clients going live Jan 1 and once we get live and settled I can see moving them both to Velixo Reeports for their financial needs.
Velixo is a reporting life saver. We started using it last October after going live in July. Its flexibility and ability to get around Acumatica’s reporting limitations is priceless. I use a combination of ARM and Velixo reports to get my data and reports. Highly recommend it.
As to the ARM reports, the line items print fine without my needing to modify sign with the exception of calculated fields. When calculating a variance the following formula exists on the value line of the column set to maintain the positive/negative variance presentation. I do keep the trial balance set to normal. I find that keeps things less confusing as you know when you see a negative it is a credit.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.