You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!