Spreadsheet based Load for Invoice Approval Workflow — Cloud Customer Connect
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

Spreadsheet based Load for Invoice Approval Workflow

edited Aug 16, 2020 10:15AM in Payables, Payments & Cash Management 2 comments

Summary

What are the equivalent operators for Contains, OR, AND that are used in BPM to set it up through Spreadsheet

Content

I amd trying load new set of rules based on existing ones. This will involve about creating around 60 rules hence looking at the Spreadsheet approach.

I have a condition where Invoice must follow a job level heirarchy for certain cost centers starting  with a specific person and Invoice satisfying certain other conditions like Account, Not PO Matched and Invoice Amount evaluated in a specific currency.

In BPM the currency is evaluated as follows:

Invoice Header.Invoice Amount*CurrencyConversionGlobal.getRate(Invoice Header.Invoice Currency Code,"GBP",Invoice Header.Invoice Date,"Corporate",0) same or less than 10000) and

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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