Viewing an item in all the locations in which it is stored

If your warehouse stores a single item master in several different locations across the warehouse, you can use Reports>Quantity by Item to view all the locations where you can find that inventory for that item.

To view all the locations in which an item is stored:

1. Select Reports>Quantity by Item to view the Quantity by Item report.
2. A list of Item #s appears. Notice that the quantity for each Item # is the total quantity at the warehouse. This quantity may be spread across several Locations, have various Serial #s, Expire dates, or other differences. But on this screen, it is combined and displayed as one line item.
3. Highlight an item and select View, up above.
4. 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.
5. In the Inventory Items table, the Location column shows you all of the locations in which this Item # is stored. Click the column header to sort by location.
   • From here, you can also select an item and choose to view, edit, adjust, or bin transfer it. More info...

     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:

     1. From the Quantity by Item report, highlight an Item # and then select View, up above.
     2. 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.
     3. 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.

© 2011 RedPrairie Corporation www.smartturn.com