Aged Debtors Report & Client Payment Discrepancy

Issue

The Aged Debtors report shows a client owing money but the Client Payment window shows a zero balance.

Reason

This may be because a payment has been made at site A against an invoice raised for site B.

Solution

Update the site on the Invoice to match the site the payment was made at.

1. Click on  next to the client in the Client Header
2. In the Client Details window, click on the Accounts tab then click on the Invoices sub-tab
3. In the Client Invoices window, untick Only Show Unpaid Invoices and click Get Data.
4. Locate the invoice with the incorrect invoicing site and click on  to edit it
5. In the Invoices Details window, update the Invoice Site to the site where the payment was made
6. Run the Aged Debtors report again - the balance for the client should now be zero.

Note: If payment was made at site A and you do not want to change the payment site, the debt will show at the site it was invoiced at (site B) in the Aged Debtors report, because technically it is owed at site B.