wondering what i'm doing wrong here. we have an it...
# inventoryv
Vtor
10/12/2020, 4:35 PMwondering what i'm doing wrong here. we have an item that's sitting in a Bin that shows up on the stock ledger and on the item itself. but if we try to show the stock on hand in a saved search it comes up as no results. i'll put screenshots in the thread underneath this
Vtor
10/12/2020, 4:36 PMthis is from the item record
Vtor
10/12/2020, 4:38 PMthe report
Vtor
10/12/2020, 4:39 PMtrying to filter saved search by bin #
Vtor
10/12/2020, 4:40 PMor if we filter search just by the item in question... it shows a different bin, but empty?
s
Sandii
10/12/2020, 5:02 PMWhat saved search are you using for the 3/4 pictures?
v
Vtor
10/12/2020, 5:21 PMone sec, ill send sreens
Vtor
10/12/2020, 5:22 PMmessage has been deleted
Vtor
10/12/2020, 5:22 PMmessage has been deleted
Vtor
10/12/2020, 5:22 PMi started throwing random fields into the results cuz i couldnt figure out what the problem was, like if i was just missing a join field or something
s
Sandii
10/12/2020, 5:33 PMyeah to get bin quanties, definitely use
bin on hand fields...Sandii
10/12/2020, 5:33 PMand use
bin on hand fields... bin numberk
KevinJ of Kansas
10/12/2020, 5:55 PMAlso - it's very possible you have bins with negative inventory - so make sure your item view is only configured to show if not equal to zero instead of greater than zero
💯 1
v
Vtor
10/12/2020, 9:13 PM@Sandii that was it. you are my hero
5 Views