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:

Not Submitted

Submitted (Deprecated)

No Action Needed

Pending User Action

Recalled

Completed

Rejected

Workflow Ended (Deprecated)

Not Activated

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.