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

Balance Sheet is out because of CTA deriving on Elimination due to NetIncome(Subsidiary) Config Rule

edited Mar 3, 2023 10:56AM in Financial Consolidation and Close 3 comments

Summary:

There are translation issues because on Entity currency, Balance Sheet is matching and on Parent Currency, Balance Sheet is going out. When further analyzed, second month onwards CTA is being calculated wrongly on "FCCS_Intercompany Eliminations" member of Data Source however CTA calculation is correctly done in first month of the same year.

While analyzing Retained Earnings Current on "FCCS_Mvmts_FX_to_CTA" member from Consolidation Dimension, I found that System is not calculating proper CTA on Consol Level i.e. On Consol level i.e., Sub Consol(FCCS_ClosingBalance-Entity Currency Amt*(Average Rate - Ending Rate) + (FCCS_Mvmts_FX_to_CTA-Entity Currency *Ending Rate)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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