Acumatica Report GL620500 - Variable is not working

Hi ​@nsmith51
To display the Total Amount and Total Count in the header, you can specify the following corresponding formulas:
=Sum([Batch.ControlTotal])
=CStr(Count([Batch.FinPeriodID]))

​@aleksandrsechin 

Thank you so much! This solution worked perfectly.

However, when I applied the same approach in the GL Register Detail report, the amount and count values are getting doubled. Also, we use four variables in this report — they display the correct values at the bottom, but when I place the same variables at the top, they do not show the correct data.

Do you know why this happens, and how I can get the correct values to display at the top of the report as well?

Thanks again for your help!

For me, the same approach works here as well. I specified the following formulas:

DebitTotal: =Sum([GLTran.CuryDebitAmt])
CreditTotal: =Sum([GLTran.CuryCreditAmt])
BaseDebitTotal: =Sum([GLTran.DebitAmt])
BaseCreditTotal: =Sum([GLTran.CreditAmt])
Count: =CStr(Count([GLTran.FinPeriodID]))

The result:

​@aleksandrsechin Thank you for the solution.

But, I would like to display the count of Batch documents but not the line count. For example: if I have 2 batch with 2 lines, in the above case, it is displaying Count as 4 but I wanted to display as 2.

When I use variables it is working only when I put them at the bottom but not working when I add them top.

Can you please let me know how to display the Batch Count instead of Line count.

​@aleksandrsechin  Can you please help me with this?

Any report experts who can review this and help me?

Hi ​@Chris Hackett Could you please forward this to Acumatica to see if they can provide assistance?