IBM Support

Explanation of currency display for Milestone Summary - Total Invoice Amount or Order Total = prefix using $ or CAD or EUR or locale currency. - SCBN Business Transaction Intelligence

Troubleshooting


Problem

Milestone Summary shows Order Total with $nnnn but the Total Invoice Amount showing CADnnnn.
CAD displays as the currency and the prefix label of the numeric amount.
EUR displays as the currency and the prefix label of the numeric amount.
What will the currency be if no CUR segment is present?

Cause

Documents without a CUR segment will leave the currency decision up to BTI logic.

Resolving The Problem

  1. If CUR segment is not specified it defaults to USD (this is why 850 shows $, for USD, not CAD )
  2. If CUR segment is specified, based on user locale, CAD will be displayed as $ for locale = Canada and as CAD for other locales. Since Canada is not a supported locale, assuming such users will have locale = English (US) , it will display as CAD( not $). Thus 810 results in CADxxx.xx display

Note that specifying CUR in 850 should display CAD in the order milestone.

BTI uses the standard locale based java formatting for currency. The locale used is based on user settings (default to US locale if not set) and not the browser locale.
Java docs regarding currency symbol say:

For example, for the US Dollar, the symbol is "$" if the default locale is the US, while for other locales it may be "US$". If no symbol can be determined, the ISO 4217 currency code is returned.

As such, if the user setting has any locale other than Canada, Canadian $ (CAD) will show as CADxxx.xx. For users with Locale set as Canada, it will show as $xxx.xx

In short, the corresponding currency symbol will be shown if the currency matches with that of the user locale.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSJSKG","label":"IBM Sterling Business Transaction Intelligence"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Business Transaction Intelligence; BTI

Document Information

Modified date:
28 July 2021

UID

ibm10796324