Hi Jetline

Have you check Maintenance, Integrity Summary window? Is the  Account receivable and Unpaid invoice are out?  

If yes, you can try to run a Rebuild using database Utility tool, to see if this is data related by follow Knowledge Base Article 10403  (made sure data is local)

If rebuild does not help, you can try to Knowledge Base Article 10222

Hope it helps

Thanks for the help Jason. I do see a difference between AR and Unpaid invoices balances on Integrity Summary window. The difference is same as combined total of those 2 invoices.

My concern is to figure out what went wrong. Is there a way to further drill down on these reversing entries? If the invoices were reversed through Receivables Journal, the system would force me to create a credit note which was not the case here. The receipt of payment and invoices it was applied to are still there. Only thing I think of is correcting the jobsite allocation for these invoices which shouldn't reverse the invoice.

Thnx

Hi Jetline

If you ran the rebuild already, you can try to generate a customer aged detail report and compare with a General ledger A/R report, see what is the difference.

Common cause for data integrity issues, I would say

1. Un-link a control account post general journal

2. false opening balance to start with company with