Is it possible to configure AP invoice approval Based on invoice line amount through spreadsheet.

Summary:

Business wants to have AP invoice Approval rule based on invoice line amount configured through spreadsheet.

Use case:

Rule 1: If the line amount is less than 500 then it will go to Approver1

Rule 2: If the line amount is more than 500 then it will go to Approver2

If the invoice contains lines with amount less than as well as more than 500, lines with less than 500 amount should go to Approver1 and similarly lines with more than 500 should go to Approver2.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):