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!
System Notes/Line System Notes
Does anyone know if an easy way to use a formula much like a case statement to pull out one field on a line item in a system note or line system note on the results tab of a saved search (not criteria driven)
Example:
On the results tab of a saved search I want to pull out a text field from the system notes such as Vendor Name.
Formula Text {vendorname} = Microsoft
In a case statement you can tell the statement to either 1,0 but in this situation I need to return the result of Microsoft and leave any other vendors off the system note or line system note with the same date.
0