Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Static Saved Search Result
All,
I have a search that I need to build on work orders but I want one of the results to be static (not change) based on the first event that happens to the work order.
Example:
Work Order 123 is created however it has a back ordered item and cannot be built yet.
In the results tab I want a formula or SQL expression to have (or other suggestion):
CASE WHEN {quantity}<{quantitycommitted} THEN 'Backordered' ELSE END
However I want the statement to keep the result in this field as Backordered regardless of when it is no longer on back order for tracking purposes.
0