web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Transaction History Re...
Microsoft Dynamics GP (Archived)

Transaction History Removal Goof

(0) ShareShare
ReportReport
Posted on by Rich Mikolainis 705

I accidentally deleted a payment transaction (well, deleted it from the live database and not test).

What would be the best way to "re-add" this payment?

I looked in the database tables in our test database, and it looks like I would need to recreate the records from rm30101 and rm30301. There was data in rm30201 still. Would re-inserting the data into these 2 tables fix the issue?

Or are there any other tables to be concerned about?

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Rich,

    Why don't you just enter the transaction again from the user interface using the same document number that was on the original transaction. Since the old transaction no longer exists, you should be able to reuse the old number. Oh, I see, you still have apply information.

    I am surprised you could remove this record if Apply information exists. When you said you deleted it, did you run the Remove Transaction History utility, or was it deleted from the database directly?

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Rich,

    I just looked at my SQL tables to identify everyplace the specific document number was after I went through a removal (deletion). Here they are:

    CM20200----------CMTRXNUM

    CM20300----------RCPTNMBR and SRCDOCNUM

    GL30000-----------ORCTRNUM and ORDOCNUM

    RM00401-----------DOCNUMBR

    RM20201-----------APFRDCM

    RM30101-----------DOCNUMBR

    RM30201-----------APFRDCNM

    RM30202-----------APFRDCNM

    RM30301-----------DOCNUMBR

    I do not recommend going the SQL route to put the tables back unless you check with all of these tables and make sure your records are properly present.

    Kind regards,

    Leslie

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at

    Awesome, I appreciate the help Leslie!

    The weird thing is, even after I did the Remove Transaction History, the invoices still show as paid with a reference to the document number. Also, it all shows correctly on the aging report with these invoices being paid.

    I have a copy of all the data I need in the test database too.

    All the records exist in the rm30201 table from where I ran the remove utility, but not in the rm30101 or rm30301. I'll check out the others you listed too.

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at

    Leslie,

    I got the data added to the tables exactly how it was in my test company. However, when I go into

    Inquiry | Transactions by Customer

    enter the document number

    click the document number link,  then click apply

    One of the invoices is missing from the list (the panel is "applied to debits"). What table is used or should I check to make sure everything is correct?

    Thanks again!

  • L Vail Profile Picture
    L Vail 65,271 on at

    Rich,

    I left my computer in my office today, but tomorrow I'll take a look at the tables and see what I can find.

    Kind regards,

    Leslie

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at

    Thanks Leslie. It turns out, the user that entered this Cash Receipt 2 weeks ago, got a SQL error during the update process and never said anything.

    Re-adding the data to the tables worked perfectly.

    However, this same user applied one of the invoices paid by this "broken" cash receipt to another new cash receipt yesterday. (shaking head, hitting head on desk). I couldn't find any GL data either for the broken cash receipt either, so I think this issue goes even deeper...........

    I told her to call our GP resellers.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans