Purpose: Use the Currency table to define currencies and their conversion rates.
The system uses this information when:
• you create purchase orders, to convert your currency rate to your vendor's currency rate
• you receive against a purchase order, to convert your vendor's currency rate to your currency rate
• you bill orders, if the Customer Sold To on the order is from a foreign country
• you enter orders, bill orders, or process refunds, if you track multi-currency by offer
Note: If you track currency conversion rates at the time of order billing in the Invoice Currency table, you must use the same code to identify a country and its currency. You must also have the Track Invoice Currency (D68) field in the System Control table selected. See Setting Up the Country Table (WCTY) for more information on country codes.
Multiple Currencies by Offer: You can accept orders in various currencies by defining the currency to be used for each offer. You must set the Multi Currency by Offer (E03) system control value to Y. Setting up multiple currencies by offer enables you to take orders in a foreign currency, but track demand in your local currency. Note: If you enable multiple currencies by offer, the Use Alternate Currency Pricing (H89) system control value should be unselected.
Alternate Currency Pricing: You can price offers in foreign currencies by defining the currency and conversion rate to be used for each offer. You must set the Use Alternate Currency Pricing (H89) system control value to Y. Setting up alternate currency pricing enables you to take orders in the local currency but enter amounts in the foreign currency. It also enables you to display the foreign currency on reports and customer related forms. If you enable alternate currency pricing, the field Decimalized currency displays for each currency, where you can define whether the currency uses decimals. Note: If you enable alternate currency pricing, the Multi Currency by Offer (E03) system control value must be unselected.
Default decimal separator and thousand separator for currency: The system uses the following values to determine the default decimal separator and thousand separator of Order Management System.
• The DECIMAL_SEPARATOR property defines the character used to indicate the decimal place in a number.
• The THOUSAND_SEPARATOR property defines the character used to separate groups of thousands.
The supported thousand and decimal separators are displayed below.
Default Thousand Separator |
Default Decimal Separator |
Results |
, (comma) |
. (period) |
4,294,967,295.00 |
. (period) |
, (comma) |
4.294.967.295,00 |
See Regional Settings for an overview and see Setting the Default Decimal and Thousand Separator Format for more information on how numbers display in different areas of the application.
In this chapter:
How to display this screen: Enter WCUR in the Fast path field at the top of any menu or select Work with Currency from a menu.
Field |
Description |
Code |
A code that represents the currency. Alphanumeric, 3 positions; optional. |
Description |
The description of the currency code. Alphanumeric, 30 positions; optional. |
Last update |
The date that a conversion rate was most recently updated. Numeric, 6 positions; optional. |
Conversion rate |
The rate at which this currency is converted to the local currency. Numeric, 11 positions with a 7-place decimal; display-only. |
Decimalized currency |
Indicates whether this currency uses decimal places for alternate currency pricing. This field only displays if the Use Alternate Currency Pricing (H89) system control value is selected. |
Screen Option |
Procedure |
Create currency codes |
Select Create to advance to the Create Currency Screen. |
Change currency information |
Select Change for a currency code to advance to the Change Currency screen. At this screen you can change any information except the currency code. See Create Currency Screen for field descriptions. |
Delete currency information |
Select Delete for a currency code to delete it. |
Display currency information |
Select Display for a currency code to advance to the Display Currency screen. You cannot update any information on this screen. See Create Currency Screen for field descriptions. |
Purpose: Use this screen to create a currency code.
How to display this screen: At the Work with Currency Screen, select Create.
Field |
Description |
Currency code |
A code that represents a type of currency. Alphanumeric, 3 positions. Create screen: required. Change screen: display-only. |
Description |
The description of the currency code. Alphanumeric, 30 positions; required. |
Date of last update |
The most recent date on which the conversion rate was updated. Note: The system does not update this field. Numeric, 6 positions (in user date format); required. |
Conversion rate |
The rate at which this currency is converted to the local currency in purchase order maintenance and receipts. The system divides the amount in the foreign currency by the conversion rate to determine the amount in your local currency; for example, if you set the conversion rate for Canadian dollars at 1.3, the system would convert $10.00 to $7.69 in your local currency, dividing 10 by 1.3. Currency conversion settings for purchase order maintenance and receiving are defined in the Vendor table. See Working with Vendors (WVEN) for more information. The system does not use this conversion rate for alternate currency pricing; the system uses the conversion rate from the Offer table. See Using Alternate Currency Pricing. Note: This field does not support a number with more than four positions in front of the decimal point; otherwise, your entry will be truncated. For example, if you enter 12345.1234567, it will be truncated to 2345.1234567. Numeric, 11 positions with a 7-place decimal; required. |
Shadow entity |
This field displays only if the Multi Currency by Offer (E03) system control value is selected; it is required for all currencies except your local currency, as defined in the Local Currency Code (A55) field in the System Control table. Entity codes are defined in and validated against the Entity table; see Working with Entities (WENT). Numeric, 3 positions; required. |
Indicates whether the currency uses decimals when using alternate currency pricing. This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected. Valid values: • Selected = The currency uses decimals. When converting the amount, the amount includes decimals. For example, 49.99 instead of rounding to 50.00. • Unselected = The currency does not use decimals. Instead, the amount is rounded to the nearest whole unit of currency. For example, 50.00 instead of 49.99. Note: This field does not apply to currency conversion in purchase order maintenance and receipts. See Using Alternate Currency Pricing and Decimalized Currency? for more information on the conversion calculations the system performs when using alternate currency pricing. |
