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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Approval rule based on currency conversion of PO Header

edited Jun 14, 2024 5:12AM in Purchasing 1 comment

Summary: We are implementing cloud in EMEA, but requirement is to write all the BPA approval rules in USD. We have got below expression for Req approval.

CurrencyConversionGlobal.getRate(ReqHeaderDimension.functionalCurrencyCode,"USD",Task.startDate,"Corporate",0)*ReqHeaderDimension.requisitionTotal

(https://community.oracle. com/customerconnect/discussion/486497/how-to-use-a-currency-conversion-function-in-approval-rules-using-the-bpm-worklist-app)

Similarly, we have created below expression for PO approval but it is not working.

CurrencyConversionGlobal.getRate(PurchasingDocumentHeader.functionalCurrency,"USD",Task.startDate,"Corporate",0)*PurchasingDocumentHeader.documentCurrencyApprovalTotal

Content (please ensure you mask any confidential information): Requirement is to write all BPA approval rules in USD across world


Version (include the version you are using, if applicable): 24B


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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