I'm not sure if this is possible, and if so, the best way to approach this.
I have a request to
- Add two custom amount fields to the purchase header table.
- Add a amount tolerance field to the User Setup Table.
- Create a new tolerance approval table, to allow an approver to approve multiple specific users.
When a purchase header is released, I need to compare the two fields in the purchase header table, and if there is a difference, set the record to pending approval, fire off a notification to all users in the approval table who are linked to that user.
I haven't done much with workflows, but from what I can tell, you can't compare two fields in the on condition field. So my thought is to do the comparison on release of the document, and if there's a variance, fire off an approval workflow. But I'm not sure how to have it check the new tolerance approval table, loop through the approvers and then create an approval notification only for the ones associated to the logged in user.
Has anyone done something similar, or have any ideas?