Is there any tool which imports currency conversion rates?

We are looking for an integration solution which allows you to import currency conversion rates. It seems that this data is not based on a BO, so I think traditional integration tools such as DataConnect (DC), Data Integrator (DI), and Integration Object won’t work. Have you seen this kind of requirement? Are there any solutions other than using SQL script? I’ve tried the SQL below, and it seems to be working.


BusinessConnect (a.k.a. Connector for Business Applications or CBA) is the best method to use for this. Here’s the PDF. The putCurrencyConversionRates method is what you would want to use.

[Admin: To see other related posts, use the Currency tag.]

Continue reading

IV95499: System filter causes report to add totals differently

When you add a system filter to a report that has subtotal values (for instance, work tasks material total), the subtotals don’t add up. If you remove the system filters, the values add just fine.

You can reproduce this by creating 3 work tasks and adding a responsible person (for example, Abe Abstractor) that’s easier to spot. Each of the 3 work tasks have one currency: US Dollars, AUS Dollars, and Euro. Create a query report to list all work tasks. Add columns for values like material or time costs. Add a system filter to see only work tasks where the responsible person = Abe Abstractor (or the one you have chosen). The values will not add up correctly. Remove the system filter and it will calculate just fine.

We need to add a description about what is expected when summing non-base currency fields. If you sum a currency field, and it is not the base currency field that other fields convert into the base currency, then the summation of the column will just add the numbers up, without regard to the currency, and the currency UOM at the end of the report will be just the last UOM that happened to occur on the last record before the total row.

[Admin: To see other related posts, use the Currency tag.]

Continue reading

IV95426: Non-English user typing minus in currency causes error

A non-English user puts a negative sign on the existing currency amount. Save the record. Navigate away and go back to the tab. A MID error occurs.

The null check must also check for “Not a Number” (NaN) in JavaScript when validating numbers. Moving forward, we resolved an issue where entering a currency value as a non-English user would throw an error.

[Admin: To see other related posts, use the Currency tag.]

Continue reading

IV95311: Currency conversion not taking the correct exchange rate

When you have currency conversions for multiple time periods, and then you have a lease that falls inside the first period, it is taking the last currency conversion as shown below… The amount base should be “2000” since the time period fell within the February exchange rate. But it seems to be taking the March exchange rate.

We needed to set the conversion group and exchange data in the BO mapping. Moving forward, the triCostItem > triContractCostBreakDownItems business object had their properties updated to set triConversionGroupLI for the conversion group, and triExchangeDT as the exchange date. We are addressing this specific scenario only and are not making sweeping changes to all BOs in OOB apps.

[Admin: To see other related posts, use the Currency tag.]

Continue reading

Why do exceptions for currency conversion appear in server.log?

How do I address the cause of currency conversion exceptions that are appearing in my TRIRIGA server.log file so they stop being logged? The exception can occur as a result of currency conversion being done when a user profile has a different currency than the base currency. Here are some examples of the exception seen in the log:

Error in Conversion from >CHINESE YUAN RENMINBI< to >US Dollars< . Using conversion rate of 1.
Error in Conversion from >NIGERIAN NAIRA< to >US Dollars< . Using conversion rate of 1.

There are generally two ways to resolve this:

  • 1. Add currency conversion values to allow the currency conversion to take place. The documentation can be found in the IBM Knowledge Center: Currency.
  • 2. Confirm every user profile has the same currency as the base currency. The base currency is defined in the file.

Also, check for duplicate UOM values for currency. This could explain the exception if the first two options fail to resolve the problem…

Continue reading

IV94003: Currency fields with 3 decimal places rounding up

This is a visual display issue with currency fields in the system. Graphically, the system is rounding up for any currency field that is 3 or more decimal places long.

For example, $4.001 becomes $5.00 until the record is saved and the screen is refreshed, or until the user changes form tabs and comes back. In the latter case, the screen is also refreshed and will change back to the correctly displayed $4.00, but with 4.001 in the database. In the database and for all calculations, the 4.001 should be used as the correct value.

Continue reading

How are currencies handled in a globalized TRIRIGA environment?

IBM TRIRIGA made vast improvements in the globalization of currencies starting with TRIRIGA Application Platform 3.4.2. If you are on a platform version before 3.4.2, we urge you to upgrade to the most current version to take advantage of these enhancements. For the enhancements to work correctly, you must update your environment after you upgrade your platform. The following discussion highlights globalization areas to review after upgrade:

  • User Language: A language is defined in each user’s profile record. The language establishes the locale of the user…
  • User Currency: A currency is defined in each user’s profile record. When a user creates a record that includes a currency UOM…
  • UOM Value: Currency UOMs are defined in the Unit of Measure (UOM) values, which are found in Tools > Administration > Unit of Measure (UOM) > Values…
  • Language Code: Review the language codes in Tools > Administration > Globalization Manager > Language Code to ensure that they are correct for your company…

[Admin: To see other related posts, use the Currency tag or Globalization tag.]

Continue reading

Why doesn’t the triCurrencyUO field update on payment line item?

We added a new currency and it is not working in production. However, when we copied the production database to a test environment, it does work.

A new currency was created “Serbian Dinar”. It was added to the UOM Values object and to the “Currency” list. The new currency was added to the real estate lease and the payment schedule with no issues. However, when payment schedules are generated and the payment line items are created, the triCurrencyUO field on the payment line item is blank and not updated from the payment schedule.

Clearing the TRIRIGA cache did not resolve this issue. The issue was resolved by restarting the application server.

Continue reading

IV93170: Revised Funds discounted twice in capital projects

This was seen with TRIRIGA Application 10.5.2. The final amount for the Revised Funds is being discounted twice for positive or negative values…

Check the Revised Funds value. In the client’s example, it was expected to be $900,000.00 USD as only $100,000.00 was discounted out of $1 million USD. But it was discounted twice and it showed $800,000.00 in the Revised Funds column.

Continue reading