Travel Expense Workflow based on Travel Cost
We are implementing Travel Management and our requirement is as below.
For e.g:Lets assume emp X1 creates a travel request for $5000. X1 immediate supervisor(or approver) X2 has a limit of $2000. X2 supervisor X3 has a limit of $4000.X3 supervisor X4 has a limit of $10000. X1's travel request should be routed to X4 with fyi notificaitons to X2 and X3.
My initial thoughts were to create a custom table and store the approvers details along with the limits($ amounts). Instead of using rule 168 I would have a custom code to determine the approver based on the travel cost.
Is there a better way of handling this requirement? I would appreciate anyone sharing their experiences in this type of request.