SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the board
Thread view  Mix view  Order
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 the board
Thread view  Mix view  Order
991 Postings in 327 Threads, 327 registered users, 63 users online (0 registered, 63 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum