AR Paid Transaction Removal not removing paid transactions

(0) Share

Report

Posted on by Richard Wheeler

75,730

What would prevent the AR Paid Transaction Removal routine from not removing paid transactions? I was asked to clean up years of neglect. Running PTR first removed about 5,000 records. Howevere, it has left 34 records behind. RM20101.CURTRXAM equals zero for all of these transactions. I have tried to remove them again to no avail. If I zoom on these documents and click apply I see the document that pays them off. However, I just discovered that these documents do not exist. Is this why they do not go to history? Do both the invoice and the payment have to exist? This is GP 2010.

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (1)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: AR Paid Transaction Removal not removing paid transactions

I have one transaction that refuses to move to history. This invoice was paid. I can see the payment in the RM30101 so somehow the payment was applied and the payment moved to history but the paid invoice did not. I will create a script to move it from RM20101 to RM30101.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: AR Paid Transaction Removal not removing paid transactions

Excellent tip. I would have never thought to check that as I assume everything in this table would be marked as posted. This just goes to show why you should never assume anything. There were 36 records like this. I can only assume this flag was never set during posting.
Verified answer

Gavin 2,341 on at

Like (0)

Report

RE: AR Paid Transaction Removal not removing paid transactions

Hi,

Out of interest is the POSTED field in the RM20201 apply table for these records set to 0? I'm sure I've had this in the past, and setting this to 1 enabled me to transfer them to history using Paid Transaction Removal routine.

Hope this helps.

Thanks

Gavin