I want to create a custom field in the item record to show if the item is used in a bill of material revision.
Is there a way to use workflows to achieve this? I would only like to create a script as a last resort.
Challenge:
- Workflows can only use saved searches based on the same record type - in this case, item records.
- NetSuite saved searches don't allow starting from an item search and drilling down into BOM revision components.
- The only way to list BOM components is through a BOM Revision saved search.
My idea was to use a Workflow to filter the BOM revision component internal ID by the item internal ID and update the Used in BOM custom field to False, if empty or True if the saved search return at least one result.