There are multiple ways to pull data from NetSuite using CloudExtend from the Welcome screen. By creating filters or using saved searches, it will be quick to download and manage data using CloudExtend.
No existing Templates yet...
If you are new to CloudExtend and want to pull a subset of data from NetSuite, you can use the Search and Download and start creating a template then pull records from NetSuite to Excel.
Step 1: Click the Search and Download button.
Step 2: Type or scroll to select the NetSuite Record or Transaction the template will be associated with. CloudExtend Excel even supports Custom Records. In the example below a template will be created for Vendor Bill.
Step 3: Select the fields you want to add to the Template. You can type in any part of the field name or scroll to locate it. Tick the box beside the name and hit Add fields to add them to the template,
To add more, click the + button on the panel.
Click here to see the steps...
Click here to see the steps...
Using Filters
Now that we have a template, Click Continue then Select Yes, note that loading the template will clear out any data that you have on your current worksheet. Turn on the Apply Filters button then Select using Rules.
Add a rule, give your filter a name then click Save.
π‘ Tip: You can create multiple filters and choose between the filters you want to use.
Toggle the Save As Template button, to save the template, and click the Save and Download button to load the template to your worksheet.
Use Saved Search
Using the template created, click Continue then Select Yes, note that loading the template will clear out any data that you have on your current worksheet. Turn on the Apply Filters button and select Using Saved Search.
Choose the Saved Search you want to use and select the Filter you want to load. Click Download Data to stream down data from Saved Search to your template.
π‘ Tip: You can create multiple filters and choose between the filter you want to use.
Toggle the Save As Template button, to save the template, and click the Save and Download button to load the template to your worksheet.
How to download data using Existing Templates
If you already have an existing template and want to download data from NetSuite to your CloudExtend template, do the following.
Step 1: Start with a Template button should be ON, then click the Search and Download with Template button.
Step 2: Select the template you want to use on the template selection screen and click the Play button.
Click here to see the steps...
Click here to see the steps...
Using Filters
Click Continue then Select Yes, note that loading the template will clear out any data that you have on your current worksheet.
Turn on the apply filters. You can reuse filters previously created or click the + sign to create a brand new Filter.
Click Save and Download to stream data from NetSuite to your template using filters.
Using Saved Search
Turn on the apply filters. You can reuse saved searches previously created or click the + sign to add a new saved search criteria to the list.
Click Save and Download to stream data from NetSuite to your template using filters.
Need Help?
If you are looking to pull your NetSuite saved searches on-demand or on a schedule to use for reporting, please contact cloudextend-sales@celigo.com to discuss our CloudExtend Analytics for NetSuite application.