Deleting Blank Batch ID

(0) Share

Report

Posted on by Community Member

Hello:

In researching a separate issue, I ran check links on Financial's "Transaction Work". This created a blank batch ID. Running Financial Reconcile per the error report's instructions afterward yielded no effect.

This blank batch ID is in the SY00500 table. There are no journal entries in GL10001 showing blank batch IDs.

There are several journal entries, however, in the GL10000 table showing blank batch IDs. Only one of these nine journal entries shows up in SmartList. This one journal entry has a DEX_ROW_TS field of today's date (04/05/2016).

SmartList shows no TRX Date or Batch Number for this journal entry. When I try to double-click on it in SmartList, I get a message saying that this journal entry has been entered in another window. One of the account numbers is described as an intercompany account. Perhaps, it comes from that module. I don't know.

In any case, so I can get rid of this blank batch ID and not have check links recreate it every time that check links is run, I want to know the safest way of getting rid of these journal entries. Shall I simply delete them from the GL10000 table with a script saying "delete ... where BACHNUMB = ''?

Prior to digging into the GL10001 and GL10000 tables, I did update SY00500 to fill in a batch ID in the BACHNUMB field, for this blank batch. Eventually, I was able to delete it in GP. But, after running check links on Transaction Work once again, it created this blank batch ID. So, I guess I'd better try to get rid of it by deleting these journal entries. It's not good, in my opinion, for file maintenance to keep creating such blank batches.

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Bill Campbell 12 on at

Like (0)

Report

John, I will dig into this with you, but first please asure us all that you have a solid backup of the data prior to making any SQL direct changes, and or that you can do all this testing in a TEST environment, where the SQL database is completely separate from the PRODUCTION system.

It sounds like work, but it is safety first.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bill:

Yes, the data is backed up. And, I have the means of testing this in a test environment.

Thanks!

John

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Transactions in the GL10000 the GL Work table should suggest that they are only there if you have them SAVED in a batch. Or I just happen to catch the table in mid data entry.

So, in the TEST system, I would see what happens when you remove all the transactions that Appear in Smartlist, but that do not have a batch ID and that are in the GL10000

If you don't want to remove them, then EDIT the content of the GL10000 and assign the batch ID to those transactions just as you assigned the batch ID in the SY00500.

When you next run the Check Links, you will either have matched them up - or there will be other errors.

Keep on posting

Was this reply helpful? Yes No
Mick Egan 3,561 on at

Like (0)

Report

John,

In my experience adding the Batch ID directly to the SY00500 and attempting to link to the GL10000 doesn't really work, as you have mentioned.

If the records have posted through to the GL20000, then I would delete them from the GL10001 and GL10000 table, then run your check links and Reconcile the GL Summary Tables.

If they haven't Posted through, then delete those records and just recreate the Journal again.

As Bill suggests, always run in a test company first, but I think this is your best option.

Occasionally we end up with these stubborn records that won't Post or Delete, and need to make careful a decision as consultants.

In the Test Company ensure you change the INTERID in the GL10001 table if attempting a Post.

Regards,

Mick

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report

Hi John!

I just wanted to follow up to see if you had any additional questions on this.

Please let me know! I am always happy to help!

~Thomas Newcomb

------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No