Conversion rulesConversion is performed in different ways, depending on the currency system to which you convert, and the type of data. A number of standard conversion functions is available to convert the different types of data. Depending on the currency system to which you convert, the conversion rules process the data in different ways. Internal initialization conversion rules For internal currency initialization, these standard conversion rules apply:
External initialization conversion rules For external currency initialization, these standard conversion rules apply:
Amount conversion rule Amounts can be registered in up to three home currencies. Conversion takes place for each new home currency and the resulting amounts are registered in the home currency amount positions in the database. LN uses the currency rates defined in the CI Rates (tccri7100m000) session to calculate the new home currency amounts. Amount conversion A different calculation method is used, dependent on the (new) currency system you define in the CI cluster. If the currency of the new amount in home currency is already present in the previous home-currency array, the new home amount is always copied from the particular previous home amount. In all other cases, amounts in the home currency are recalculated, even if the transaction currency matches the home currency, or the transaction amount equals zero. The latter, for example, applies to currency and rounding differences. Otherwise, merely copying the transaction amount to the new home amount, could result in the document's transactions being out of balance after a CRI conversion. Euro initialization If the conversion basis is an EMU-marked currency (in the Currencies (tcmcs0102m000) session), and the new currency is euro (defined as "Transition Currency" ( Infor LN FP5) or "Euro Currency" (in previous versions) in the Companies (tcemm1170m000) session, the amount in euros is always recalculated using the fixed CRI conversion rate. In the latter case, amount differences may occur between euro amounts in transaction currency and in home currency. This occurs if the euro was used as a transaction currency in the past, against a rate different from the CI conversion rate. The mechanism of using the direct rate in the euro initialization case will minimize the risk that the historic business results are different after euro initialization.
Rate/Rate factor conversion rule The currency exchange rates are usually stored in the database with the amount, as well as the rate effective date. If the currency and the amount change, the correct new rate, rate factor, and effective date must also be stored. The setting of the Express in Base Currency check box which is either selected or cleared, must be copied. The currency-rate registration for single and dependent currency systems differs from independent currency systems. Therefore, the rate/rate-factor conversion is also different. See "Currency-rate registration" under "Currency Systems and Company Structures." During external conversion, the home currencies do not change and a simpler method can be used to convert the currency rates and rate factors. Therefore, two rate/rate-factor rules exist:
Rate factors and rate effective-date
conversion In all cases, these changes are made during the conversion:
Internal rate/rate-factor conversion Important! Home-currency amounts must be converted before the rate/rate-factor conversion-rule is used. To avoid revaluation of the home-currency amounts, the rates stored with the converted amounts in the new home currencies are calculated from the new home-currency amounts and the corresponding amounts in the reference currency or the transaction currency. Note If the rate cannot be calculated because the amount is not available in the home currency but only in the transaction currency, the rate entered in the CI Rates (tccri7100m000) session is stored for the amount. For example, the amounts of invoices that are not yet composed are not available in the home currency. One amount is divided by the other depending on the setting of the Express in Base Currency check box in the CI Rates (tccri7100m000) session. Depending on the currency system after the currency initialization, different calculations are carried out.
External rate/rate-factor conversion Important! Before the rate/rate factor (external) conversion rule is used, transaction-currency amounts must first be converted to euro. The currency rates between EMU currencies and the euro must be based on the euro. It is not permitted to use inverted rates. Therefore, the new calculated currency rates are based on the transaction currency instead of the home currency.
Default currency conversion rule In some parts of LN, such as the Financial Budgeting System, data is registered in a default currency, which must be one of the home currencies. If the default currency is no longer one of the home currencies after the conversion, it must be replaced with another home currency during the currency initialization process. Default currency conversion During conversion, the current default currency is replaced with the new default currency and the amounts are converted to the new default currency. Sole home-currency amount conversion rule Sometimes the transaction-currency amount is not available for the calculation of the new home-currency amount. In such cases, the calculation of new home-currency amounts is based on the local home-currency amount. Sole home-currency amount conversion The new home-currency amount is calculated from the previous local home-currency amount. Sole amount conversion-rule A sole amount is an amount that is registered in one currency and to which no currency field is linked. Such amounts are usually in either the reference currency or the local home currency. For example, an item’s Inventory Carrying Cost (whwmd400.scst) is a sole amount in the reference currency. The sole amount rule converts the amount into the new local home currency or to the new reference currency. To use this rule, you must specify whether the field is in the reference currency or in the local home currency, by selecting or clearing the Use Reference Currency check box in the CI Fields (tccri7521m000) session. Sole amount conversion Depending on the selection of the Use Reference Currency check box in the CI Fields (tccri7521m000) session, the amount is converted:
Rate determiner conversion-rule A rate determiner defines the currency differences that will be written off as a result of currency rate fluctuation between the invoice date and the payment date. Rate determiners vary per currency system. LN supports three types of handling currency differences:
Some rate determiners cannot be used in specific currency systems. If the currency system changes and the rate determiner cannot be used in the new currency system, the rate determiner is changed to the most similar rate determiner that can be used in the new currency system. If the rate determiner can be used in the new currency system, it is not changed. This table shows the rate determiners that can be used for the Standard, Single, Dependent, and Independent currency systems.
Where: Y = the determiner is valid for the currency system ‑ = the determiner is not not valid for the currency system Rate-determiner conversion If the previous rate determiner cannot be used in the new currency system, the rate determiner is converted. Rate determiners that can be used by the currency system before and after the currency initialization are not changed. This table shows the rate determiners that are replaced during each currency initialization scenario.
Transaction-currency amount conversion rule Important! Transaction amounts are always converted to euros. The conversion of transaction amounts to other currencies than the euro is not supported. This figure shows the amount calculation scheme for amount conversion during external euro initialization. ![[...]](../images/tr_chart_cri_amount_conversion__scheme.png) Transaction amount conversion The euro amount is calculated from the transaction-currency amount by using the exchange rate of the transaction currency to the euro, defined in the CI Rates (tccri7100m000) session and according to the selection of the Express in Base Currency check box. Transaction-currency conversion rule The EMU transaction currency is replaced with the euro. Important! Transaction currency fields must be converted after using the rate/rate factor (external) conversion rule.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||