How to get on so quantity on inventory item saved search report

AI generated answer (using internal Slack threads):

To get the on-hand quantity on an inventory item saved search report, you can follow these steps: 1. Navigate to Reports > New Search > Item > click "Create Saved Search". 2. Set your Criteria: - Filter: - Transaction Fields... > Type > (any transaction that affects inventory) - Transaction Fields... > Date > (whatever date range you want) 3. Set your Results: - Formula (Numeric) > Group = SUM - CASE WHEN {the items which affect inventory/Quantity on Hand negatively} THEN ({quantity}*-1) ELSE {quantity} END This formula will sum up the quantities of the transactions that affect the inventory. If the transaction decreases the Quantity on Hand, it will multiply the quantity by -1, otherwise, it will just take the quantity as is. If you want to get the quantity available for all the items for a particular inventory location only, you can use 'Location Available' in the results rather than 'Available', and filter on 'Location'. Please note that this is somewhat advanced, and you might need to consult with a NetSuite professional if you encounter any issues. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******