Migrate AP Invoice approval rules to Excel - currency conversion does not work
Summary:
We currently use the BPM rules for Invoice Approvals (FinApInvoiceApproval) and we would like to migrate to the new Excel based template.
1 of the functions our current BPM rules have is that all currencies are converted to USD equivalent and use that amount for approval limits.
We use a custom rate type and not the default "Corporate".
They syntax is correctly configured and it works as expected.
Invoice Header.Invoice Amount*CurrencyConversionGlobal.getRate(Invoice Header.Invoice Currency Code,"USD",Invoice Header.Invoice Date,"300000008975510",0) between……
Issue 1 - When we download the BPM rules and convert them into the Excel template they lose the whole conversion to USD part. All other conditions get transformed/translated into the new format.