Create a child record for the standard record which is the purchase order. Make all the fields to be show in list. Custom Field Display should be normal. Here is the child record and the purchase order connects with the corresponding purchase order. Suitelet Code: /** * @NApiVersion 2.1 * @NScriptType Suitelet */ /************************************************** *… Continue reading Enhancing Purchase Orders: Storing Child Records for Sublist Display using Suitelet
Tag: excel connection to Netsuite
Excel connector using suitelet
Requirement Set up a test account to establish a dynamic connectivity to the excel using a suitelet script. Excel should pick up data from a saved search. Solution Use a suitelet script External url with the saved search Id and a secret key to use in excel sheet.
Excel Setup for Dynamic connection
Requirement – Need to Connect a report in NS to excel dynamically Solution – Create a saved search the same as the report in NS. Create a suitelet link to load the search to excel. Connect the saved search with excel using the suitelet external URL. The excel setup is as follows On Windows PC … Continue reading Excel Setup for Dynamic connection