i want to build report or saved search for items show the item opening balance and the quantity received of this item and the quantity returned and the net sales

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can create a saved search or report in NetSuite to show the item opening balance, the quantity received of this item, the quantity returned, and the net sales. Here are the steps you can follow: 1. Go to Reports > New Search. 2. Select the type of search you want to create. In this case, you might want to create an 'Item' or 'Transaction' search. 3. In the Criteria subtab, you can set the filters for your search. For example, you can set the 'Date' field to a specific range to get the opening balance. 4. In the Results subtab, you can choose the fields you want to display in your search results. You can add 'Quantity On Hand', 'Quantity Received', 'Quantity Returned', and 'Net Sales' fields. 5. Save and run your search. Please note that the exact fields and criteria might vary depending on your specific business needs and NetSuite setup. Also, if you need to get the quantity on hand per lot number per item as of any date selected, you might need to use SuiteQL or a Suitelet as mentioned in one of the conversations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******