How to configure exceptional approval limit in AP with same job level in spreadsheet.
Summary: We have a requirement to setup the exceptional approval limit to the approvers with same job level.
Example: We have configured job level and amount-based approvals in spreadsheet. Where X approver has the job level 20 and amount limit is 0 to 10K and his manager with job level 30 has the approval limit of 10K to 50K. Here we have job level till 50 with higher amount.
Expectation here is with same job level for some other users with 20 should have the amount limit from 0 to 50K. If invoice is created with 30K and if the exception user as a approver in job level hierarchy should be able to approve the invoice even he has 20 job level and invoice should be approved. If it is more than that should again follow the same job level hierarchy till it reaches to higher level job and amount approver.