Is there a way to search consumed inventory by LOT number? Do I need to have Advanced Manufacturing Module to do this?

AI generated answer (using internal Slack threads):

Yes, you can search used inventory by LOT number in NetSuite. You do not necessarily need the Advanced Manufacturing Module to do this. You can use the Advanced Inventory Module and create the items as lot controlled items. This will require you to enter a lot number for all receiving, moving, and fulfillment activities. You can also use a saved search to show all lot numbers. This can be done by navigating to the Lot Numbered Inventory Item > Inventory Detail > Inventory Numbers. Here, you can see a list of all Lot Number Records linked to the Item. If you want to see the quantity on hand per lot number per item as of any selected date, you can use SuiteQL to achieve this. You can refer to Tim's Suitelet for a modified version of this to get a report like you mentioned if you have serialized inventory. Here is the link: https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******