Hi, In GST Pending Recognition report below, there is an Unrecognized Tax Total. This is a standard report in Acumatica.
How do I get the 2 headers (Taxable Amt and Tax Amt) total just like how Unrecognized Tax Total is? Based on the screenshot below, it totals per Tax ID (i.e., G1SALESINCGST).
I’ve tried using formulas such as =Sum(Max([SVATConversionHistExt.TaxAmt])) but that doesn’t work. It gives me wrong totals. I’ve tried variables too - doesn’t work either.
Hi
Try creating new variables for the Taxable Amt and Tax Amt. Copy the existing formula from the fields into the ValueExpr.
Then add new variables for the Subtotal as show:
Add new text fields in the Footer section. Add the new variables defined for the subtotals:
The tax total should calculate as intended (please ignore my lack of detail with aligning the columns).
Let me know if you get hung up anywhere.
Ah, think it has to do with the groupings. It’s totaling the entire document, not just the one section. I’ll do a bit more digging.
Can you define the Reset Group as Group2 for both Total variables?
It is close mate after adding group 2 in subtotals, but still incorrect. I’ve tried adding in Subtotals too in groupHeaderSection4 just like how UnrecognizedVAT is, but got the same result. Wondering if you got any more suggestions?
Both of the below setup return the same result:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
