Skip to main content
Solved

ARM Report formula for Trial Balance report filter by multiple period if sign of trial balance is reversed?


Forum|alt.badge.img

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

Hello @hthuy24 ,

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:

https://community.acumatica.com/isvs-and-marketplace-103/velixo-6-for-acumatica-released-4740

 

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

 

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • July 6, 2023

Hello @hthuy24 ,

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:

https://community.acumatica.com/isvs-and-marketplace-103/velixo-6-for-acumatica-released-4740

 

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

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 38 replies
  • July 6, 2023
Laura02 wrote:

Hello @hthuy24 ,

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:

https://community.acumatica.com/isvs-and-marketplace-103/velixo-6-for-acumatica-released-4740

 

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings