SAP Business One

Inventory Calculation

Stock is shown in a Sana web store 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 SAP Business One real-time. Thus, when customers create orders from a Sana web store, stock is automatically adjusted by SAP Business One.

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

Set up locations and warehouses

Step 1: In SAP Business One, click: Administration > Setup > Inventory > Locations.

Use the Locations - Setup window to define geographical locations for warehouses. This allows you to group warehouses in your system based on their physical location.

Step 2: In SAP Business One, click: Administration > Setup > Inventory > Warehouses.

Use the Warehouses - Setup window to specify all the general information about the warehouses your company uses.

Make sure that the warehouse is active. Otherwise, it will not be used.

In the Location field select the warehouse location specified in the Locations - Setup window.

Set up the default warehouse

In SAP Business One, click: Administration > System Initialization > General Settings > Inventory.

On the Inventory tab, in the Default Warehouse field, select the default warehouse.

Item inventory data

In the Item Master Data, on the Inventory Data tab, an item can be assigned to several warehouses. Here you can keep track of items that are sold and purchased by your business. You can see the inventory level in stock, committed (the quantity ordered by customers), on order (quantity ordered with your vendor by you but not yet delivered), and available in all your warehouses.

 NOTE

Make sure that those warehouses that are used to calculate inventory and show stock amount in the web store are not locked.

Set up inventory calculation method

There are two methods that are used to calculate inventory and show stock amount to the customers in the Sana web store. You can either set up inventory to show how many units of an item are physically available or the projected available balance. You can also show stock amount from a specific warehouse or the total amount from multiple warehouses.

Step 1: In SAP Business One, click: Web Store > Web Stores. Select the necessary web store and go to the Stock Presentation tab.

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

Choose one of the inventory calculation methods:

See the example of the inventory data of the item.

Step 3: Choose whether to show stock amount from a specific warehouse or the total amount from multiple warehouses.

Step 4: Choose from which warehouse the stock amount must be deducted.

• If you show total stock amount from all warehouses assigned to the item or from multiple predefined warehouses, the stock amount can be deducted either from the default warehouse set in the General Settings window, or from some specific warehouse.
  
  
• If you show stock amount from a specific warehouse, the stock amount will be also deducted from this warehouse.

See also: