I need to know which Items are in specific bin as ...
# suiteanalyticss
Suitestallion
03/22/2021, 8:21 PMI need to know which Items are in specific bin as of today, when I am using Inventory Detail: Bin Number on the item search, I am getting Transaction (Item receipt) bin number, how do I get the Item bin number
k
KevinJ of Kansas
03/22/2021, 8:29 PMBin on Hand search?
KevinJ of Kansas
03/22/2021, 8:29 PMInventory detail is what I've always used.
KevinJ of Kansas
03/22/2021, 8:29 PMbut I suppose if you aren't using Lots/Serials, that would be overkill and bin on hand should suffice.
s
Suitestallion
03/22/2021, 8:30 PMwe do use lot/serial, but when do Inventory detail it gives me transaction information
Suitestallion
03/22/2021, 8:44 PMnot sure how to achieve this goal but the goal I am trying to achieve is are there any items in RI Quarantine and if there are which item receipt is it on. so in order to do that I think I need to see if there is any RI Quarantine Bin on the item record first.
k
KevinJ of Kansas
03/22/2021, 9:22 PMAre you trying to do this from a transaction search?
KevinJ of Kansas
03/22/2021, 9:23 PMYou can't do this from a transaction search - has to be an independent search.
s
Suitestallion
03/22/2021, 9:26 PMi tried Item search and Transaction search both
Suitestallion
03/22/2021, 9:27 PMindependent search? you mean item search
k
KevinJ of Kansas
03/22/2021, 9:28 PMYou can search inventory detail from the list of searches itself
KevinJ of Kansas
03/22/2021, 9:28 PMDon't join to inventory detail from item record... doesn't work well
KevinJ of Kansas
03/22/2021, 9:29 PMand then when you join to transactions you wind up with straight left outer joins (i.e. if I have two joins to 3 records each - I wind up with 9 rows)
s
Suitestallion
03/22/2021, 9:30 PMhmm thanks yes i did join the item record and inventory detail, let me do inventory detail search and i will ping again if that serves the purpose. thank you
Suitestallion
03/23/2021, 3:39 PMI am running to the same problem, it is still not pulling the item bin number, it still pulls the transaction bin numbers