Skip to main content
Inventory - Variant

Inventory on hand, on order, allocated and available report

Updated over 7 years ago

This report lists all the variants in the system with details such as qty, location, brand, and category. 

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


Main Header

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: Toggle the row to see more details of the variant.

Sub Header

Warehouse - Warehouse name (Only shows when all is selected)
Location
- Variant location
Tracking Fields - Tracking information such as serial #, lot # and so on.
OnHand - Qty physically at the location
Allocated - Allocated qty at the location

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?