What's the fastest way to get an item's inventory ...
# suitescripta
Alan Fitch
04/27/2022, 6:18 PMWhat's the fastest way to get an item's inventory by bin and lot with SuiteScript?
b
battk
04/27/2022, 6:56 PMprobably a query for the inventory balance
battk
04/27/2022, 6:56 PMsearch is probably comparable
a
Alan Fitch
04/27/2022, 6:58 PMCan I do an Inventory Balance search in suitescript?
b
battk
04/27/2022, 6:58 PMyes
t
tdietrich
04/27/2022, 8:01 PMWill this work?
Copy code
SELECT
Bin AS BinID,
BUILTIN.DF( Bin ) AS BinName,
OnHand
FROM
ItemBinQuantity
WHERE
Item = 151
ORDER BY
BUILTIN.DF( Bin )a
Alan Fitch
04/27/2022, 8:02 PMI wish.. I need the lot and the bin.
t
tdietrich
04/27/2022, 8:11 PMHave you looked at the InventoryNumberLocation table?
tdietrich
04/27/2022, 8:12 PMActually, I guess that doesn't get you to the bin.
tdietrich
04/27/2022, 8:12 PMSeems like a SuiteQL "blind spot."
b
battk
04/27/2022, 8:30 PMuse the InventoryBalance table
a
Alan Fitch
04/27/2022, 8:35 PMAMAZING! Is this new?