The attached PDF provides a simple example of how multiple exchange rate tables can be applied to a single model.
The advantages include:
-No duplication of models
-No duplication of the rules and journals in the models, or posting multiple sets of rules.
-The ability to report from read-only tables with the currencies side-by-side (no piecing together via CDA.)
Some considerations:
-The translation is based on the underlying facts of the models. This means any rules that create facts will use the default exchange rate table, not the look-thru table. Generally this is a minor issue.
The Power Point slides from the presentation provide more detailed information about actually configuring the look thru in Mysql.
... View more