Dynamics Community Forum Thread Details

Cash Receipts Disappearing

Hello:

Twice within the past week, we have had an issue where a receivables cash receipt has been entered and applied. But, prior to posting the batch of receipts, the cash receipt would disappear.

A record lands in the RM00401 keys table for the receipt with the TRXSORCE being blank. Also, GP's Receivables Transaction Inquiry window shows apply records attached to invoices. But, upon trying to drill back on the apply records, GP gives a message saying that the payment doesn't exist.

The Historical Aged Trial Balance (HATB) shows an accurate balance for the customer. But, GP's Customer Summary window shows an inaccurate balance for the customer. The Customer Summary window shows a lower balance, because GP "thinks" that the receipt has been applied to the invoices when it in fact hasn't.

We end up having to run delete statements on the RM00401 table for the customer and missing check, as well as on the apply records in the RM20201 table for the customer. In addition, we have to run update statements on the RM20101 table for the customer to force the CURTRXAM field to equal the ORTRXAMT field and the DINVPDOF field to be 01/01/1900.

Afterward, we run Reconcile Receivables Amounts on the customer. At that point, both the HATB and Customer Summary windows match with both being accurate. Then, everything is fine.

What would cause a cash receipt to, essentially, disappear and apply records to not actually apply themselves to the invoices? Is there a way of preventing this issue from continuing to happen?

Thanks!

John

Quick Links

Leaderboard