Putting your NetSuite searches on a schedule is a smart way to automatically keep your Excel data in sync with NetSuite. For records that don't change often (such as subsidiary lists, and G/L accounts) consider adding them to a monthly schedule (or manual refresh). For records that change often such as transactions consider adding them to a schedule that matches your reporting needs. For example, if you have a sales dashboard add your sales order search to an hourly schedule.
Prerequisite
Search scheduling is available to trial and Enterprise customers.
Scheduling your saved searches requires that your Excel file be saved on OneDrive for Business or on SharePoint before you create the schedule.
Watch the video below or follow the written instructions.
Adding a Scheduling to Saved Searches
Step 1: Before continuing be sure your workbook is saved on OneDrive for Business or SharePoint.
The GIF below shows saving a workbook to OneDrive.
Step 2: Click on the Schedule tab in the CloudExtend task pane to see a list of all schedules you have created. To create a new schedule.
Click New.
Enter the schedule interval and frequency. (Hourly, Daily, Weekly, Monthly, Yearly)
Then click Add.
Step 3: Adding searches to a schedule frame.
Click the Schedule tab in the CloudExtend task pane.
Click Assign Reports and drag and drop the reports from the schedule and unschedule frames to the desired schedule.
Removing Saved Search Schedule
There are two ways to remove a scheduled saved search.
Delete a Schedule
This will remove all the saved searches inside the schedule frame.
Step 1: Go to the Schedule tab.
Step 2: Click the trash icon next to the schedule to delete the schedule. Any reports in the schedule will be moved to the unscheduled frame.
Remove a schedule for a Saved Search
Step 1: Go to the Schedule tab.
Step 2: Click Assign Reports the saved search to unschedule frame.
