How to create an AP Approval Rule based on Sum of Line Type = Freight > Invoice Amount * 0.10
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Brinker International
Description (Required):
How do you create an approval rule in the Invoice Approval Spreadsheet based on the sum of Freight Line amount?
Sum(InvoiceLine.lineAmount) where (InvoiceLine.lineType == "FREIGHT") > (InvoiceHeader.invoiceAmount * 0.10)
Use Case and Business Need (Required):
Client would like to use AP Invoice Workflow to route invoices for approval when:
- Invoice Header PO Matched = Yes
- Sum of Freight Lines > 10% of Invoice Amount
- Route for Approval Required to the to the Buyer of the matched PO on the header
1