Author: Jasmine Jacob

Currently, the ability to restrict the custom lists based on role is still an enhancement. As an alternate solution, you may follow the steps below: A. Convert the Custom List into a Custom Record Type: 1. Navigate to Customization > Lists, Records, & Fields > Lists. 2. Click on the Custom List in question 3. Check off Convert to Custom… Continue reading Restrict adding new value to Custom List Field

NetSuite WMS provides a standard pick ticket saved search, which you can customize to display additional standard or custom transaction body fields on pick tickets. Fields that you add to your pick ticket saved search must also be added to the advanced pick ticket templates on which you want the fields to appear. Your pick… Continue reading Add a new field to the Pick Ticket PDF template from Wave

To change the value of a General or Accounting preference using SuiteScript 2.0, you must load each preference page using config.load(options) in N/runtime Module where options.name is COMPANY_PREFERENCES or ACCOUNTING_PREFERENCES. The config.load(options) method returns a record.Record. You can use the Record.setValue(options) method to set the preference. You can use the Record.getValue(options) method to get the… Continue reading Change the value of a General or Accounting preference using SuiteScript

Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model. This data model lets you build visuals, and collections of visuals… Continue reading What is Power BI Desktop?

There are multiple methods to integrate Power BI with NetSuite. NetSuite ODBC Connector: NetSuite provides an ODBC driver that allows you to connect to NetSuite’s database directly from Power BI using the ODBC connection feature. You can configure the ODBC driver and establish a connection to access NetSuite data within Power BI. NetSuite SuiteAnalytics Connect:… Continue reading Integrate Power BI with NetSuite.

First, you’ll want to enable the web query functionality on a given report. You’ll do this as shown below: Goto desired Report>Click on Customize Once the Customize screen loads, navigate to the More Options button as depicted below: After you’ve navigated to the More Options tab, check the box allowing Web Query access: Now that… Continue reading NetSuite Web Query report functionality to connect to Power BI desktop.

When you use search.Create (or load) and write filter for Select/Multiselect fields or internal id,you might see this error. TypeError: elem._marshal is not a function Reason:This happen when you add object in place of single value in filter ex: for list/record enter object not value.

When a case is created via the Online Case Form, it may be associated to an Anonymous Customer, instead of an existing or a new Customer/Contact. Please follow the steps below in order to associate the case to a new customer or an existing one: Navigate to Setup > Support > Online Case Form and edit your Online Case Form. In… Continue reading Online Case Form- Case Created Associated to Anonymous Customer

 To convert a currency code to the currency’s display name for the specific locale you can use Intl.Display Names by setting the type property to currency and got the display names of the currencies based on the provided locale.

Use the Intl.DisplayNames() constructor to get a country name from a country code.The of() method on the returned object takes a code as a parameter and returns a string based on the provided locale. The Intl.DisplayNames() constructor returns an object we can use to: translate a region code to the country’s name. translate a language code to… Continue reading Get Country name from Country code