Sage 100

Client on v5.1 received and Error 106 AR_SalesJournal 2211 when posting AR Invoices. Now 2 of the invoices that posted through are not showing in the AR Trial Balance. They show everywhere else (Aging, customer file, etc). Any ideas on what file is affected/missing here? We rebuilt all the AR History and Transaction files, but no luck.

Sounds like maybe they hit AR_Open & AR_InvoiceHistory but maybe the records don't exist in AR_TransactionPaymentHistory

I agree with Nicole. You'll probably have to create the records in that file.

Ok, I will check there. I've not created a key in that file before. Any words of wisdom other than back it up first?

I think one trick is copy everything to test, post, then take JUST the AR_TransactionPaymentHistory back into live. Naturally everyone in live has to stop while you do this. Depending on urgency might be an easier after-hours task. Maybe there's a better way but that's my first thought.

Great Idea Wayne!

It is choking on an invoice date.

Look at InvoiceDate fields in the Invoice Header file

The rebuild seemed to allow everything to post through. And I actually bit the bullet and just created new keys in the AR_TransactionPaymentHistory File, Since there were 5 other invoices that did post through, all the other info was right. I just had to change the invoice number and amount. Thanks so much for all the quick responses!