Dynamics Community Forum Thread Details

Cash Payment Void did not trigger as reconciled in Bank Rec.

Hi.
Client voided (back in 2011) two cash payments applied to AP invoices. From what I've tested, when a payment is voided, it shows up in the checkbook register as reconciled. However, there must have been some disconnect when the transaction was posted, because even though the document shows as voided in the Vendor Inquiry and in the Checkbook Register, it DOES NOT show as being reconciled.

Therefore, when client was reconciling this month, they see that the two cash payments are available for reconcile. I've tracked everything back and forth and a confirmed they transactions are all the same (i.e. no replacement transactions).

I updated the CM20200 table field RECOND = 1 for the two records. Now, the bank rec does not show the items and the CB inquiry shows that they are reconciled. However - my adjusted book balance is off by the amount of the two voided documents.

Do I need to update other CM tables? User the reconcile utility? Or make another entry?

Victoria has graciously posted info about the CM tables here: http://victoriayudin.com/gp-tables/bank-rec-tables/

Thanks in advance!!!

JIM

Quick Links