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!
NetSuite Admin Tip | Bulk Update of Vendor Bill Memo and Department Using SuiteScript
Administrators often need to perform bulk updates on Vendor Bill records, such as updating the Memo and/or Department fields for multiple transactions. Loading and saving each record individually can be slow and consume unnecessary governance.
A more efficient approach is to update only the required standard body fields using record.submitFields.promise() within a Scheduled Script.
This method allows you to:
- Update standard body fields only
- Avoid using record.load() and record.save()
- Improve script performance and governance usage
- Safely process records in bulk
Example: Bulk Update Vendor Bill Memo and Department
- Searches Vendor Bills using mainline = T
- Updates the Memo and Department fields
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Advanced Accounting. RSVP on this event now!
Tagged:
0