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

USD Translated Currency Calc FCCS_25

Summary:

Hi,

after reading this thread:

https://community.oracle.com/customerconnect/discussion/726879/usd-translated-currency-input-journal-not-rolling-up-for-non-usd-parent-entity#latest

I tried to use the logic inside insertion point FCCS_25, for USD Translated currency input journal not rolling up for Non USD Parent entity in my test app:

FIX ("USD", "FCCS_Translated Currency Input")
/* Clear the entity before calculation /

FIX ("FCCS_Periodic", @RELATIVE ("FCCS_Total Balance Sheet", 0), @RELATIVE ("FCCS_Intercompany Top", 0), @RELATIVE ("FCCS_Mvmts_Subtotal", 0), @RELATIVE ("Total Custom 1", 0), @RELATIVE ("Total Custom 2", 0))
"USD ADJ" (

IF (NOT @ISLEV ("Entity", 0))
IF (@ISUDA ("Entity", "Non_USD_Parent"))
#MISSING;

ENDIF

ENDIF

)

ENDFIX

/ Sum the children entities */
FIX ("FCCS_Periodic", @RELATIVE ("FCCS_Total Balance Sheet", 0), @RELATIVE ("FCCS_Intercompany Top", 0), @RELATIVE ("FCCS_Mvmts_Subtotal", 0), @RELATIVE ("Total Custom 1", 0), @RELATIVE ("Total Custom 2", 0))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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