nav-left cat-right
cat-right

Microsoft Dynamics GP Error- Batch is Marked for Posting By Another User

There are a few questions I get asked almost every week. Over the next few week’s I’ll try and document details about these common problems and resolutions.

Error message:

“Batch is marked for posting by another user.”

This is one of most common error messages displayed in GP. Usually, in such a case a batch is visible in the lookup list. However, when you try to open the batch, the above mentioned error message is displayed.

Solutions

You can try using the Batch Recover Window (Microsoft Dynamics GP menu >> Tools >> Routines >> Batch Recovery). Mark the batch using the checkbox and click on the Continue Button .

If this does not work, you will need to use a SQL script recover the batch.

Option 1: Ian Stewart has posted SQL scripts to clear the batch activity and update batch status

http://dynamicsgp.wordpress.com/2009/06/03/batch-stuck-in-posting-receiving-busy-etc-etc/

Option 2: For executing the scripts in option 1, you will need to make sure all users are out of GP. However, for some companies with large number users working in different time zones, forcing all users out may not be as easy as it sounds. In such case, you can refer to following blog post by David Musgrave.

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx

Option 3: If you don’t want to run scripts, you can download Microsoft Fix it 50435 for fixing this issue

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYMXTYYKSWTLKQNNOXUXMTUUZKTNMWWVUXVLVWZKTSMQYLQUML

For further information about Microsoft Fix It solution refer to following blog post

http://blogs.msdn.com/b/dynamicsgp/archive/2011/06/01/fix-it-solutions-available-for-microsoft-dynamics-gp-2010.aspx

Additional Resources: If the computer checks batch was stuck, you can further refer to following knowledge base article for steps to reprint the checks or post batch of already printed checks

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYMXTYYKSWTLKQNNOXRVYKZWYLMPWXRUPPRPNOZWXYZOZZMOSY

12 Responses to “Microsoft Dynamics GP Error- Batch is Marked for Posting By Another User”

  1. Luis says:

    Dear Rubal..
    Do you know how to exit the users login in GP but no are using the system, this is because they are using licence and not work in the system and other user can not to work.
    Thanks and I hope your help.

  2. Rubal says:

    Hi Luis,
    You view and delete logged in users from User Activity window (Microsoft Dynamics GP menu >> Tools >> Utilities >> System >> User Activity). You can also view the date and time since user is logged in this window.
    If you want to do the same with logging into GP, you can run query against the table ACTIVITY in DYNAMICS database from SQL Server.

    Also, there is a third party product Dynamics GP Toolbox by Rockton.

    http://www.rocktonsoftware.com/products/product.aspx?p=C5B12B08-B757-DF11-B9CC-00505685016F

    It has option to automatically log-out inactive Users.

    Thanks,
    Rubal

  3. Amit Verma says:

    Hi Rubal,
    Can you please help us for a issue, we need to automate the process to transfer Sales Order to Invoice, Sales Order to Backorder etc.

    Please help us , we are stuck.

    Thanks,
    Amit Verma

  4. Yasir says:

    Hello Rubal,

    My issue at the moment is to customize the Payroll Summary (Check Register) which comes with other reports after processing the payroll from HR to Financial. What I need to do is to include an additional column that will display Bank Account Numbers for each Staff.

    Please Help.

  5. [...] Microsoft Dynamics GP Error- Batch is Marked … – Dynamics GP Help VN:F [1.9.20_1166]Please wait while your rating is cast…Rating: 0.0/10 (0 votes cast)VN:F [...]

  6. Rizwan says:

    Hello Rubal,

    i have a problem that the posting date and creat date is not showing correct please tell me how to fix this issue in GP 2010

    please help me

  7. Mrugesh says:

    Hi Rupal,

    We are working on Darwin 10.28 and we have issue in one of our database that when user try to post invoice and she face this message ” data entry exist in batch . Use batch recovery window to process this batch ” I had tried to fix this issue by help of Option 1 as per your blog but its not worked for us. Will you please help to resolve this issue ?

    Mrugesh

Leave a Reply