This article is relevant if you are using SuiteScript 2.0 to load a NetSuite System Note
Background
Sometimes, you simply want to load a system note and read the contents. But how do you do that?
SuiteScript 2.0 to Load NetSuite System Note
The trick to load a system note is to create a search that returns a single result. Assuming you know how to refine criteria to focus in on the record you are interested in, here is the key syntax to help get you going.
//get one system note record
var ss = search.create({
type: search.Type.SYSTEM_NOTE,
columns: ['date', 'recordtype', 'record', 'field', 'oldvalue', 'newvalue'],
filters: [['role', 'is', '3']] //administrator
}).run().getRange(0,1);
Since a system note is read-only, then this approach gets the job done.
Work with Expert NetSuite Help
A thank you to our senior consultant, Boban, who offered this up to our team. You can find this in the SuiteScripts Records Guide. If you enjoy the NetSuite Platform and want to be appreciated for the unique way you think and innovate, let’s have a conversation.
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
