I need to create a saved search and in the results, get the items quantity committed, quantity picked and quantity (on the order, not in general)

AI generated answer (using internal Slack threads):

To create a saved search and get the items quantity committed, quantity picked and quantity (on the order, not in general), you can follow these steps: 1. Navigate to the saved search creation page in NetSuite. 2. Choose the 'Transaction' search type. 3. In the 'Criteria' tab, set the necessary filters for your search. For example, you might want to filter by 'Sales Order' transaction type. 4. In the 'Results' tab, add the following fields: - Quantity: This field represents the total quantity of the item on the order. - Quantity Committed: This field represents the quantity of the item that has been committed for fulfillment. - Quantity Picked: This field represents the quantity of the item that has been picked for shipping. Unfortunately, NetSuite does not have a specific field for 'Quantity Picked' in saved searches. However, you can calculate it using a formula. The formula would be

{quantity} - {quantitycommitted}

. This formula subtracts the quantity committed from the total quantity to give the quantity picked. For back orders, NetSuite also does not have a specific field in saved searches. But you can use a formula (Numeric) on search columns like this:

NVL({quantity},0)-NVL({quantityshiprecv},0)-NVL({quantitycommitted},0)

. This formula subtracts the quantity shipped and quantity committed from the total quantity to give the back order quantity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******