rebuild gl batch header

(0) Share

Report

Posted on by Bill Campbell

We have run check links on the Finance module and we generated over 1,000 header records - matched to over 5,000 detail lines.

We know that they are all 'wrong' and need to be removed as they are all dated between 2015 and 2019.

So in the TEST company we ran a number of scripts to remove from both the GL10000 and GL10001 tables all these errors.

Now when we check in the application and open the Finance >> Batch selection we still had the batches. So we ran script to remove these batches as well. Now only have recognized 'current' batches in the SY00500.

However, we have created a situation where each time we open a Finance Batch and then click Transaction - to open the transaction window, we get a message that the batch already exists, then the batch id is blanked and the remainder of the information remains correctly.

We post a separate case.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Cheryl Waswick on at

Like (0)

Report

RE: rebuild gl batch header

I agree with Richard to clear out the activity tables.

Also, make a current backup (or do this in a test company first) and run check links on FINANCIAL - TRANSACTION Work, to see if that helps. This process is no reversible, so always have a backup prior to running check links.

If you have any 3rd party products installed (such as MEM), they may also have their own Batch master tables, that should also be cleaned up. You would have to consult your 3rd party for assistance with that.

I hope that helps,

Cheryl W
Microsoft Dynamics GP support
Richard Wheeler 75,788 Moderator on at

Like (0)

Report

RE: rebuild gl batch header

Check the DYNAMICS.SY00800 and DYNAMICS.SY00801 tables after getting every one out of GP. Make sure there are no records in them along with the TEMPDB.DEX_LOCK and TEMPDB.DEX_SESSION tables.