You’re offline. This is a read only version of the page.
277
Hi,
We run the Paid transaction removal about once a year. I have it setup in the Receivable module that history is to be kept on all of the options. Before we run the process, we run a count script against the sql tables to verify that the amounts moving equal out. The problem we are having is in the RM Open Apply (RM20201) and RM Hist Apply (RM30201) tables. The amounts moving from one table to the other do not match. Is it possible these lines are being deleted or maybe moved somewhere else?
Scripts showing difference before and after PTR:
select 'RM20201' as TBL, COUNT(*) as RowCnt from RM20201 UNION
select 'RM30201' as TBL, COUNT(*) as RowCnt from RM30201
I think this may be a non-issue. I did a bit of research and found that items can exist in both the RM20201 and RM30201 tables if a payment has been partially applied. I was able to test this with one payment that was ready to be moved to historical. It had 22 apply lines in the RM20201 table and 18 in the RM30201. The 18 lines existed in both RM20201 and RM30201. When we ran the paid transaction removal process, it removed any apply lines that had a date before the date entered into the Paid Transaction Removal window from the RM20201 table. It did not add these lines to the RM30201 table because they already existed there. This is the difference I am seeing when running the process.
Hey RJarrell,
I would check all your customers to see if they are marked to maintain history. If not, PTR will remove the data instead of pushing it to history since you do not maintain data. You can check this on each of the Customer Maintenance Options window.
If that is not helpful, then you are going to need to determine what transactions are removed and then review the data before PTR and see if there is damage or not.
I hope this helps!
Thank you!
Brandon | Microsoft Support Engineer.
Hi, thanks for your response. The problem I am having is it seems that some lines of data are just disappearing.
For example, the OPEN table drops 10,000 lines but only 6,000 lines are appearing in the historical table. So it seems like 4,000 lines just disappeared.
The good news is, the Paid Transaction Removal utility allows users to keep their paid transactions in GP considering your administrator has configured historical transactions to be kept within the database. With this setting in place, the Receivables Paid Transaction Removal utility will move fully applied transactions to history*.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (