ERP User GuideSAP Business One

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.

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:

Inventory calculation method  Description
In Stock This method shows how many units of an item are physically available.

When this method is selected, the stock amount is retrieved from the Item Master Data, the Inventory Data tab, the In Stock field.

In Stock - Committed + Ordered This method takes into account how many units of an item are physically available (In Stock) minus quantity Committed (how many units of the item that are reserved for sales orders), and plus quantity Ordered (quantity that is planned to be delivered to the warehouse).

When this method is selected, the stock amount is retrieved from the Item Master Data, the Inventory Data tab, the Available field.

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.

Show stock from Description
All Warehouses Show total stock amount from all warehouses assigned to an item.
Multiple Warehouses Show stock amount from multiple warehouses. If you select this option, you must add warehouses to the table on the right. The total stock amount will be calculated for the selected warehouses.
Specific Warehouse Show stock amount from the specific warehouse. If you select this option, you must specify the warehouse from which stock amount must be retrieved.

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:

Locations - Setup
Warehouses - Setup Window
Item Master Data: Inventory Data
ERP User GuideSAP Business One