E1: 11: R11414A Translation Account (CTA) Incorrectly Calculated for the Account Range and Header Level
(Doc ID 2233151.1)
Last updated on JULY 21, 2020
Applies to:JD Edwards EnterpriseOne General Ledger - Version 9.0 and later
Information in this document applies to any platform.
Currency Restatement Compute and Print (R11414A) are not calculating CTA when run in period mode under the following conditions:
1. When there is a record in F0902 for ledger type AA for the fiscal year being restated, where all amount fields for the record (GABPYC, GBAPYN, GAN02, GBAN03, GBAND01, GBAND02, etc. ) have a value of 0 (zero) the currency gain/loss translation is being calculated incorrectly. It uses the prior period average rate in the formula where it is supposed to use the current period average rate. If that zero balance record is removed from F0902 then the currency CTA is calculating correctly.
2. If there are multiple currencies within an account range to be restated, and the company being restated is set to post by currency, the prior period balance used in the CAT formula is ONLY including the last account listed on the restatement report. The prior period balance should be the sum of the prior period balances for all accounts in the range. The resulting CTA is calculating incorrectly.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document