Automatically displaying product price in foreign currency

Select Auto Calculate Foreign Currency option in SA Administrator Options-Products-Pricing to automatically calculate and display the amounts on a sales order in the customer’s currency if the customer is a foreign customer. This option eliminates the need to create pricing records in foreign currency or to use a manual calculator during order entry to calculate the prices in foreign currency.

The foreign currency calculation uses the currency specified for the customer in the Currency field in Customer Setup-General and the Sales Exchange Rate specified in SA Currency Setup. The sales exchange rate is determined when the order is created and is maintained throughout the life cycle of the order.

If the Auto Calculate Foreign Currency option is enabled and the customer is a foreign currency customer, then all prices, discounts, etc., are still stored in the currency set up for the company. These values are then converted to the current foreign currency exchange rate and displayed on the sales order when it is created. Costs and margins on an order are always displayed in domestic currency.

If Auto Calculate Foreign Currency is not selected and the customer is a foreign currency customer, then you are expected to create pricing records in the foreign currency to see the product price in the customer’s currency during order entry. If the pricing records in foreign currency are not available, then prices are displayed in the currency set up for the company.

Standard currency codes such as USD, MEX, CAD are prominently displayed throughout the Sales and Transfer modules to show that the transaction is a foreign currency transaction.

To automatically calculate foreign currency amounts for a customer with foreign currency:

  • Enable the Auto Calculate Foreign Currency option in SA Administrator Options-Products-Pricing.
  • Update the Currency field in Customer Setup-General to a currency that is different from the company currency.
  • Specify the Sales Exchange Rate and Standard Currency Code in SA Currency Setup.

If this option is selected, only the amounts displayed in these screens are recalculated to show order amounts in the customer's foreign currency:

  • Sales Order Inquiry
  • Sales Customer Pricing Inquiry
  • Sales Order Entry-Advanced Line Entry
  • Sales Order Entry-Advanced Line Entry-Kits
  • Sales Order Entry-Easy Line Entry
  • Sales Order Entry-Quick Line Entry
  • Sales Order Entry-Shopping List
  • Sales Order Entry-Advanced Line Entry-Rebate
  • Sales Order Entry-Advanced Line Entry-Manual Rebate
  • Sales Order Entry-Advanced Line Entry-Pricing
  • Sales Order Entry-Advanced Line Entry-Edit Lines-Pricing or Costing Worksheet
  • Sales Order Entry-Copy