Sage 100

MAS 4..5.2 AR Invoice missing balance in AR Open Invoice and AR Inv History Header, transaction missing from AR_TranasactionPaymentHistory. The invoice posted to GL correctly. I manually corrected the records in DFDM but when I run the AR TB the transaction amount column still shows 0.00. What am I missing? Thanks,

If you only corrected AR_OpenInvoice and AR_InvoiceHistoryHeader, there still are no transactions. Are you sure it posted correctly to GL? Was this through SO or AR? If SO, is inventory correct?

Double check the AR Transaction Payment History file. Required for the TB.

Through AR and yes to GL I see the posting in the AR account. I manually created the record in AR_TransactionPaymentHistory but the transaction amount still shows 0.00 on the TB.

Was the posting to GL in balance? I've had this happen where the invoice total is zero and is not included in the AR posting but the revenue/cost accounts are correct.

What I've done to correct the zero balance invoice amount is to do an adjusting entry to the invoice, posting to the AR account so no net effect but then the invoice total is correct. (In my case, I then have to do a one-sided entry to correct the oob register.)

Since the TB is date-driven, double check the date in your AR_Transaction file record - and all other fields carefully, like having the cust & inv # fields exactly the same as the open-invoice rec.

There is another table called AR_AlternateInvoice - honestly not sure if it is used by the TB or not but I know for past experiances that it has a record for every invoice in history table

I confirmed they are the same. Using crystal I recreated a report using AR Transaction - the transaction amount shows 0.00, though I see the $5000.00 in DFDM

have you tried re-building sort files?

I had tried that before and it just tried again and WOW it appears on the TB. Thanks!