Sage 100

v2016 std - client has 13 invoices in Open AR that were paid. Balance due field is zero, cash receipts report show the invoice being paid. Unfortunately, system burped and no paid transaction records were written to the AR_TransactionPaymentHistory table. When the aging is generated, records do not appear. Same with the TB. Client wants the payment transaction records posted. What is the simplest way to remedy? I am thinking about copying live data to test company. Change balance due in openinvoices to invoice amount, post via cash receipts again, update, then copy the AR_TransactionPaymentHistory table back to the live company. Is there an easy way to create an accurate record in AR_TransactionPaymentHistory via DFDM? TIA

You can find a similar record, change the key and answer no to ""Do you want to remove the current record"". That would create a new record that you can then change fields other than the key fields if necessary. Of course, make a backup of the file before messing with it. I like idea of copying the live data to a test company, post the transactions equivalent to the missing records then copy the AR_TransactionPaymentHistory file back to the live copy. This approach is more work but safer.