Business case:
Purchase request approvals either work at line or at header level. We have a need for a hybrid model, where certain criteria are aggregated to determine the approver.
Example:
The following is the approval hierarchy for a company's approval:
- Product category: Fertilizers
- Between amount 1 and 50,000: Approved by Agronomist
- Between amount 50,001 and 100,000: Approved by General Manager
- Between amount 100,001 and 200,000: Approved by Production Director
- Above 200,000: Approved by CEO
- Product category: Pesticides
- Between amount 1 and 50,000: Approved by Entomologist
- Between amount 50,001 and 100,000: Approved by General Manager
- Between amount 100,001 and 200,000: Approved by Production Director
- Above 200,000: Approved by CEO
In the same purchase request, the following is ordered:
- Fertilizer 1 qty 10,000 @ unit price 3 = line amount of 30,000
- Fertilizer 2 qty 10,000 @ unit price 5 = line amount of 50,000
- Pesticide 1 qty 20 @unit price 50 = line amount of 1,000
The requirement is that the approval rule must be per purchase request per grouping e.g.
- The total of fertilizer is 80,000, which means it must go to the general manager for approval
- The total of pesticides is 1,000 which means it must go to the entomologist for approval
Is this possible in purchase request approvals without doing development?