Written by: Ely Beltran
Background
NetSuite offers various methods to move a saved search between sandbox and production environments. Here are the methods:
SuiteBundle (still working but deprecated as per NetSuite)
Copy to Account
For Developer, using Suitecloud Development Framework
The most convenient method for users is to use the 'Copy to Account' feature, available when viewing a NetSuite Saved Search. However, this feature does not always work perfectly, especially with saved searches involving multiple criteria, columns, and table joins. This tutorial will help you move a saved search to a different environment by using some plug-ins and a Chrome browser.
Prerequisites
Chrome browser
Download the following extension for Chrome: NetSuite Saved Search Code Export
Install the extension
NetSuite Saved Search Import using Chrome Debugger
In the following use case, we have a NetSuite search in Production and we will move this search to Sandbox.
Go to the saved search and go to ‘Edit’ mode.
In the Edit mode of a saved search, a link called ‘Export as Script’ is now available.
3. Click the ‘Export as Script’ link and this will open a new window, and copy the contents.
4. Copy and paste the text content into a notepad. The codes you need to add are highlighted in green:
require(['N/search'], function(search) {
var transactionSearchObj = search.create({
type: "transaction",
filters:
[
["type","anyof","VendBill","Check","VendPymt"],
"AND",
["status","noneof","VendBill:A","VendBill:C","VendBill:D","VendBill:E","Check:V","Check:Z","VendPymt:V"],
"AND",
["vendor.custentity_1099_reporting","is","T"]
],
columns:
[
search.createColumn({name: "subsidiarynohierarchy", label: "Subsidiary (no hierarchy)"}),
search.createColumn({
name: "entityid",
join: "vendor",
sort: search.Sort.ASC,
label: "Vendor NS ID"
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug("transactionSearchObj result count",searchResultCount);
transactionSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
transactionSearchObj.title = 'TEST SEARCH MIGRATION';
transactionSearchObj.save();
});
5. Now, switch to the NetSuite environment. For example, if the search is from Production, switch to Sandbox.
6. Go to the ‘Edit’ mode of any transaction record and, press F12 to open the Chrome debugger tool, make sure to go to the ‘Console’ tab.
7. Paste the code from step #4 and hit enter. This will recreate the Netsuite saved search in the current environment. In this example, the search name is ‘TEST SEARCH MIGRATION’.‘
Etter+Ramli as the Trusted, Independent Managed Services Provider for NetSuite
Using NetSuite Managed Services could be your growing company's best strategic move. NetSuite Managed Services offers a comprehensive solution, granting companies access to a team of experienced NetSuite administrators and consultants to manage their NetSuite ERP. Typically, this service is more affordable than hiring in-house staff. When you use managed services, your systems are always up-to-date. In the world of IT, systems are consistently upgraded and patched and come with a slew of security protocols. It is a lot to handle, but your teams can handle this when implementing managed services.
The goal is to ensure your NetSuite instance supports your business’ growth.
For over 20 years, Etter+Ramli has helped several companies optimize their NetSuite software solution. With a 95% customer satisfaction rate, Etter+Ramli can provide your company with world-class support, Certified NetSuite experts, and a value-based pricing structure.
Etter+Ramli As Your Extended NetSuite Team
Etter+Ramli is an Independent Managed Success Provider for NetSuite clients. We are NOT partnered with Oracle NetSuite and do not take commissions. We bring our knowledge, expertise, and passion for success to our clients. We help clients Buy, Deploy, Grow, and Abandon NetSuite. We engage as a client-side managed service to ensure our priorities align with our clients.
To explore the benefits of retaining Etter+Ramli as your Managed Success Provider, contact Todd Kimpton or visit our website for a free consultation today.
Comments