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?