Skip to main content

Inventory - Product

Inventory on hand, allocated, on order, and available report

This report will show the inventory details such as qty, brand, and category of all variants summarized to their respective products.
​

Filters

SKU - SKU Name or SKU Code
​SKU Category - Product category
​OnHand Qty - On hand qty range
​Allocated Qty - Allocated qty range
​OnHold Qty - On hold qty range
​Tags - Tags

Data

This report includes the following Fields

SKU Name - Product Name
​SKU Code - SKU Code
​Category - Product category
​Brand - Product brand
​UOM - Unit of measure
​OnHand - Qty that is physically in the warehouse
​Allocated - Qty that is allocated to sales orders
​OnHold - Qty that is in hold location
​Available - Qty that is available to sell
​OnOrder - Qty that is coming from vendors 

Note: When all is toggled for warehouses, the inventory totals will be a sum of all the warehouses.

Links

Note: Allocated and OnOrder qty will be clickable if qty is greater than 0.

Allocated -  Shows all the sales orders this variant is allocated on.
​OnOrder - Shows all the purchase orders this variant is OnOrder.

Info

Reports can be exported to PDF and Excel. Reports can also be emailed to 5 email addresses at a time.
​

Did this answer your question?