How can I see the inventory history for an item?
# inventorya
Alan Fitch
04/14/2021, 1:40 PMHow can I see the inventory history for an item?
t
tdietrich
04/14/2021, 1:59 PM@Alan Fitch If you're looking for a way to get an item's balance history, then this might help: https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/
s
Sandii
04/14/2021, 2:07 PMIf you want to see more items, the native inventory valuation can show you the inventory or anything on a given date, but it only shows you that single day.
a
Alan Fitch
04/14/2021, 2:55 PM@tdietrich Thanks; That works great. What about all items currently in a bin? What about a bin history?
Alan Fitch
04/14/2021, 2:59 PM@tdietrich I see that script is yours. Good work.
t
tdietrich
04/14/2021, 5:03 PM@Alan Fitch I don't have specific solutions for the bin questions, but there are a few tables you can query (via SuiteQL) to get that type of data. I talk a little about them here: https://timdietrich.me/blog/netsuite-suiteql-empty-warehouse-bins/
a
Alan Fitch
04/14/2021, 5:09 PMThanks; I will take a look.
Alan Fitch
04/14/2021, 5:12 PMBTW where can I find SuiteQL documentation.
t
tdietrich
04/14/2021, 11:21 PM