Skip to main content
Inventory - Product

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

Updated over 7 years ago

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?