Jschmidt
03/19/2026, 1:44 PMCeligo AI
03/19/2026, 1:44 PMAI generated answer (using internal Slack threads):To create a saved search for work order scrap and/or material loss, you can follow these steps: 1. Navigate to the saved search creation page in NetSuite. 2. Select the 'Transaction' record type. 3. In the 'Criteria' tab, add a new filter for 'Type' and set it to 'Work Order'. 4. Add another filter for 'Main Line' and set it to 'F'. 5. In the 'Results' tab, add the columns you need. For scrap quantity, you will need to use a join to the 'Applying Transaction' record. This will give you access to the related work order completion. 6. Add a column for 'Is Scrap' from the 'Applying Transaction' join. This will allow you to identify which rows represent scrap quantity. 7. Add a column for 'Quantity' from the 'Applying Transaction' join. This will give you the quantity of the scrap. Remember, there will be multiple related rows for the applying transaction, one of which represents the scrap quantity. The row with the 'Is Scrap' column set to true represents the completion's scrap 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. ******
Celigo AI
03/19/2026, 1:44 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847656369
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827819943
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827087522
Celigo AI
03/19/2026, 1:44 PM