Inventory tracking in Ordoro – Physical On Hand, Total Available , Total Committed, Reordered

On the Products List page of Ordoro, if you expand the row, you will see all the inventory related information for that product.

In the screenshot above, you can see the inventory information for the SKU 10001L. The product name is Batman Figure.

In the Physical On Hand column, you can see the physical stock level of that product across all your warehouses. This is the actual number of units in stock in your warehouse shelves. In this example, you have 10+20=30 units total in stock across your two warehouses.

  • Warehouse A – 10
  • Warehouse B – 20

The Total Committed column shows how many units of this SKU are included in open orders (Awaiting Fulfillment), waiting to be shipped out of your warehouses. In this example, there is an open order for this SKU for 1 unit. When you ship out that order, the “Total Committed” column will drop down to 0. And if you ship it out of Warehouse A, the latest Physical On Hand numbers will be

  • Warehouse A – 9 (deducted the qty 1 from the Total Committed)
  • Warehouse B – (unchanged from before)

The Reordered column shows how many units of this SKU are included in open purchase orders (restock orders sent to your suppliers). When you receive a Good Receipt on a PO, the warehouse you receive the items into will add stock to the warehouse inventory.

  • For example: You have 10 on reorder on a PO and receive all 10 units into Warehouse B, the latest Physical On Hand numbers will be
    • Warehouse A – 9  (unchanged from before)
    • Warehouse B – 30 (incremented by 10 units)

So what quantity gets written back to your sales channels during the next inventory sync?

The answer is Total Available, which is calculated the following for a SKU/product:

TOTAL AVAILABLE = Sum of Physical On Hand across all warehouses – Total Committed

In the example from the screenshot shown above, the Total Available is calculated as [20+10] – 1 = 29. Therefore, 29 units will be written back as your stock level to all of your online sales channels.

Tagged: