Hi Gurus,
We've tried several methods to change the Vendor Return status to 'Pending Return', but none have been successful so far. Below are the approaches we've tested:
- Via Workflow:
The Order Status and Approval Status fields are not available in the Set Field Value action, which limits our ability to change the status directly. - Via Workflow – UI Workaround:
We attempted to hide the 'Approve Return' button based on specific conditions. While this workaround technically works, it introduces a security issue: the role must have Full permission for 'Approve Vendor Return'. This permission allows users who are not authorized approvers to still access and approve returns through the standard NetSuite Approve Vendor Return UI. - Via Workflow Action Script:
We tried setting the Order Status field to the internal value 'B', but this also had no effect.
We would greatly appreciate any guidance, alternative solutions, or best practices you could share to help us handle this scenario properly.
Thank you in advance for your support.