Hi Gurus,
I’m working on building an approval process for Credit Memos using NetSuite’s standard Return Authorization → Credit Memo approval process and statuses. My goal is to use a workflow triggered by Return Authorization status change to Pending Approval to:
- Restrict access to Approve/Cancel buttons based on roles
- Lock the approved record once it’s approved
- Use a Transform Record action within the workflow to create the Credit Memo automatically after approval
The challenge I’m running into - adding a check or condition to prevent duplicate Credit Memos from being created. I’m having trouble identifying Return Authorizations that already have linked Credit Memos through a saved search (not all credit memos are applied). I also tried using a custom checkbox, but that didn’t work since the Transform action runs after record submit.
Before I go down the route of using a custom script to both handle approval logic and perform the transform, I wanted to ask:
- Has anyone implemented something similar?
- Any best practices or recommendations for handling the “avoid duplicate transform” logic or for managing approval-based transforms purely in workflows?
Appreciate any guidance or examples!