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
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
Richard gives good advice just be sure nothing has been added to the history tables since the removal.
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.
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?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156