Setting Up Currency And Currency Type
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Setting Up Currency And Currency Type

  • Dark
    Light
  • PDF

Article summary

Currency denotes the monetary unit utilized for financial transactions and reporting within an entity, whereas Currency Type classifies currencies according to factors such as stability or legal tender status. The Currency Setup page allows you to set up currency and currency types that can be used by a company as its Common Currency, Local Currency, or Interim Currency.

The Currency Setup page has two tabs - Currency and Currency Type.
2%20types

Currency

You can add a currency in the Currency tab. All the currencies currently available in the application are shown under the Currency tab. 

How to Add Currency?

The Currency Lookup option offers search functionality for looking up currencies and adding them in Currency Setup.

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
    Currency%20setup
  2. Click Currency Lookup.
    Currency%20Lookup
  3. Select currencies from the list. Alternatively, you can search for currencies by entering the Currency Code or the Currency Name.
  4. Click Save.
    select%20currencies
  5.  The selected currencies are now displayed.
    llok%20up
Note:

You can also manually add currency using the Add option.

  1. Click the Add icon.
    Add-Currency
  2. Enter the Currency Code to identify the currency, for example, USD.
  3. Enter the Currency Name to identify the currency, for example, U.S. Dollars.
  4. Click the Save icon.
    Add%20c

How to Edit Currency?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
    Currency%20setup
  2. Select a Currency from the list that you want to modify and click the Edit button.
    Edit(1)
  3.  Edit the fields and click the Save icon.
    Edit%20and%20save


How to Delete Currency?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
    Currency%20setup
  2. Select a Currency from the list that you want to delete and click the Delete button.
    delete(2)
    Note:
    Before deleting a currency, the user must verify that it is not in use anywhere. For instance, within budget entities.

  3.  Click Delete to confirm deletion.
    click%20delete(1)
    A confirmation message appears on the successful deletion of Currency.
    delete%20msg

How to Apply Filter in Currency?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
  2. On the Currency tab, click Apply Filter to find out currencies based on Currency Code, Currency Name, Created Date, Created By, Modified Date, or Modified By.
    Filter(1)


How to Print Currency Report?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
  2. On the Currency tab, click Print to print the currency report.
    Print(1)

How to Export Currency Details?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
  2. On the Currency tab, click Export as Excel to export the currency report in Excel.
    excel


Currency Type

Currency types play a vital role in the currency conversion process, where data is converted using defined rate types. These currency types are associated with Natural Accounts (for example - cash, inventory, accounts payable, sales revenue, or salary expense), and it's common for various types of Natural Accounts to be converted with different rate types. Later, exchange rates will be defined for each currency/currency type combination to address the currency conversion. 

How to Add Currency Type?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
    Currency%20setup
  2. Click Currency Type tab.
  3. Click the Add icon.
    Currency%20Type-%20Add
  4. Enter the Currency Type Code, for example, balance.
  5. Enter the Currency Type Name, for example, the end of month rate.
    Add%20currency%20type
  6. Click Save. The currency type is added to the list.
    After%20save


How to Edit Currency Type?

  1. Navigate to Maintenance > Currency > Currency Setup.
    Currency%20setup
  2. Click Currency Type tab.
  3. Select a currency type from the list and click the Edit icon.
    Edit%20currency%20type
  4.  Edit the fields and click the Save icon.
    Edit%20currency%20type%20and%20save
    The Currency Type will be updated, and you will receive a confirmation message.
    updated%20succesful%20message


How to Delete Currency Type?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
    Currency%20setup
  2. Click Currency Type tab.
  3. Select a currency type from the list that you want to delete and click the Delete icon.
    delete%20currency%20type
  4. Click Delete.
    confirm%20ddelete


How to Apply Filter in Currency Type?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup
  2. Select the Currency Type tab and click the Apply Filter icon to search for currency types based on Currency Type Code, Currency Type Name, List in Exchange Rate, Created Date, Created By, Modified Date, or Modified By.
    filter%20currency%20type


How to Print Currency Type Report?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup
  2. Select the Currency Type tab and click the Print icon to print the currency type report.
    Print%20currency%20Type


How to Export the Currency Type Details?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup
  2. Select the Currency Type tab and click the Export as Excel icon to export the currency type list report in Excel.
    Export%20as%20excel%20currency%20type


How to Add Currency Type to Exchange Rate Table Customized View?

  1. Navigate to Maintenance > Multi-Currency > Currency Setup.
  2. Click Currency Type tab.
  3. Select the currency type from the list that you want to modify. Then, click List in Exchange Rate.
    List%20in%20exchange%20rate
    4. Select the desired options (Yes/No) from the drop-down menu.


What are Currency and Currency Type Exceptions and When Do I Need Them?

When currency conversion is performed, different types of accounts need to be converted at different rates. For example, Income Statement accounts are usually converted using an AVG (average monthly) rate whereas Balance Sheet accounts are typically converted using an EOM (End of Month) rate. Each account will be assigned a currency type based on how that data should be converted.

To address the conversion, you need to create an exchange rate for each currency/currency type combination. This will then indicate the appropriate exchange rate to be used for each account. The table below has different accounts and account types with varying exchange rate types.

Account


Account Type


Exchange Rate Type


Sales

Income Statement

AVG

Traveling Expenses

Income Statement

AVG

Cash

Balance Sheet

EOM

Creditors

Balance Sheet

EOM

Equity

Balance Sheet

EOM

Fixed Assets

Balance Sheet

EOM


Was this article helpful?