11.8.10 Migration Options- Functional Currency and Entered and Functional Currency

FTP provides the option to the user to perform Ledger Migration in the Entered/Transaction currency (the one in the ISO_CURRENCY_CD column of the Instrument table – the currency in which the transaction takes place) or in the Functional currency. These are supported in the Management Ledger table. The selections for 'Functional Currency' and 'Entered and Functional Currency' are present in the Migration block of the Standard and Stochastic Processes. To provide control over how FTP multi-currency postings happen, you can select 'Functional' or 'Entered and Functional'.

• If you choose Functional, this would assume that all Entered Balances in ML = Functional Balances. All non-functional currency balances from instrument data would be converted to functional currency and the same amount would be posted to both the Entered Balance and Functional Balance columns. The Functional currency is fetched from FSI_DB_INFO. The currency conversion would be done based on the FSI_EXCHNG_RATE_DIRECT_ACCESS table.
• Similarly, if you choose Entered and Functional, then the assumption is that ML data contains detailed currency information and Entered Balance <> Functional Balance (except where entered and functional currency is the same). In this case, FTP would convert non-functional currency balances to functional currency for purposes of posting to the Functional Balance column, but would not convert the amount posted to the Entered Balance column and ISO_Currency_CD would equal the currency from the instrument data. This approach assumes that FE 100/140 data in ML is similarly loaded with a consistent approach. For example, if Functional and Entered is selected, the FE 100 or 140 data should also reflect multiple ISO_Currency_CD and Entered Bal <> Functional Bal

Note:

Input Ledger Balance will always be available in Functional currency. Entered Balance can be <> Functional Balance, but Functional Balance should always be available for the Input FE's 100, 140, and Custom Input Balance FE's if any.