I have a scenario that I am troubleshooting with a PO workflow that involves multiple cost limits that require review steps before moving to a final approver.
I have User A with a base spending limit of <=$10,000 which doesnt require any further approver and the PO workflow completes. The next level is >$10,000K but <=$100,000, which requires an approval from User B. Up to this point the workflow works correctly. Where the issue comes in is at the next level approval, User A submits a PO >$100,000K but <=$250,000, we have a review step in place that should be assigned User B for review, bit because the amount is over their approval limit, it must then pass to User C for final approval as it is within their approval limit. What is happening is the process is skipping User B and going straight to User C. I have not found a way to "force" the workflow to stop at each review step and pass to the correct approver step.
The workflow gets more complex as there are at least 3 more levels. If we expand to one more limit of >$250,000 but <=$500,000 what i need to happen is User A submits a PO within that range, User B must complete review step as it is over their approver limit and must then go to User C, then User C must complete review step as it is over their approver limit and finally User D approves as it is within their limit.
I am using workflow user as Assignment type and have the user groups setup with the correct users.
Again the flow must stop at each review step and assign to the user in the user group before moving to the next reviewer or approver.