web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Paid Transaction Remov...
Finance | Project Operations, Human Resources, ...
Suggested answer

Paid Transaction Removal Completely Removing Apply Data?

(0) ShareShare
ReportReport
Posted on by RJarrell 311

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

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    RJarrell Profile Picture
    RJarrell 311 on at
    RE: Paid Transaction Removal Completely Removing Apply Data?

    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.

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Paid Transaction Removal Completely Removing Apply Data?

    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.

  • RJarrell Profile Picture
    RJarrell 311 on at
    RE: Paid Transaction Removal Completely Removing Apply Data?

    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.

  • Wallaceers Profile Picture
    Wallaceers 5 on at
    RE: Paid Transaction Removal Completely Removing Apply Data?

    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*.

    Securitas ePay

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.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans