Use the Shipping Item List as a Select Option in a Suitelet

Following is the tutorial taken from SuiteAnswers which shows how to create a select field having Shipping Items/Shipping Methods in Suitelet: Use the Shipping Item List as a Select Option in a Suitelet Create a custom record type Navigate to Customization > Lists, Records, & Fields > Record Types > New Set the name – Shipping List Set the ID – _rec_ship_list Access type = no Permission Required Save Add a custom field that will source the Shipping Item List Edit the Record created from Part A. Click on new field Set the name – shipping item list Set the...

Read More


Create Excel Sheet through Suitelet

Use the following sample code to create an XLS file in NetSuite’s Suitelet.   // XML content of the file var xmlStr = '<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?>'; xmlStr += '<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" '; xmlStr += 'xmlns:o="urn:schemas-microsoft-com:office:office" '; xmlStr += 'xmlns:x="urn:schemas-microsoft-com:office:excel" '; xmlStr += 'xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" '; xmlStr += 'xmlns:html="http://www.w3.org/TR/REC-html40">'; xmlStr += '<Worksheet ss:Name="Sheet1">'; xmlStr += '<Table>' + '<Row>' + '<Cell><Data ss:Type="String"> Folio3 Pvt. Ltd </Data></Cell>' + '<Cell><Data ss:Type="String"> Products </Data></Cell>' + '</Row>'; xmlStr += '<Row>' + '<Cell><Data ss:Type="String">1</Data></Cell>' + '<Cell><Data ss:Type="String">NetSuite EBay Connector</Data></Cell>' + '</Row>'; xmlStr += '<Row>' + '<Cell><Data ss:Type="String">2</Data></Cell>' + '<Cell><Data ss:Type="String">NetSuite Magento Connector</Data></Cell>' + '</Row>'; xmlStr += '<Row>' + '<Cell><Data ss:Type="String">3</Data></Cell>'...

Read More


Amount Field in Search Column

While making a search on sales order record for one client, I came across a scenario where I had to display amount field in a search column. I have added this field but it shows the different amount than sales order amount. I diagnosed this behavior and found that the client had the Multiple Currency Feature in his NetSuite account and its default/base currency was USD and order was created in CAD currency. After some searching I found that a field named Amount (Foreign Currency) which shows the amount in the currency in which the order was created. So the...

Read More


Available Quantity of Kit/Package Items

Some time customer would like to display the total available quantity of Kit/Package items through saved search. A simple search shows empty available quantity for Kit/Package item because member items are associated with Kit item and the quantity of Kit item depends on the quantity of its components. The solution is here: 1. Go to Lists > Search > Saved Searches > New > Item 2. On Criteria > Standard > Filter > i. Type = Kit/Package ii. Inactive = false. 3. On Results > Columns > Fields: Name i. Name – Set Summary Type = Group ii. Formula (Numeric) –...

Read More


Prevent Usage Limit Exceeded Exception In Client Script

Most of the time a situation comes in NetSuite where we need to upsert or delete hundreds or thousands of records either these are custom records or standard records. In this situation, we can upsert or delete all those records: 1) By writing scheduled script. 2) By Deleting Records From UI Using Inline Editing Feature. 3) By writing a client script. Most of the developers know about the above two methods. Some times we need to do the heavy job on client side which consumes API governance then we can use the third method. But there is one question arrives...

Read More


How to Customize the NetSuite Search API to Search For 1000+ Records in NetSuite

Hi, In this post I’ll show you how to customize the Search API in NetSuite to search for more than 1000 records. As you know, NetSuite provides an in-built search method for retrieving supported records by using the nlapiSearchRecord API. The only limitation of this API is that can only search through 1000 rows at a time. This can be a problem when you want to search for more than 1000 records, for instance, for performing some calculation. You can work around this limitation by tweaking the script  of (customizing) the Search API, thereby enabling it to search for more than a thousand records. Let’s...

Read More



Page 9 of 9« First...56789

ContactUs.com