The Inventory Details report shows the current stock you have on hand, the amount of stock committed to sales orders and the stock you have available for sale.
To view the Inventory Details report, click on the Intelligence tab on your main navigation bar and then the Reporting tab. Scroll down to the inventory section as shown below.
You will be directed to the following page where you can view a list of all your Inventory details reports'.
Use the metrics and filters to view your inventory by locations, SKU, product type, supplier, and more.
Each field identifies data using a different attribute. The attributes are:
1Exclude Out of Stock – Filters out products that are OOS
2Location – Filters for products in a specific location
3Product – Filters for a specific product
4Product Brand –Filters for products with a specific brand
5Product Status –Filters for active or inactive products
6Product Tags – Filters for products with a specific descriptive tag assigned
7Product Type – Provides a drop-down box to filter by the types of products in the inventory
8SKU – Locates the exact item with the defined SKU
9Supplier – Filters products from a specific supplier
10 Variant – Filters the search by the name of the variant
Once you've set your search criteria and run the report, a list will be generated by applying those parameters.
✅ For e.g., if you're looking for items that are currently SoH, Available, and excludes OOS, you will see this:
This list will entail the quantity of the items you have in stock, how many of those are committed to sales orders, how many are left over for that product as well as how many you have on order (this is the amount of incoming stock).
You can then export the report into a .csv format and download the file by clicking the 'Manage Report' button on the top right-hand corner.