How to add a new currency into the Service Catalog Setup.

Document ID : KB000048491
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Instructions for creating an new currency for a Business Unit.

Solution:

Please perform the following steps to get a new currency available in the Service Catalog environment. In this example we'll be creating a Czech Crown row.

  1. Determine the current highest available 'currency sequence number', to be used further in the procedure:

    SQL Query:

    SELECT max(CAST(currency AS INT)) from usm_exchange_rate

    Note/write down this number and add 1 to it.

    E.G. When 36 is returned, add 1 to it and get 37.

    Then Use this value '37' in the following lines when needed.

  2. Update the MDB database according to the currency details:

    1. insert into usm_exchange_rate values for the currency: for our example they would be ('37','2013-09-04 00:00:00.000','CzC','CzC',1.0)

      Note: '37' is taken from step A

    2. insert into ca_currency_type values to describe what this currency is ('CzC','Czech Crown.',NULL,0,'Czech Crown.',NULL,NULL,NULL,NULL,NULL,0,NULL)

  3. Create/Edit a Business Unit(BU) with the new currency:

    1. SC/admin/bu>add new BU1 or change an existing BU.

    2. Set its currency to CzC (as shown in the list).

  4. Edit the following file:

    %USM_HOME%\view\webapps\usm\locale\icusen\sharedxml.xml

    1. Open the file and search for '<currencies>' section.

    2. Add these lines to the file.

      You may add these in alphabetical order of the currencies shown.

      <t37>   <id>CzC</id>   <text>Czech Crown</text>   <symbol>CzC</symbol>   <tid>37</tid></t37>


      Note: '37' is taken from step A

  5. Edit the following file:

    %USM_HOME%\view\webapps\usm\locale\icusen\billing\billrateitemtext.xml

    1. Open the file and search for '<currencies>' section.

    2. Add these lines to the file.

      You may add these in alphabetical order of the currencies shown.

      <t37>   <id>CzC</id>   <text>Czech Crown</text>   <symbol>CzC</symbol></t37>


      Note: '37' is taken from step A

  6. Run the following steps, to complete/activate the change:

    1. Stop the Service Catalog service

    2. Clear/empty the %USM_HOME%\view\translets folder

    3. Clear the browser cache

    4. Start the Service Catalog service

    5. Check the currency setting/change in the BU