Why batches get stuck
Chances are you’ve had a batch stuck in Dynamics GP. There are a number of reasons why, but most of the time if a batch gets stuck and needs to be recovered, it’s because a user is in the middle of posting and either Dynamics GP freezes, or their computer loses connection with the server.
We also see batches get stuck when users do not sign out of Dynamics GP properly. Sometimes, a user will click the red X in the top right corner of the Dynamics GP window while still having other windows open. This can cause batches to show as “Marked” for posting. Make sure that you first close out of all windows, saving any documents you have open, then click the Microsoft Dynamics GP button, and choose Exit.
How to fix it
If a batch shows a status of “Marked,” you can open the Series Posting for the series you are in (e.g., Purchasing, Sales, Financial, Inventory), or you can go to the Master Posting in the Administration area page, and unmark the batch without any intervention.
Here is an example from Sales Series Posting.
If you look up a batch and it shows “Transaction Error – Edit Required,” then you can open Batch Recovery (Administration area page > Routines section > Batch Recovery), mark the box next to the batch, and click the Continue button. Notice that when you mark the batch, the status will change to “Edit Required.”
After the batch is recovered, go into the area page related to the batch, select the appropriate batches option, which will depend on the origin of the batch, and select the batch. Then click the Print button to print a Batch Edit List. Look for error messages within the Edit List, which will indicate what needs to be done to correct the batch. Next, open the transaction(s) with the error, make the necessary corrections, and you should be able to post the batch.
There are times when the batch will continue to be stuck in Batch Recovery. When this happens, contact us at support@crestwood.com. We will review the data in Microsoft SQL Management Studio and release the batch so that you can continue processing. Be sure to send us the Batch ID number that is stuck and screenshots of any error messages. If an error message has a ‘More Info’ button, click that button and send the screen shot of the error with the More Info portion of the window open.
