Calculating all Source Account FX Rates

• The default source Movement used to calculate the rate is the sum of the Movements TRCS_CYSys + TRCS_CYAdj at the selected Source Account. Optionally you can use a FX Source Rate Account Source Movement.

  Will only work right for parent movements if they are dynamic calc (this is always true for DSO) For more information on DSO, see: Converting the Application Model to Hybrid-Optimized (DSO))

• The default source Data Source used to calculate the rate is TRCS_PreTax at the select Source Account. Optionally you can use a FX Source Rate Account Source Data Source.
  • Will only work right for parent data sources if they are dynamic calc (this is always true for DSO).
  • Account that includes tax credits will new TRCS_Tax as a source data source.
• Target Account->Destination =Target Account->Entity Currency * (Source Account->Destination Currency->Source Movement->Source Data source/ Source Account->Entity Currency-> Source Movement > Source Data source)
• If the Source Account has a #MISSING or 0 at Entity Currency
  • If Destination Account is 0 at Entity Currency then we Translate to 0
  • If Destination Account is #MISSING at Entity Currency then we Translate to #MISSING
  • If Destination Account has any other value at Entity Currency, then we do a normal Periodic or YTD translation methodology as defined but the setting on the destination account and do not use the Source Account Rate
  • If you want to translate a value and not fail back to 0 for a #Missing or 0 Entity Currency you can enter the Entity Currency as .0001