SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to index page
Thread view  Board view
DavidJ(R)

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(R)

04.09.2016, 05:07

@ DavidJ
 

How to reconcile a Customer Account ?

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(R)

13.10.2016, 06:52

@ sqlvlp
 

How to reconcile a Customer Account ?

Have you try to get reports from
Cash - Reports -Receipts

Yes, but it doesn't provide the desired report. Thanks anyway.

Back to index page
Thread view  Board view
963 Postings in 317 Threads, 321 registered users, 127 users online (0 registered, 127 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum