Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

GL journal approval based on USD currency conversion

in General Ledger & Intercompany 5 comments

Summary:

We have a requirement to setup GL journal approval (using Spreadsheet) to convert journal header amount to USD using Corporate conversion rate for approval.

In the legacy BPM way of set up, have used "Journal Batch.Accounted Running Total Dr*CurrencyConversion.getRate(Journal Batch Ledger.Primary Ledger Currency,"GBP",Journal Header.Accounting Date,"Corporate",0)". But, not able to setup the same using spreadsheet.

The upload keeps erroring when I add the below attributes

Rule Evaluation Currency

Rule Evaluation Currency Conversion Date

Rule Evaluation Currency Conversion Rate Type

Log file shows as and it matches to the Oracle note How To Set Currency Conversion Condition Using The Journal Approval Rule Template? (Doc ID 2695512.1)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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