Scenario:
We have an integration where Oracle automatically creates Sales Orders in NetSuite. For orders with a total amount of 0, we need to automatically close them instead of handling them manually.
To achieve this, I created a custom transaction body field that gets checked when Oracle sends an order with a total amount of 0. The idea is to use this field as a trigger in a workflow to close the Sales Order.
Issue:
- When the transaction body field is checked, I’m unable to:
- Trigger or update line-level fields via the workflow
- Set the Sales Order status to “Closed” using
Order Status
What I’ve Tried:
- Using a workflow triggered on create/edit with the custom body field condition
- Attempting to set the order status directly to “Closed”
- Exploring line-level updates but unable to trigger them from the body field condition
Questions:
- Is it possible to close a Sales Order via Workflow when the total amount is 0?
- How can I trigger line-level actions based on a transaction body field?
- Is there a recommended approach (Workflow vs. SuiteScript) to automatically close such orders?