AS/400 Euro EM4 Millennium Solutions



Related Topics: EM4 EM4 Objectives Modules Database Conversion euro@ms400.com

EM4 Triangulation

Calculations

The calculation module is designed to be called by any part of the product which needs to perform a calculation. This part of the product will be certified externally by an international accounting firm. This removes the need to do major testing on calculations at implementation, allowing the users to focus on business case and accounting issues.

File Analysis

Analyses Physical Files and identifies exchange rate fields based on search criteria defined by the user. These are presented for manual validation and defining the associations and then stored in the EM4 repository.

File Field Associations

This process is used to identify the relationship of an Exchange Rate field with the from and to currencies, the effective date, and if relevant, the company code.

Program Analysis

This multi-pass tool searches the RPG code for the use of the relevant fields from the file analysis. The multi-pass feature is used primarily to locate field movements and renaming within the programs. The result of these searches is a list of programs and fields used in the exchange rate calculations.

Code Insertion

This feature inserts the code into the programs. It builds a dynamic table of rates gathered within the program for use within calculations. Where the calculations take place, code is inserted to call a control program, which analyses the currency parameters and decides to call the EM4 calculation, if appropriate. If it is not appropriate, a flag is set and the original calculation line is performed. For partial triangulation (i.e., Out Currency to National Currency Unit or vice versa), the EM4 calculation retrieves the out/Euro rate from the application currency file, performs that calculation and uses the Euro to National Currency Unit conversion factor to convert that value. The conditions supported are NCU/Euro, Euro/NCU, NCU/NCU, Out/NCU, and NCU/Out. Those handled by the original calculation are Out/Out, Out/Euro, and Euro/Out.

EM4 runs on AS/400 RPG applications and requires the availability of the source code. It comprises of tools and modules to ensure total Euro compliance.