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))
Tagged:
0