Ok, I'm sure I'm missing something super simple.
i have a report that I want to summarize open/unpaid balances for a customer where certain Sales Orders are Flagged (with a manual) Checkbox.
I have the schema and all data flowing properly in the report EXCEPT when it comes to totaling the report. I assumed that I could accomplish this with grouping, but that doesn't seem to work.
In the report you can see i have 2 Sales Orders. The report should calculate the total unpaid, but it is circling through and adding up the unpaid balance from ALL the lines on the SO.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/0751c19d-f2ca-4720-81ed-2d5d34970b33.png)
I thought if i put the 'totals' in a group and grouped by Customer AcctCD that it would sum at that level but I"m obviously missing something:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/acd1a202-0e69-46df-a2e8-829ed7ebb65f.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d9dba9f9-938a-4694-be77-b35d94cbade2.png)
Best answer by K2a
View original