You’re offline. This is a read only version of the page.
Announcements
Hello There!
I need to run something by some very knowledgeable people here on the Forum. I'm newer in the GP consulting world and working with a client who has done the following:
They sold their company as of a certain date and were not supposed to post anything in that company after the sale. They inadvertently posted batches in AP and AR as well as checks and have also reconciled the bank account.
The client is asking if there is an automated way to delete those batches in payables, receivables and unwind the reconciliation in bank module and then bring them into the new company to be posted.
My first thought was why not restore the backup and only have to reenter the couple days after the sale into the new database. Unfortunately not only did they post after the sale date but they also posted a lot of other activity in a prior month so restoring a backup is not an option.
Any suggestions on what to do? I know we can't "unwind" the bank reconciliation as they are asking. That is just not something that can be done. Any ideas on deleting batches / activity that was posted?
I would greatly appreciate any ideas on how to help them.
Thank You
Dawn
*This post is locked for comments
I'd echo the "do not try deleting the transactions" sentiment; there are a lot of tables from transaction tables, to summary tables to balance tables, all of which will hold information on the transactions and not all of them will have the transaction reference.
Voiding is by far your best route.
The best way to correct this is to Void the transactions. If there are many to void, use a macro to do so.
As to 'unwinding the bank rec', this can be done. Have a look at this article - community.dynamics.com/.../undoing-a-bank-reconciliation-after-it-s-already-been-posted-for-dynamics-gp.aspx
Hello dberard
We have developed a solution to completely remove selected transactions from the database level. We have a client who asked recently to remove a selected year transactions from all the modules, for instance; you have the following years 2012,2013 and 2014, our task was to remove selected years (2012 and 2013) to be archived while keeping the live company with 2014 transactions only. This was completely done on the database level, and required high-level of consideration and understanding of the database structure
In this essence, I do not recommend deleting transactions from the database level, you might need to consider the alternatives provided by the gentle men above.
Your feedback is highly appreciated,
Dawn,
Deleting posting transactions is not 'option' it is not only 1 or 2 tables which affect there are several tables get updated when you post transactions into Dynamics GP.
Best way to Void all transaction you don't want in AP and AR side. This way it will affect your subsidiary (Bank and Customers/Vendors) and GL as well.
Do all R&D on test environment and make sure to keep good backup before you do any voiding.
Let me know how it goes.
Thanks
Sandip
Hi Dawn,
My suggestions as follows.
1) Take a list of all transactions fro smart list which includes - Financial, Sales, Purchase & Inventory
2) Restore the backups
3) Remove the old transactions which you don't want to post from all transactions list
4) Post all the new transactions by macro or integration manager
#1
André Arnaud de Cal...
293,442
Super User 2025 Season 1
#2
Martin Dráb
232,575
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (