Microsoft Dynamics GP

Currencies

A Sana webshop supports multicurrency. This means that when a customer logs in to the Sana webshop, he or she will see prices in his or her local currency.

Multicurrency setup

If you are doing business in different countries and you want your customers to see prices in their local currency, the Multicurrency Management module should be enabled and setup in Microsoft Dynamics GP. To enable the Multicurrency Management module in Microsoft Dynamics GP, click: Tools > Setup > System > Registration.

Exchange Rates

 NOTE

Applies to: Sana Commerce 9.3.5 in Microsoft Dynamics GP and higher

If you are using the Multicurrency Management module, you should also make sure that the exchange rates are set up correctly for each currency that you are using in the Sana webshop.

In Microsoft Dynamics GP click: Sana Commerce > Currency Setup. Click Exchange Rate Validation.

In the Exchange Rate Validation window you can check if the exchange rates are set up correctly for all currencies used in the Sana webshop. If some currency does not pass validation, then a customer who uses this currency will not be able to order from the Sana webshop. That is why you need to fix the exchange rate of the currency.

For more information about how to set up the Multicurrency Management module in Microsoft Dynamics GP and exchange rates, see "Multicurrency Management in Microsoft Dynamics GP" on the Microsoft website.

Default currency setup

If multicurrency is enabled in Microsoft Dynamics GP, you need to set up the default currency. Click: Tools > Setup > Financial > Multicurrency. In the Multicurrency Setup window, use the Functional Currency field to setup the default currency. The functional currency is the primary currency that the company uses. It will be used, if there is no currency set for the customer.

If the Multicurrency Management module is disabled in Microsoft Dynamics GP, the default currency is taken from the webshop settings.

The default currency set for the Sana webshop is used only when multicurrency is disabled in Microsoft Dynamics GP.

Currencies setup

To set up currencies in Microsoft Dynamics GP, click: Tools > Setup > System > Currency.

All currencies available in Microsoft Dynamics GP has the ISO code. This is the standard code of the currency as defined by the International Organization for Standardization (ISO). If you create any custom currency (nonstandard), it should be linked to the ISO Code. If a custom currency is created and set for a customer, Sana will use the one that is linked to the ISO Code to comply with ISO standards.

In Microsoft Dynamics GP click: Sana Commerce > Currency Setup. In the Currency Setup window use the Visible in Webshop checkbox to enable the currency for the Sana webshop. Only those currencies which are set as visible in webshop in Microsoft Dynamics GP will be indexed by Sana and used in the webshop.

Checkbooks are used to keep payment records and track all invoice payment transactions of your customers that you can reconcile with your bank statements. A checkbook stores cash and bank accounts information.

For more information, see "Online Invoice Payments".

Customer currency setup

Webshop visitors who are not logged in to the Sana webshop as a customer will see prices in the currency which is set for the customer template assigned to the webshop.

When a business customer logs in to the Sana webshop, the currency which is set in the customer master data in Microsoft Dynamics GP will be used. To set up customer's currency, open the Customer Maintenance window, select the customer, and click Options. In the Customer Maintenance Options window use the Currency ID field to set up the currency for the customer.

When a customer registers in the Sana webshop online, the currency which is set in the customer template associated with the country in Microsoft Dynamics GP, will be used for the customer.

For more information about countries setup, see "Countries".

Item currency setup

In Microsoft Dynamics GP click: Inventory > Cards > Item Currency. Use the Item Currency Maintenance window to assign all the necessary currencies to the item. If you don't use Multicurrency Management, you don't need to assign currencies to the items.

If you're using standard pricing and the pricing method is Percent of List Price, enter the List Price in the currency you're assigning to the item. You should enter the list price for each item currency.