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.
Tag: excel connection to Netsuite
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