How tosend Invoice approval to Project Manager where Subtotal of Invoice Lines by Project if >$XXXX

Summary:

Oracle made usage of Spreadsheet upload for AP Invoice Approval rules. How can we go back to editing rules from front end instead of Spreadsheet. This is because we do not see any option to write complex rules where we can send Invoice approval to Project Manager where the Sum or Subtotal of Invoice Lines by Project # is more than $1000 by each distinct Project# or ID

We have a requirement to send Invoice Approval to Project Manager when the total of Invoice Lines for each Distinct Project #(ID) is greater than $1000.

For Example:

Invoice Line Amount Project
1 700 PRJ1
2 800 PRJ1