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
- 01/01/08 Sales Sa0001 Engine Parts 10,000.00 10,000.00
- 02/01/08 Pay Pa1050 Paym to A/CS0001 2,000.00 8,000.00
- 02/08/08 Retu Cr2001 Cred to A/CS0001 2,000.00 6,000.00 Anybody already created anything similar?