Sage 100

A client had a problem when updating invoices in AR. Corrected the records in AR_OpenInvoice and AR_TransactionPaymentHistory. All invoices updated to the history files correctly. I would have thought fixing AR_OpenInvoice and AR_TransactionPaymentHistory would correct the issue with an invoice missing from the customer statement, but it did not. Did I miss a file that feeds statement printing? Should I try rebuilding, sorts?

Also rebuild key-files on the Open Invoice and Transaction files - they have multiple-keys which may not have gotten corrected.

also rebuild sort files there is a file AR_AlternateInvoice.m4t that will get re-created. it might be used by the statement printing

I had this several years ago. There were quite a few files involved. I would have to dig up the list. Statements calc the invoice balance so they ignore the balance in the open invoice file. I want to say the tax summary and/or tax detail files were involved.

The magic rebuild sorts did it. Thanks everyone.