I want to create a saved search with Items that shows the Available inventory and the latest ship date of the sales order that the items are on. How would I do this?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To create a saved search with Items that shows the Available inventory and the latest ship date of the sales order that the items are on, you can follow these steps: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select the "Item" record type. 3. In the Criteria subtab, you can add the following: - Main Line is False - Shipping Line is False - Tax Line is False - Type is Sales Order - Status is Sales Order: Pending Fulfillment, Partially Fulfilled, Partially Fulfilled/Pending Billing - Add criteria to remove drop ship line items (if applicable in your environment) - Add criteria for available items. If you auto commit items, you can add: Quantity Committed is greater than 0. If you don't auto commit, you might add: Quantity Available is greater than 0 and a Formula (Numeric) case when {quantity}-{quantityfulfilled} != 0 then 1 else 0 end (then make the value = to 1) 4. In the Results subtab, you can add the following: - Document Number - Name - Item - Quantity Available - Quantity Fulfilled - Latest Ship Date (you might need to use a formula to get this) Please note that this is a general guide and you might need to adjust the criteria and results based on your specific business needs and how your NetSuite environment is set up.