Working with Currency

When identified amounts are written to or retrieved from a database, or when they are used in calculations during processing, proper decimal placement is extremely important. Currency implementation is needed to adjust decimal placement on Math_Numeric currency fields according to a specified currency. Common applications of currency implementation include conversion of currency amounts and revaluation of currency due to fluctuations in exchange rates.

Implementing currency involves:

• Performing currency setup.

• Creating a business function that contains logic to retrieve currency information. Currency business functions are known as currency triggers.

• Attaching a currency trigger to the Currency Conversion event in Table Event Rules (TER).

• Designing TER functions through Event Rules Design. The system then converts the event rules to C and compiles them into a consolidated DLL through the Object Management Workbench (OMW) application.

• Modifying applications as necessary.

The JD Edwards EnterpriseOne database middleware then calls the appropriate TER function when the Currency Conversion event is triggered.