Announcements
No record found.
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.
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
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.
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.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 797
André Arnaud de Cal... 589 Super User 2026 Season 1
Subra 534
