Hi NetSuite experts,
- I have created a Custom Field with List/Record type entitled EWT Remaining. The list options are: (1) With EWT (2) No EWT.
2. I created a Workflow.
- Transaction Type: Invoice
- State: Entry
- Action: Set Field Value
- Parameters
: EWT REMAINING=NO EWT
- Condition
: {amountremainingtotalbox}=0
3. My expected scenario is that every time the Status is Paid In Full or the Remaining Amount in the Total box is Zero then it should automatically update the Custom Field as No EWT.
Upon testing, I can only trigger the workflow when re-saving the Invoice. I wanted to trigger the Workflow when Status is Paid in Full or Remaining Amount in summary box is Zero.
I understand that my State shouldn't be Entry, but I also tried After Field Sourcing/After Field Edit, but cannot seem to make it work. Please advise. Thank you!