how to create saved search for work order scrap an...
# ask-stanley-ai
j
how to create saved search for work order scrap and/or material loss
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.