which report i can use to check available lot number or serial number of inventory as of date

AI generated answer (using internal Slack threads):

In NetSuite, you can use the "Inventory Snapshot" report to check the available lot number or serial number of inventory as of a specific date. This report shows the quantity on hand per lot number per item for any date selected. To access this report, navigate to Reports > Inventory/Items > Inventory Snapshot. If you don't see a date filter, you might need to add it manually. Another option is to use the "Inventory Valuation" report. This report can also show inventory levels as of the current date. If you are comfortable with SuiteQL, you can use a Suitelet to get a report like this. There is a "Running Inventory Balance" SuiteQl query mentioned in this blog post that might help: https://timdietrich.me/blog/netsuite-suiteql-item-transactions/ Alternatively, you can use a Saved Search solution to add a Subtab to item records. Here is a link to a blog post that explains this solution: https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******