Hi There
I have the following purchase order workflow set up
A purchase order is created.
This is supposed to have an approval status of 'approved' if the total value of the purchase order is less than $1,000. If the value is greater than $1,000, it is supposed to have an approval status of 'pending approval' and a custom field called 'approver' is supposed to default with the name of an employee based on the approval limits set up for employees in their employee records.
So far, the approval status being either pending approval or approved based on the purchase order total is working mostly as expected on creation of a purchase order.
However, I can't see how to have a dynamic approver set based on the employees approval limits.
I tested this with setting a value (e.g. if approval status is pending approval, set the field value of approver to Joe Smith). That works fine though is there a way to achieve this without a bunch of "if conditions" and use a lookup instead?
i.e. if total> $1000 and total <$1500 approver is Joe Smith
else if total>$1501 then approver is Jane Doe
I also can't see how to have the approval status change on the purchase order being edited.
e.g. The purchase order might have a total of $100 due to a typo in quantity. As a result, the approval status is 'Approved' and the order is 'Pending receipt'.
If I try to correct the quantity by editing the purchase order so that the purchase order total is now $1100, the approved status does not change and the order still shows as 'pending receipt'.
Below are screenshots of the workflow set up: