Custom Report: Customer On-Account balance with running total

Jun 18, 2008 0 Replies

I need a custom report.



- The report should show how an "Open Sales Invoice" (under account) has been paid and closed-out (e.g. how a multiple payment methods & references applied - payment, credits, returned). I badly need this report as it affects the capability of the customer on collecting A/R. I have seen numerous customer with "allegedly" open accounts called-us back stating that they already paid such open invoices (they even have a reference payment). I would like to have this simple statement format, as follows:- Date Type trans # Short Desc Amt Run Bal



  1. 01/01/08 Sales Sa0001 Engine Parts 10,000.00 10,000.00
  2. 02/01/08 Pay Pa1050 Paym to A/CS0001 2,000.00 8,000.00
  3. 02/08/08 Retu Cr2001 Cred to A/CS0001 2,000.00 6,000.00 Anybody already created anything similar?

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required