Query for Customer Balances and Corressponding Incoming Payments

[Former Member]

Hi all,

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.

[Former Member · Accepted solution]

Please check this thread:

Thanks,

Gordon