Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Removed Purchasing History by mistake

(0) ShareShare
ReportReport
Posted on by 2

I have a client that accidently deleted purchasing history rather than moving open records into history.

I'm trying to determine what is best course of action to recover these records.

They have an SQL backup of the database.

Any recommendations or thoughts?

I'm wondering if SQL copy of tables would be better than integrating the payments/vouchers that were removed?

Thanks in advance.....

 Bron Tamulis

BT Associates

*This post is locked for comments

  • Bron Profile Picture
    Bron 2 on at
    Re: Removed Purchasing History by mistake

    Thank you everyone that replied.

     I was able to import from history tables (of a previous backup) into the production history tables. The process was complicated by the fact(s)

    1. When Payables Transaction History was removed - the history tables PM30200 - PM30300 - PM30600 were not completely cleared because the client had lots of unapplied posted documents that do not get cleared/deleted.

    2. Backup was for weds evening - on thursday am 12 checks were processed - on thursday afternoon (after check run) the history transactions were deleted. 

    Once I figured out how to merge the tables and identify the thursday morning checks/payments that were in check register but not in AP........I was okay.

     Thanks - These forums  are very valuable to our mutual success.

    Bron Tamulis

    BTAssociates.net

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Removed Purchasing History by mistake

    Richard gives good advice just be sure nothing has been added to the history tables since the removal.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Removed Purchasing History by mistake

    Hello Bron, long time no talk!

    You should be able to restore the SQL backup to a different company and copy the history tables.  Be careful, of course, to get all of them.  Then run Checklinks followed by Reconcile to rebuild the key tables.

     

     

  • Sudin B Profile Picture
    Sudin B 370 on at
    Re: Removed Purchasing History by mistake

    Bron, How many records (approximately) were accidentally removed? Is it too late to restore the entire database and just re-enter the new transactions since the backup?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans