Currency Exchange Rates

maintains records of the foreign currency exchange rates and their effective date this table can be manually created or created from a reporting service see docid 3zjkqisn3iu6kwuhfcrlt fx rates are created once for all entities gravity uses the open exchange rates organization ( https //openexchangerates org/ to supply the fx rates to set up automatic exchange rate updates, select the master entity and define the following exchange rate frequency set the following option daily weekly monthly manual at manually add the exchange rates open exchange appid use the id "d371ead4f02e4e1c927b18a14cadf618" next currency update set the date of the next update general name enter a name for the record we recommend a name that includes both currencies for easy identification such as "cad to eur" effective date enter the date that the fx rate becomes effective when entering a transaction the apply date used will be matched with the effective date to apply the fx rate from currency list the from currency to currency list the to currency rate enter the fx rate