How to Set Up Multi-Currency in the Accounts Receivable Module for Sage 300

To set up Accounts Receivable to use multiple currencies:

  1. In Common Services:
    • On the Company Profile screen, select the Multicurrency option for the company and select a default rate type.
    • On the Currency screens, add any currency codes you need for Accounts Receivable, and enter rates for the currencies you use.
      Tip: When you install Sage 300, you also install a large set of currency codes that use standard international abbreviations. Check the list to determine whether you need to add any codes.
      For more information, see the System Manager help.
  2. On the A/R Options screen, select the Multicurrency option.
  3. On the A/R Account Sets screen, add at least one account set for each currency you want to use in Accounts Receivable.
    For each account set, you enter the currency code and the numbers of your exchange gain and loss general ledger accounts, as well as the other general ledger account numbers required in an account set. For more information, see “Adding or Modifying Account Sets” (page 23).
  4. On the A/R Interest Profiles screen, add interest records that include a minimum interest charge and annual interest rate for each currency used by the customers you will assign to a particular interest profile. For more information, see “Adding or Modifying Interest Profiles” (page 35).
  5. On the A/R Items screen, add pricing information for all the currencies and units of measure in which you sell each item. For more information, see “Adding or Modifying an Item” (page 39).
  6. When you create customer groups, select the rate type for the group and enter a credit limit in each of the currencies used by the national accounts and customers you will assign to the group. For more information, see “Adding, Modifying, and Deleting Customer Groups” (page 66).
  7. If you create national accounts, select an account set that uses the currency of the account, then enter the credit limit amount in that currency. Also, enter a rate type for converting amounts in the customer currency to the functional currency. For more information, see “Adding, Modifying, and Deleting National Accounts” (page 72).
  8. When you add customer records, assign each record to the account set that uses the customer’s currency. If a customer is part of a national account, the account set and currency are specified by the national account, and you cannot change them. For more information, see “Adding and Modifying Customer Records” (page 86).