SQL-Ledger User Forum - How to reconcile a Customer Account ?

DavidJ

29.08.2016, 02:59

How to reconcile a Customer Account ? (General)

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

sqlvlp

04.09.2016, 05:07

@ DavidJ

How to reconcile a Customer Account ?

Post reply

» 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
Have you try to get reports from
Cash - Reports -Receipts

DavidJ 13.10.2016, 06:52 @ sqlvlp	How to reconcile a Customer Account ? Post reply
	» Have you try to get reports from » Cash - Reports -Receipts Yes, but it doesn't provide the desired report. Thanks anyway.