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.
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.
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.
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.
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.