Quantity by Item report
The Quantity by Item report, under Reports>Quantity by Item, shows you a list of all inventory items with the same item master, within a warehouse or across all warehouses. Even if some of the inventory items are in different locations, or have other distinguishing differences, such as Lot # or Serial #, all of the inventory items are rolled up by Item # in this report.
From this report, you can highlight an Item # and select View to see detailed information about all of the individual inventory items of this item master.
From the drill-down page, you can view, edit, adjust, transfer, and ship inventory. You can also export the list to an .xls spreadsheet.
The Quantity by Item report (at Reports>Quantity by Item) displays a list of all inventory items with the same item master, within a warehouse or across all warehouses.
To view a quantity of inventory:
- From the Quantity by Item report, highlight an Item # and then select
View, up above. - The Item Master Inventory screen appears.
- The top part of the screen lists general and aggregate information for this Item #, such as Item Type and Total Qty on Hand.
- Down below, the Inventory Items table splits out all of the inventory items with this Item #. This means that if there are quantities of the same Item #, but they differ in other ways, such as having different serial numbers, or item receipt dates, this screen will display those quantities on different lines.
- From here, you can:
- View an inventory item (Select an item, then select
View, in the Inventory Items table header.) - Edit an inventory item (Select an item, then select
Edit, in the Inventory Items table header.) - Adjust an inventory item (Select an item, then select
Adjust, in the Inventory Items table header.) - Bin Transfer an inventory item (Select an item, then select
Bin Transfer, in the Inventory Items table header.) - Export the list (Select
Export, in the Inventory Items table header.)
If you have a multi-warehouse operation and have All warehouses selected at the top of the screen, this screen will show all items with the same item master across all of your warehouses. Also in the All Warehouses context, you can only view or export from the Inventory Items table; you cannot make changes to specific inventory items.
|