ERP User GuideMicrosoft Dynamics NAV

Microsoft Dynamics NAV

Sana Commerce 9.3
Your connector

Location Code & Inventory



Stock is shown in a Sana webshop on all product pages. This can be a simple text, a stock indicator of different colors, or a stock amount. Stock amount is retrieved from and calculated by Microsoft Dynamics NAV real-time. Thus, when customers create orders from a Sana webshop, stock is automatically adjusted by Microsoft Dynamics NAV.

For information on how to change stock presentation in the Sana webshop, read about custom stock texts. More information about stock settings you can also find in the "Products" article.

Set up location code 

On the Customer Card, on the Shipping FastTab, you can set up Location Code that is used to suggest items to a customer from a particular inventory location.

You can use location code either from the Customer Card or set up the default location code for a webshop that will be used for all customers.

In Microsoft Dynamics NAV click: Departments > Webshop > Lists > Webshops.

On the Webshop Card on the Warehouse FastTab, in the Location Code Source field select which location code, either from the Customer Card or from the Webshop Card, should be used to suggest items from a particular inventory location.

If you set Location Code Source to Webshop, then in the Location Code field you should select the location code for the webshop. Location code can be set for each webshop individually.

Inventory Calculation

There are two methods that are used to calculate inventory and show number of products in a stock to a customer.

In the Inventory Calculation field, you can select which quantity of items should be shown to a customer.

Choose one of the inventory calculation methods:

Inventory calculation Description
Inventory - Qty. on Sales Orders This method calculates how many units of an item are physically available. It takes into account how many units of the item are physically available minus quantity on sales orders (how many units of the item that are reserved for sales orders).
Projected Available Balance This is the calculated available inventory. It takes into account how many units of the item are physically available minus quantity on sales orders plus quantity that is planned to be delivered to the warehouse (calculated based on the data in the Item Availability table).

If you select this inventory calculation method you can also enter Projected Date Calculation. In this field you can enter a date formula based on which the projected available balance will be calculated. You should use the standard Microsoft Dynamics NAV date formulas.
For more information about date formulas and examples, see "How to: Enter Dates and Times" in the MSDN Library.

ERP User GuideMicrosoft Dynamics NAV