Invoice Approval Spreadsheet: How to configure PO delta amount
Hello CCC community,
I have a question on the Simplified Rule Configuration (SRC) Spreadsheet for Invoice Approval:
In the Spreadsheet I want to base my condition on the delta amount of the Purchase Order Line Amount versus the Invoice Line Amount.
For example: I have an Purchase Order Line of 1000,- and I receive an Invoice Line of 1200,-. Is there a possibility to base my invoice Approval rules on this delta amount of 200,- ?
I'm looking for something like:
IF (InvoiceLineAmount minus POLineAmount > 100) then APPROVAL_GROUP_A
What I want to achieve at the end is that when I have a (released) Price Hold, that the Invoice Approval rules can be configured based on the delta amount.
Tagged:
0