How to Update Work Flow Status in Dynamics GP

Have you ever accidentally submitted a GL Batch for approval while setting up WorkFlow?  To correct the issue, you’ll need to update the workflow status of the GL Batch. You should be able to determine the pending action within the workflow by clicking the workflow button on the batch.

You can also use SQL scripts to locate and update the batch as follows:

SELECT * FROM SY00500 WHERE BACHNUMB = X

UPDATE SY00500 SET Workflow_Status = ‘Y’ WHERE BACHNUMB = X

Replace X with the batch number in question and Y with the correct code from below:

1. Not Submitted
2. Submitted (Deprecated)
3. No Action Needed
4. Pending User Action
5. Recalled
6. Completed
7. Rejected
8. Workflow Ended (Deprecated)
9. Not Activated
10. Deactivated (Deprecated)

Derek Albaugh has written a great blog about Workflow including information on 2.0 tables, what each one does, and what information you can get from them for reporting purposes. Click here to read his take.

To learn more about how you can take advantage of this and other Dynamics GP features, visit RSM’s Microsoft Dynamics GP resource. To make sure you stay up to date with the Microsoft Dynamics Community, subscribe to our Microsoft Dynamics Community Newsletter. For more information on Microsoft Dynamics 365, contact us.

By: Kelly Gray

Kelly Gray