Hi,
I got stucked in Customer aging report. Below is my Query.
In customer master I have Accountnum and new field Status
Now I have 3 customer
AccountNum 1101,Status–Yes
AccountNum 1102,Status–Yes
AccountNum 1103,Status–No.
In report, customer wise balance is coming but I want balance based on HQ and sum up the balance for that customer.
Like, Customer 1–Bal=1000, Status-Yes
Customer 2- Bal=2000,Status-Yes
I want balance 3000 for same Status type.
If anyone have idea then let me know.