I'm looking to create a list of all inventory items that we have. Most of our items are stored in 2 different geographical locations, and each location may have the same item stored in a primary bin (picking), and another bin (secondary storage bin).
I'm trying to get an export of all items, and the locations and bins that they are stored in. Each row would need to be a separate display of the item's quantity. I want to be able to see the detail of where all items can be found in our locations.
Desired output (columns separated by hyphens) For example:
Item 1 - Location 1 (WHS) - Bin AA2 - Qty 50
Item 1 - Location 1 (WHS) - Bin ZZ9 - Qty 100
Item 1 - Location 2 (Store) - Bin 30 - Qty 5
Item 2 - Location 1 (WHS) - Bin AB3 - Qty 20
Item 2 - Location 1 (WHS) - Bin ZA4 - Qty 13
Item 2 - Location 2 (Store) - Bin 10 - Qty 10
I've tried running a Item saved search with the following columns:
Name
Display Name
Inventory Location : Name (To display the location where the item is stored)
Location Available (this appears to sum up all quantities across bins at the location, so this is not working for me)
I've tried adding inventory detail fields, bin fields and all to no avail.
Anyone with experience out there that can tell me what I'm doing wrong?
You want to get the "Bin On Hand" fields:
You can get Location, Bin Number and On Hand from this join in your Saved Search. When done your results fields should be:
Todd Stafford