Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Locate the setup menu under Settings > Global System Settings > Currency codes Codes and ratesRates

Info

Please reach out to your WorkBook administrator or your Consultant if you cannot find the module/menu.

ON THIS PAGE YOU WILL FIND:

Table of Contents
maxLevel2
minLevel2

...

REVIEW COMPANY CURRENCY

Each company has only one company currency (or base currency) and this can only be set once when you create a new company.

...

  • Company: shows the list of companies that you have created in WorkBook system

  • Base currency: shows the base currency set up against the relevant company

  • Rate table: shows the rate table set up against the relevant company. It is similar to the base currency, the rate table can only be selected once when you create a new company. Refer to the ‘Rate table’ section below for more information.

Image Modified

...

RATE TABLE SETUP

The rate table is used for keeping the currencies and currency rates. The system always has a ‘DEFAULT’ rate table created as the initial setup.

...

For example, if the base currency of the default table is AUD, all the foreign currencies defined under this rate table will need to use the exchange rate converting to AUD.

Image Modified

To create a new rate table, click on the icon ‘add new rate table’ (blue star)

...

Click OK to confirm the information.

Image Modified

To delete the rate table, select the rate table from the list and click on the ‘delete’ icon (blue star)

Image Modified

On the pop-up window for confirmation,

  • Click ‘Yes’ to continue deleting the rate table.

  • Click ‘No’ to cancel the action.

...

CURRENCY SETUP

This is where you can set up the currencies that will be used in WorkBook system.

  • Currency code (blue star) : the abbreviation or the code of this currency. Usually, this is set the same to the ISO 4127 code.

  • ISO 4127: is a standard ISO code that defines the currencies and will be populated automatically by the WorkBook.

  • Name: the name of the currency

  • Currency symbol: the symbol of the currency. (e.g. A$, $, €, ₫ … )

  • Blocked: select the checkbox if you want to block this currency and leave it unselected if you want to keep it active.

  • Reporting: select the checkbox if you want to generate the reports in WorkBook using this currency.

Image Modified

To add a new currency, click on the icon ‘add new’ (blue star) and select the option ‘Add currency’

Image Modified

From the pop-up window, enter the following:

...

Click OK to confirm the information.

...

Image Added

Note: you can’t delete the currency after adding it but you have the option to block it from being used by selecting the checkbox ‘Blocked’ mentioned above.

...

CURRENCY RATE SETUP

This is where you can update and maintain the currencies' rates of the relevant rate tables.

...

  • Rate table: allow to drop down and select the rate table that you want to update

  • Search: allow to search for the currency in the selected rate table

  • Hide blocked: select the checkbox if you want to hide the blocked currencies.

Image Modified

The upper grid displays the list of currencies you have in the system with the current rate being used for each currency.

...

  • Rate: the rate has been entered into the system

  • Valid from: the date when this rate is applied from.

Image Modified

To enter the new rate for a currency,

  • select the currency from the upper grid.

  • From the subgrid, click on add new line icon (blue star)

  • The pop-up window will let you enter:

    • Valid from: the date when this new rate will be applied

    • Rate: the new rate to apply for this currency at 100 units.

      • From the example screenshot, we add the new rate for USD where the base currency is AUD.

      • Therefore the rate needs to enter here will be 100 USD = 137.32 AUD.

Image Modified

Click OK to confirm the information.

The upper grid is now updated with the latest rate that has just been entered.

Image Modified

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel in ( "currency" , "currency_rate" , "exchange_rate" , "foreign_currency" , "settings" , "setting-module" , "price-lists" , "rate-cards" ) and space = "TGKB"

...