Inventory Report

Modified on Wed, 15 Dec 2021 at 09:25 AM

A report on the current inventory in the warehouse can be downloaded from the customer dashboard. The download is available in the "Inventory" area via the "Inventory Report" button at the top right of the screen.

The inventory report can be exported and itemized by lot number and/or can be itemized by warehouse. If the "itemize by lot" option is selected, one row per SKU and one for each individual LOT number is included for each SKU that has batch tracking activated.

In the picture below, line number 2 in the table contains the general product information. The following lines (3-9 in this example) include the batch number (column “Lot Number”), the best-before date (column “Expiry Date”) and further available information about the batch.

Physical Stock vs Reserved Stock

As soon as an order is released, the corresponding inventory is “reserved”. This prevents more orders from being released than are currently in stock. This reservation is made in two steps: in the first step, the inventory is reserved at the warehouse level. At this point it has not yet been determined which batch or storage location is used for picking.

In the second step, the pick is planned in the warehouse and a batch or storage location is determined. For this reason, the "Reserved Stock" is reserved first in the line without LOT information (i.e. at the warehouse level) and then in the line with LOT information (i.e. at the LOT or storage location level).

Once the pick is complete, the physical inventory will be reduced and the reserved inventory released.

Calculate available inventory

In order to calculate the currently available stock (the stock that is still available for sale), the number must first be calculated from “Reserved Stock” and then deducted from the total “Physical Stock” to get the amount of currently available stock. 

This can easily be done with a spreadsheet program like Excel or Google Sheets.

Column description

    SKU: The Stock Keeping Unit of the product

    Lot Number: The lot number

    Expiry Date: The best-before date of the batch

    Not Before: The earliest shipment date of items from the batch

    Not After: The latest shipment date of items from the batch

    Lot Activated: batch activated or deactivated for picking

    Physical Stock: The physical stock

    Reserved Stock: The reserved stock

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article