Requisition Approval routing based on amount spend on particular item per annum
We have a requirement to route approval as below -
Upto INR 2.5 Crore per item/annum(Financial Year/Calendar year) : Finance Approval - Procurement Department Approval - Department Head
More than INR 2.5 Crore per item/annum(Financial Year/Calendar year) : Finance Approval -Procurement Department Approval - Department Head - CEO
How we can track the purchase made on the particular item in the particular year?
Is it possible to use custom stages in BPM approval with the help of SQLs and table information ? Would like to check if any one has achieved similar requirement or workaround?
Version (include the version you are using, if applicable):