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.
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.
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 665 User Group Leader
Martin Dráb 595 Most Valuable Professional
Yng Lih 558
