Query for Customer Balances and Corressponding Incoming Payments
How to get the account balance of a particular customer with corressponding incoming payments.
Eg: Suppose one Invoice having 5000.00 for which i got 3 incoming payments of 1000.00 2000.00 and 500.00, now i need to give a report as
CardCode | Balance | Adjusted Amount | Un Adjusted Amount
xyz | 5000.00 | 1000.00 | 4000.00
xyz | | 2000.00 | 2000.00
xyz | | 500.00 | 1500.00
i have mentioned for one customer similarly i need for all the customers and vendors.
Waiting for you earliest reply,
Thanks in Advance.