Spreadsheet based Load for Invoice Approval Workflow
Summary
What are the equivalent operators for Contains, OR, AND that are used in BPM to set it up through SpreadsheetContent
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 |