Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Deleting Blank Batch ID
Microsoft Dynamics GP (Archived)

Deleting Blank Batch ID

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Deleting Blank Batch ID

    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

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Deleting Blank Batch ID

    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

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Deleting Blank Batch ID

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Deleting Blank Batch ID

    Hi Bill:

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

    Thanks!

    John

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Deleting Blank Batch ID

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans