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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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