Hi everyone,
I see that the reverse sign of Trial balance don't apply to ARM Report so the formula Asset+Expense+Liabilities+Income not equal to 0
I want to create a trial balance report filter by period in arm report but i dont know how set up row sets or column sets to achieve this.
Best answer by Laura02
View original
+18
Hello
Financial reporting using ARM features of Acumatica meets the needs of approximately 90% of clients, in my experience. For those with complex reporting needs, we recommend Velixo. Velixo is an Add-on to Excel to help you build reports in Excel that read the Acumatica database tables.
Please see Gabriel’s Post:
To make the report you describe using ARM will require many calculations in the columns. I am not a programmer so I will give an example in English, not in code:
If account type is Asset or expense ( or If account number begins with ‘1’, ‘5’, ‘6’ etc.) then Add Beginning Balance plus debit amount and subtract credit amount = Ending Balance.
If Account Type is Liability or Income, add beginning balance plus Credit Amount minus Debit Amount to get Ending Balance. Then multiply calculated ending balance by negative 1 to get reversed sign Ending Balance. Multiply beginning balance times -1 to get reversed sign beginning balance.
Test carefully.
I’m not sure calculations by Account Type or Account Number are possible with ARM. When I looked at available parameters, I found @RowNumber and @AccountCode fields that may work.
Good luck!
Laura
Hello
Financial reporting using ARM features of Acumatica meets the needs of approximately 90% of clients, in my experience. For those with complex reporting needs, we recommend Velixo. Velixo is an Add-on to Excel to help you build reports in Excel that read the Acumatica database tables.
Please see Gabriel’s Post:
To make the report you describe using ARM will require many calculations in the columns. I am not a programmer so I will give an example in English, not in code:
If account type is Asset or expense ( or If account number begins with ‘1’, ‘5’, ‘6’ etc.) then Add Beginning Balance plus debit amount and subtract credit amount = Ending Balance.
If Account Type is Liability or Income, add beginning balance plus Credit Amount minus Debit Amount to get Ending Balance. Then multiply calculated ending balance by negative 1 to get reversed sign Ending Balance. Multiply beginning balance times -1 to get reversed sign beginning balance.
Test carefully.
I’m not sure calculations by Account Type or Account Number are possible with ARM. When I looked at available parameters, I found @RowNumber and @AccountCode fields that may work.
Good luck!
Laura
Thanks Laura, your idea is really helpful.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
