One of our customer's account balance is really messed up and we cannot determine how to fix it. In headquarters manager, under the account tab in the customer's properties, it correctly shows the right running balance. they owe us for two invoices totalling $52.90. however when we run the accounts receivable detail report, it shows them still owing for four other invoices, for a total of $441.78. and when we close the billing cycle their statement shows that they still owe for these invoices too.
the four invoices that they do not owe for were actually from a previous software program. we entered them manually into HQ as debit adjustments. then we selected them in headquarters and adjusted them with a credit adjustment to show the balance was no longer due.
i ran a query against the customer table and this customer's accountbalance shows up as 52.90 while their lastclosingbalance is 441.78
i also queried the accountreceivable table for this customer's ID and it only shows a total balance due of 52.90 for the two invoices i mentioned previously?
what is going on here and how can i fix this??
thanks, kevin