Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Creating a task after an invoice is created
It's a pretty simple workflow but somehow I am stuck. I need to create a task after our accounting department saves an invoice so that our sales engineer team knows to call the customer and follow up. I know it should be pretty straight forward but somehow I have messed it up. Below is my logic:
Customer Record: Custom field called "Sales Engineer" that is an employee based list but is not required and often empty.
Workflow: When an invoice is submitted, I want a task to be assigned to the sales engineer so that they will know to follow up with the customer. The logic is simple and was able to join the invoice to the customer record in workflow and it worked great when the Sales Engineer is present. The kicker is I want NS to assign the record to an SE by default if the field is blank. I tried a formula for this logic and keep on getting that I am using an "Invalid Expression". My logic for the formula is