Where in NetSuite Analytics (NetSuite2 connector) can I find a table with all inventory lots - including ones that no longer have any on hand inventory?

AI generated answer (using internal Slack threads):

In NetSuite Analytics (NetSuite2 connector), you may not find a specific table that includes all inventory lots, including those that no longer have any on-hand inventory. However, you can achieve this by using SuiteQL or a saved search to sum all transaction lines, as suggested in the conversations. For instance, you can use Tim's Suitelet, which is a modified version of SuiteQL, to get a report like the one you mentioned. You can find more information about this on Tim's blog: [Tim Dietrich's Blog](https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/) Alternatively, you can use the Inventory Valuation report to get on-hand inventory from historical dates. However, this may not provide the available quantity. Please note that these methods require a good understanding of SuiteQL or saved searches in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******