You can somewhat disregard the title. It started off as that, but has evolved.
We are having some issues with are inventory. We switched to lot controlled inventory and a new system so we have to do some cleaning. I am facing some issues trying to figure out where the bin inventory doesn't match the actual on hand inventory
Through the inventory Detail tab on item AB-B09 (see saved search results below)
Bin Avail On Hand Alex_Brandywine 49 49 RW102120102 27 27 RW102120202 20 20 RW102120302 24 24 RW102120402 20 20
Saved Searchcriteria > type = inventory/kit/goupresults > Name (group by)Bin Availble (sum)On Hand (Max)Bin On Hand Count (Sum)Bin Number(Formula NS_CONCAT bin number)This is the detail of the saved search when click on the same item. WHERE IS bin RW102120202 , RW102120302, RW102120402 ??? NAME BIN ON HAND AVAILABLE ON HAND BIN ON HAND COUNT BIN NUMBER AB-B09 0 140 0 Dock AB-B09 49 140 49 Alex_Brandywine AB-B09 27 140 27 RW102120102
Okay then I tried another way of doing this and looking and the inventory valuation report. This shows all of the bins. So I used a script to parse through and add up the numbers in parenthesis. Great worked well. Until someone pointed out the fact that negative bin quantities are not in here, rendering my analysis useless. RW102120102(27),Alex_Brandywine(49),RW102120202(20),RW102120302(24),RW102120402(20)
On more attempt. Using the Inventory Detail Fields... in the saved search. When I use this I end up getting like hundreds on bins. I am guessing it is tied to the transaction level.Saved Searchcriteria > type = inventory/kit/goupresults > Name (group by)Bin Availble (sum)On Hand (Max)Bin On Hand Count (Sum)Inventory Detail: QuantityInventory Details: On HandAll of this boils down to three basic questions I suppose.- Why are some bins missing from my saved search when I use Bin fields?- How can I get negative bin number to appear on inventory valuation summary report- Why are the inventory detail fields giving me so many duplicates on saved search, and how can I control against themIn the end I want to add up the quantity in the bins and compare against the on hand quantity to make sure we do not have discrepancies in our inventory.Thanks