Rob
09/20/2024, 2:41 PMCeligo AI
09/20/2024, 2:42 PMAI generated answer (using internal Slack threads):To automatically create a Work Order (WO) from Sales Order lines, you can use a SuiteScript. Here's a general approach based on the conversations: 1. You can create a User Event script that triggers on the 'beforeSubmit' event of the Sales Order. This script would check if the line item will be backordered (i.e., if
quantityavailable - quantity < 0
). If the condition is met, it would check the 'createwo' box on the Sales Order line.
2. Alternatively, you can create a Map/Reduce script that creates Work Orders from Sales Orders upon creation and ties the WO# back to the line in the 'Create WO' field.
Please note that there is no native transform function from Sales Order to Work Order in NetSuite. Also, the 'createwo' checkbox on the Sales Order line can only be checked when the order is being created.
Remember to handle exceptions and errors in your script. For instance, if the assembly item is not always made and sometimes purchased, you might encounter errors if the item has a preferred vendor listed but is not a special order or drop ship item.
******
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
09/20/2024, 2:42 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833073795
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829947472
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828098953
Celigo AI
09/20/2024, 2:42 PM