SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

How to reconcile a Customer Account ? (General)

posted by DavidJ(R), 29.08.2016, 02:59

We have a customer who never pays the correct amount of any Sales Invoice.
He just pays $200 here, or $500 there, depending upon his available funds.
We happily receive payment anytime he sends us money.
We allocate each payment to the oldest unpaid invoice/s.
Now we need to reconcile his account.
SQL-L can easily make a list of the Sales Invoices for this Customer, sorted by date.
How do we get a list of his actual payment/s to us, sorted by date ?
How to get this information without manually searching thru numerous invoices, manually adding up amount/s paid on same date/s to give actual amount/s received ?
I'm suspecting this might not be possible from existing SQL-L report/s.
Is there a suggested SELECT statement that I could use to create a custom report ?
TIA's

 

Complete thread:

Back to the forum
Board view  Mix view
986 Postings in 324 Threads, 326 registered users, 137 users online (0 registered, 137 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum