I implemented workflow for Vendor Approval in GP2015 R2. Within ten minutes we tried to run checks and received errors saying there were unapproved vendors. I had to turn workflow off in order to complete the check run. I am assuming I need to mark all current vendors as approved before I can turn the workflow back on. Since we have close to 4000 vendors I want to make the change to the vendor through SQL. When looking in PM00200 there are two columns, "Workflow_Approval_Status" and "Workflow_Status". All the documentation I can find only talks about one column. I have a few questions:
1. Are the definitions for the numbers appearing in these columns the same for both (and what is "0")?
2. Do I need to change both columns?
3. Should I change them to 6 (Approved) or 9 (Workflow not activated).
Right now Workflow_Approval_Status and Workflow_Status contain 0,1 or 0,9 or 9,9.
Thanks,
Marilyn
*This post is locked for comments
I have the same question (0)
