NS Administration – Page 68

Common SQL Expressions For Saved Search

Character Functions Function Syntax Description CONCAT CONCAT(char1, char2) returns char1 concatenated with char2 LOWER LOWER(char) returns char, with all letters lowercase UPPER UPPER returns char, with all letters uppercase LTRIM LTRIM(char [, set ]) removes from the left end of char all of the characters contained inset RTRIM RTRIM(char [, set ]) removes from the… Continue reading Common SQL Expressions For Saved Search

Importing Special Language Characters Into Netsuite Through CSV

The first thing you’ll need to do for this type of import is to install Notepad ++. Many people have heard of Notepad, as it is the standard text editor on many PC computers. Unfortunately, Notepad doesn’t support these different languages. Let’s get into the steps: Open the .xls or .xlsx file containing the special… Continue reading Importing Special Language Characters Into Netsuite Through CSV

Invoice Group Feature

KEY-NOTES New NS 2020.2 feature Lets you group invoices for your customers Combining multiple invoices into one invoice group based on the customer. Invoice groups do not post to the general ledger After an invoice group is created, you can add or remove invoices from the group. We can create an invoice group with a… Continue reading Invoice Group Feature

Netsuite OneWorld: Cross Subsidiary Bank Transfer

Cross Subsidiary Bank Transfer

Item import with custom image fields

For doing item import with the custom image field values of the item record we need the filename of the image added in the custom image field of the item record The image URL and internal id were only available from Netsuite saved search so in order to get the filename Follow the steps below… Continue reading Item import with custom image fields

Site Category Import

The site category import lets you add or update website categories in NetSuite. These categories are used to organize information and items for sale on your website. Each category must be associated with a presentation tab to be displayed in a website. Presentation tabs are the building blocks, or pages, in a website. Supported fields… Continue reading Site Category Import

Ship Complete Flag

Ship Complete flag is a standard preference in Netsuite. In WMS Ship Complete flag will have an impact on WMS Fulfillment Order Line creation process on the following: If Ship Complete flag is checked in the Shipping tab of the Sales Order, the script related to Fulfillment Order Line creation will validate whether or not… Continue reading Ship Complete Flag

Category: NS Administration