Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GL Batch Posting Error

Posted on by 1,780
Hi, User is getting the following error while posting GL Batch. The stored procedure glpBatchCleanup returned the following results:DBMS:0,Microsoft Dynamics GP:20488. When I click to see more information: glpBatchCleanup. Error occured attempting select from Batch_Headers I have applied a solution on knowledgebase Article No.898996, but this is happening frequently. Any ideas Thank you, Mohan

*This post is locked for comments

  • RE: GL Batch Posting Error

    Hello Punugu,

    I just wanted to mention also, while I'm sure you're aware, that Dynamics GP 10.0 is no longer supported at all by MBS Dynamics Support, so you'll want to look at getting upgraded to a supported version before too long.

    The last thing we'd want to see, if you're not able to get support from a forum like this, is to have your production environment on an unsupported state, where we wouldn't be able to assist with any technical support, other than if you were actually in the process of upgrading to a supported version.

    Thank you!!

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: GL Batch Posting Error

    I found this list of Batch Statuses from Accolade's old web site:

    www.accoladepublications.com/.../393-batch-status-codes.html

    0 Available

    1 Batch is currently posting.

    2 Batch is currently being deleted.

    3 Batch currently receiving transactions from outside the module.

    4 Batch is done posting.

    5 Batch is currently being printed.

    6 Batch is currently being updated.

    7 Batch was interrupted during posting.

    8 Batch was interrupted during printing.

    9 Batch was interrupted during updating of tables.

    10 Recurring batch has application errors and one or more transactions did not post.

    11 Single-use batch has application errors and one or more transactions did not post.

    15 A posting error occurred while trying to post a batch of computer checks.

    20 Batch was interrupted during the processing of computer checks.

    25 Batch was interrupted during the printing of the computer check alignment.

    30 Batch was interrupted during the printing of computer checks.

    35 Batch was interrupted during the printing of a check alignment form before reprinting checks.

    40 Batch was interrupted during the voiding of computer checks.

    45 Batch was interrupted during the reprinting of computer checks.

    50 Batch was interrupted during the processing of the remittance report.

    55 Batch was interrupted during the processing of the remittance Alignment report.

    60 Batch was interrupted during the printing of the remittance report.

    100 Batch is processing computer checks.

    This Batch Status field is in the SY00500 table in the company database.

    Also, if you have any modified forms or reports, export them to a package file, create an empty reports dictionary and try again. Next, import the package files you created earlier into the blank reports dictionary.

    You could also try to rebuild the auto procs by dropping and recreating them in the SQL maintenance window.

    The last thing I can think of is to go into the Database Maintenance Utility and recreate the stored procedures.

    Kind regards,

    Leslie

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Batch Posting Error

    Fixed my isssue. Thank you

  • Sergio Ferreira Profile Picture
    Sergio Ferreira 30 on at
    Re: Re: Re: GL Batch Posting Error

    I think I fixed my problem. I took out my modified reports dictionaries and everything worked properly. I then re-imported from a package file and everything still worked. I then put the old dictionaries back and everything broke again. I exported a reports package from the bad dictionaries, took out the dictionaries, and imported that package in and everything worked.

  • Sergio Ferreira Profile Picture
    Sergio Ferreira 30 on at
    Re: Re: GL Batch Posting Error

    I have two systems with the same issue described in this thread happening in all companies. If we tell it to not print any of the reports, the error does not occure. Both systems are running 10.00.1411 and Windows Server 2008 R2. 10.00.1424 has been released since this systems were installed, but when I checked the fix list, there is no mention of this issue. I'm going to try dropping and recreating the auto procedures tonight.

  • Re: Re: GL Batch Posting Error
    Hi! Thanks for all replies on this issue. GP version is 10. It is happened earlier about 3 or 4 times. Now every batch that the user is trying to post this message is appering after posting. GL Journals are entered manually and there is no third party integration or any customization. They are not using RD to use GP. They enter transactions using GP client PC. I have tried Delete statements which is a part of KB article that I mentioned. I will try SQL Maintenane and see how it goes. Thanks once again for your inputs. Mohan
  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: GL Batch Posting Error

    I will go under the assumption that you are using GP 10.

    I have seen this issue a number of times when, for whatever esoteric reason, the Batch Header table auto-stored procedures become corrupted. In order to fix, you will need to use the SQL Maintenance option under MSDGP > Maintenance > SQL to locate the Batch Header tables and drop and recreate the table auto procedures.

    If this does not fix the problem, then you can attempt to rebuild all stored procedures using the Microsoft Dynamics GP Database Maintenance utility. For more on the Database Maintenance utility read my article Microsoft Dynamics GP Database Maintenance Utility.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GL Batch Posting Error

    Hi, easy to fix, but hard to diagnose!!

    Does this happen every time you try and post a GL batch?...or is it intermittent?

    Did you try running the following queries? (Get everyone to logout of GP first)

    • DELETE DYNAMICS..ACTIVITY
    • DELETE DYNAMICS..SY00800
    • DELETE DYNAMICS..SY00801
    • DELETE TEMPDB..DEX_LOCK
    • DELETE TEMPDB..DEX_SESSION

    Does this sort the issue and allow you to post? Do you have any bespoke developments? Where are the GL journals coming from...i.e. are they manually entered?

    Are users logging over Remote Desktop? Are they closing out of GP properly before killing their RDP session?

    Best regards,

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