Category Archives: NetSuite

Advanced options in Netsuite csv import

Category : NetSuite

If you did not visited previous blog on csv import please visit here.

Overwrite Sublist

Your setting for the Overwrite Sublists option affects imports of sublist data when one of the following data handling option buttons is selected: Update, Add or Update. By default, the option is disabled.

  • Overwrite Sublists = True — If you enable the Overwrite Sublists option, the Import Assistant completely replaces all existing sublist values and replaces them with the
Read the rest

NetSuite CSV Import

Basics

CSV import is the most commonly used method for transferring small to medium-sized data sets from other applications into NetSuite. The CSV import process saves time and prevents errors, by submitting data in a CSV (comma-separated value) file. This data can add or update many records at one time, avoiding the need for manual data entry.

Important Things to take care while preparing csv file for data import

  1. Always take the export file of
Read the rest

Formula In NetSuite Saved Search

Category : NetSuite

As a NetSuite solution provider this time we are showing how to add a formula  in the saved search and groupby result as per the requirement

In daily interaction with our customer most of the NetSuite solution provider will definitely face situations where client if curious about presentation of data.

A saved search is a reusable search definition, that can have many advanced search filters and results display options. If you have the Publish Search … Read the rest


NetSuite supporting business throughout the course of this pandemic

While everyone across the world continues to navigate the uncertainty of COVID-19, Oracle NetSuite is committed to supporting your business throughout the course of this pandemic and to provide continuity of service at all times. In the time of pandemic there are certain technologies which are helping people and organizations running their business seamlessly without any barrier and restrictions.

In this difficult time we realize that the potential of best technology. In this blog I … Read the rest


NetSuite SuiteCloud Platform Enhancements

In this tutorial of NetSuite by your NetSuite Solution provider we are briefing about the SuiteCloud Platform enhancements by netsuite For developers working with the SuiteCloud development platform, things are about to get easier, faster and more collaborative.

For NetSuite customization netsuite has recently made some key enhancements to the platform including the release of new SuiteCloud processors which should be welcome news for customers and partners in this netsuite training i am discussing. Traditionally, … Read the rest


Client Script to Display a Saved Search’s result in a popup using inline html.

Problem Statement

In this netsuite training we are discussing about use case as a netsuite solution provider , Suppose our customer has some custom record and they want to populate the saved search’s result in a popup dialog alert for a quick reference, as there business has lots of customization depending on their business use case. Additionally, an inline-HTML-created table will be used in containing the search results for better display.

 Approach

In Below … Read the rest


In User Event Script passing a variable as a function parameter to a referenced Client Script.

Problem Statement

In this tutorial of netsuite training from your netsuite solution provider we are showing two scripts interaction with each other. There was a Customer working in the sales order customization, wants to pass a value from their User Event script to a referenced Client Script so that it can be used for further processing within the Client Script. The Client Script will be triggered by a button that was created by the User … Read the rest


Join using SuiteScript 2.0 and ‘N/search’ Module

N/search

Load the search module to create and run on-demand or saved searches and analyse and iterate through the search results. You can use this module to do the following:

  • Search for a single record using keywords
  • Create and save searches
  • Load and run previously saved searches
  • Search for duplicate records
  • Return a set of records that match filter criteria you define

Use Case

Suppose we have a situation where User wants to load and … Read the rest


NetSuite saved search for Sales Order without Invoice/Cash Sale

In this blog of netsuite training from the netsuite solution provider thesmilingcoders, we are showing you
How to create saved search for all the sales order without invoice/Cash sales. Below is the following steps for this netsuite training.

step 1) Saved search -> New -> Transaction

Step 2) Criteria -Standard -Filter: Type is Sales Order ; Main line is False

Step 3) Criteria -Summary -Summary type (Count) ; Field(Billing … Read the rest


SuiteScript 2.0 working with subrecords

In this netsuite training we as a netsuite solution provider come with Subrecords. Subrecords represent a way of storing data in NetSuite. Like records, subrecords are classified by type. Some common types of subrecord include address, inventory detail, and order schedule.

Each subrecord type has a different purpose and includes different fields. For example:

  • An address subrecord stores an address. It has fields such as city, state, and zip.
  • An order schedule subrecord represents
Read the rest