Delete Posted Batches in Payables and Receivables?

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (5)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

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.

Was this reply helpful? Yes No