Month: January 2022

Setup initial Fieldset using script

We can setup the initial field set using script. Steps: 1.Copy the below script and change the site id of the particular website. var siteID = 99999 // change to the site id you want to use, has_product_reviews = true, has_store_pickup = false , siteRecord = nlapiLoadRecord(‘website’, siteID); siteRecord.selectNewLineItem(‘fieldset’);siteRecord.setCurrentLineItemValue(‘fieldset’, ‘fieldsetname’, ‘Search’);siteRecord.setCurrentLineItemValue(‘fieldset’, ‘fieldsetid’, ‘search’);siteRecord.setCurrentLineItemValue(‘fieldset’, ‘fieldsetrecordtype’, ‘ITEM’);var… Continue reading Setup initial Fieldset using script

Steps to Consider before Subsidiary Hierarchy Structure Modification

When making changes to your Subsidiary Structure it is important to take note that this will have financial reporting impacts on the account. It is highly recommended to do the following: Export Financial Statements and Consolidated Exchange Rates before making modifications. This is important especially if you have modified Subsidiaries using different currencies as the… Continue reading Steps to Consider before Subsidiary Hierarchy Structure Modification

Availing Online Support from the NetSuite Team for any queries or clarification of doubts

I came across to install a suite bundler for a dashboard, which I couldn’t do so since the Suite Bundle was not installed in the Client Account. So to get such a customization we can avail the service from the Support Team online which is inside the account of NetSuite. I’m here by attaching the… Continue reading Availing Online Support from the NetSuite Team for any queries or clarification of doubts

Best Practices In Advanced PDF Template

To Handle the Header and Body content Overlapping issue To Handle the Header and Body content Overlapping issue to include all header content in the Body table as header data. Refer the following sample To Handle Unwanted space when data in the column is increased If the row contains multiples columns as follow There is… Continue reading Best Practices In Advanced PDF Template

Install DocuSign for NetSuite

Log on to your NetSuite account as an administrator. Select Customization, > SuiteBundler>Search & Install Bundles. Click NEW to search for the bundle To find the DocuSign for NetSuite Bundle, search for DocuSign for NetSuite or Bundle ID 351444 Click DocuSign for NetSuite and Click Install In the Preview Bundle Install dialog, click Install Bundle

Delete Multiple Records By Calling Array Elements

//Info: JOIN-185 Requirement: Create a MapReduce script to delete the Sales order Records.In these cases, Normally we set a saved search criteria to met the requirement & retrieve the data’s from the search script and then proceed with the Deletion mapping. In case of sales order, we have multiple set of records linked to a… Continue reading Delete Multiple Records By Calling Array Elements

Excel Functions to remove characters from Left and Right ends

Remove characters from left of a text=RIGHT(A2,LEN(A2)-3)=RIGHT(D2,5)Ex: If text is POS12345 result will be 12345 Another methode will be – =REPLACE(A2,1,N,””)Here N will be the number of characters to remove. Remove Charcters from right of a text=LEFT(A2,LEN(A2)-5)=LEFT(A2,3)Ex : If text is POS12345 result will be POS

Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import

Go to Analytics > Workbooks tab. Click New Workbook. Click New Dataset. If you already have a dataset, you can click the Dataset Name instead of creating a new dataset. Select a record type to analyze. The search bar is helpful for locating a record type. To search, enter any word or character from the record type name. No… Continue reading Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import