Speed up inquiries by changing multi-currency trigger

[Travis Wendland]

We are running OneWorld Xe on an AS/400 and Citrix servers and have multi-currency turned on. There is a multi-currency trigger on many of the files including F4211 and F42119. This trigger is executed every time a record is read, added, updated, etc. from the database. In many cases, it is calling B1100007 - Decimals Trigger Get by CO CRCD. This business function determines how many decimal places should be used for the currency fields based on the currency code of the company and the currency code of the transaction. All of our companies are set up with currency codes of USD or EUR and almost all of our transactions are in USD, EUR, or CAD. Since these currencies all use 2 decimal places, there is no reason to call this business function unless the transaction currency code is something other than USD, EUR, or CAD. The data dictionary is set up to use 2 decimal places for all currency fields by default.

I inserted code into the Currency Conversion is On event in F4211, F42119, F4201, and F42019 to only call B1100007 if the currency code is not USD, EUR, CAD, blank, or null. This dramatically improved the speed of some of our inquiries on these files. We have a custom application that reads a lot of records from F4211 and F42119. Inquiries that were taking over 50 seconds now take 5 seconds.

Has anyone else tried this? Have you encountered any problems?

Thanks,