Can I have a saved search for "Inventory on hand" ...
# suitescripta
Alan Fitch
05/19/2021, 4:41 PMCan I have a saved search for "Inventory on hand" in suitescript?
Edit: I mean Inventory Balance. I explain it more in the replies.
s
Sandii
05/19/2021, 4:45 PMYep, same way you would make it when creating a saved search in UI.
a
Alan Fitch
05/19/2021, 4:52 PMWhat is the "type" of the search?
Alan Fitch
05/19/2021, 4:54 PMFor any given item I need the stock level broken down by bin and lot number.
Alan Fitch
05/19/2021, 4:56 PMi.e item x
there are 20 in bin 17 of lot 42.
There are 13 in bin 17 of lot 43.
There are 12 in bin 18 of lot 42.
s
Sandii
05/19/2021, 4:59 PMStart at item search, play with all the joins to
bin on hand fields...a
Alan Fitch
05/19/2021, 5:02 PMbin on hand fields don't break it down by lot.
Alan Fitch
05/19/2021, 5:05 PMmessage has been deleted
Alan Fitch
05/19/2021, 5:05 PMThis currently works
s
Sandii
05/19/2021, 5:41 PMAh yeah I do not have much experience with search lot specific, usually just use bins
a
Alan Fitch
05/19/2021, 5:41 PMWe mix lots in bins :(
2 Views