web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Great Plains batch problems

(0) ShareShare
ReportReport
Posted on by 130

Good day i am having challenges with great plains 10 since we experienced a power failure while users were posting in batches.

1.  some transactions go missing from the trial balance and can only be seen in the inquiry screen they don't show on reports or anywhere else but if the transaction is reposted the figures double.

2.  there are part payments that have been entered can be seen in the  applied screen but the invoice has a zero balance even though there is a balance.

3. some invoices showing a zero balance on the invoice but in the applied screen there is no information about that payment even though it was posted.

4. transactions that are completed are still showing as open. 

Please assist me with this challenge.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at
    RE: Great Plains batch problems

    Hi,

    Some of the transactions might corrupted please do the following and before doing this please take a backup and logout everyone out of GP.

    SELECT * FROM DYNAMICS..ACTIVITY
    SELECT * FROM DYNAMICS..SY00800
    SELECT * FROM DYNAMICS..SY00801
    SELECT * FROM TEMPDB..DEX_LOCK
    SELECT * FROM TEMPDB..DEX_SESSION

    If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.

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

    Then run the following against the company database if you have any specific batch which you couldn't access.

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
    (Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    RE: Great Plains batch problems

    Are these accounts payable or accounts receivable batches?

  • Tim W Profile Picture
    2,925 on at
    RE: Great Plains batch problems

    If you are unable to restore from a backup prior to the power failure for business reasons then my experience with similar situations is that you will need an experienced consultant with GP table knowledge to right this situation.

    When GP posts a batch it will first copy records from work to open (those that are 'post-able'), then print posting reports, then clean-up the work records.  Based on your description you have one or more batches that have multiple transactions in both the work and open tables at the same time.  Here you need to decide what is really posted, have summary tables been updated, are all records in work posted or do some still need to be posted etc...  Is status correct for the documents in RM00401 ...

    Not simple or easy but quite fixable by the proper resource.  It's not something I've ever seen checklinks address, I don't see a quick fix here unless you can roll back.

    Best

    Tim

        

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Great Plains batch problems

    This is the situation where; unfortunately, there is no quick fix since the damages can not be simply evaluated. The possibilities are quite too many and definitely requires the involvement of a specialized consultant.

    In Dynamics GP, data go through multiple stages as it is saved and posted. Several tables and values are stored according to the type of the transaction and its associated details.

    Calling Microsoft for a support ticket would be a good option

    Although, let us know if there is any useful thing we could provide

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    RE: Great Plains batch problems

    I agree wholeheartedly with Mahmoud and Tim.  It sounds like you have some significant data corruption.  However, prior to doing table surgery, I would restore the production database to a test company and run Check Links in the test company to see if it fixes any of the issues.  That would at least reveal whether you can pull this patient through with minimally invasive surgery :)

  • Raynold Maxwell Profile Picture
    130 on at
    RE: Great Plains batch problems

    This problem occurs with both payables and receivables batches

  • Raynold Maxwell Profile Picture
    130 on at
    RE: Great Plains batch problems

    Thanks for the response.  I am currently testing the solution you proposed

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans