This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

{732A2052-2666-4DED-A491-D305B4A16690}.png

On a sales order i have the field accounting hold which is being sourced from the customer record accounting hold. I'm trying to create a workflow where the sales order exceeds the customer credit limit, put the accounting hold field as credit hold. the below conidion is what i have. i also tried the condition backwards where the SO total is greater then customer credit limit

maybe you need to use a saved search condition instead?

Also, wouldn't credit limit be the sum of all unpaid invoices, not the total of one sales order?

You would probably want to calculate the customer available credit
So customer credit limit - customer open balance = available credit
The in total grater than available credit you would transition the workflow to pending approval

You can make a field on the sales order called current available credit
And use the formula above to set the value
Then use this field in your transition criteria