You’re offline. This is a read only version of the page.
Announcements
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
A recommended update for Vendor Approval Workflow to avoid issue after activation would be the following:
update PM00200 set Workflow_Status='9'
Alternate 'Workflow_Status' Values:
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)
Best Regards,
Jeff
Microsoft Dynamics GP support
Hi Marilyn,
from pm00200's perspective, this might help.
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)
I hope you had better luck implementing than I have in Gp2016R2. It seems the Vendors Pending Approval navigation list is horribly designed. It starts looking for pending approvals from the entire PM00200 table instead of the workflow tables. My client has three times the number of vendors as you, and it takes almost 15 minutes to complete generating any list of pending vendor approvals.
#1
André Arnaud de Cal...
293,333
Super User 2025 Season 1
#2
Martin Dráb
232,347
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (