When viewing a report, you can click Schedule in the footer of the report to create a schedule to automatically email the report. Schedules can be created for standard and saved reports and can be sent to other users.
Clicking the Schedule button opens the Schedule Report page where you can select recipients, enter a message and/or select attachments to include with the emailed report. You can also schedule the report to run regularly at a predefined interval
Note:
Customers are encouraged to run large reports during off-peak hours. Reports
that run beyond 3 minutes during peak hours are automatically disabled and the
primary email recipient is notified by email that the report has timed-out.
Timed-out reports will not run again until they have been either edited, to make
them run faster, or rescheduled to run during off-peak hours.
You can go to Reports > Scheduled Reports > Report Schedules (Administrator) to
view a list of your scheduled reports. From the Report Schedules page, you can
click Edit to revise or delete a saved schedule. Expand/collapse settings are
maintained for scheduled reports.
Reports that have been scheduled in your production account are not run in your
Release Preview account, to avoid confusion. If you want to run a report on a
schedule in your Release Preview account, you need to schedule the report in
that account.
Important
There is a 25MB limitation on emails sent from NetSuite. If the report you are
sending over email contains any non-ASCII characters in the results data, the
limit can be reduced due to applied encoding. To overcome the size limitation,
you should narrow down your results or you can send a link to the report content.
To schedule a report:
-
Go to Reports > Reports Overview and click the name of the report you want to schedule to run the report.
-
In the footer of the report, click the Schedule button
-
On the Schedule Report page, enter a name for the schedule.
This name will help you identify this schedule on the Report Schedules list.
-
Enter the date for the report to run. If the report is to be run more than one time, then this date will be the date that the schedule becomes active.
-
Enter the start time for the report. If the time you select is during peak hours, this will be indicated to the right of the time field. See the preceding note about scheduling reports during off-peak hours.
Note:
The date and time are set according to your timezone, as set in
Home > Set Preferences > General, at the time of creating the schedule.
Changing your timezone will not affect the timing of existing scheduled
reports. -
Check the Run Report More Than Once box if you would like the report to run multiple times. If you select this box the page will expand to reveal further scheduling options as follows:
-
Daily Event – Specify the frequency: Repeat every X days (also counting weekend days) or Repeat every weekday (Monday-Friday).
-
Weekly Event – Specify the frequency: Repeat every X weeks and choose which days of the week it should run.
-
Monthly Event – Select day X of every X months or specify the (1st, 2nd, … last) (Sunday, Monday, … Saturday) of every X Months.
-
Yearly Event – Select the date or specify the (1st, 2nd, ... last) (Monday, Tuesday, ... Saturday) of (Jan, Feb ... Dec).
-
Start At and End By – Enter the date range you want to schedule the report for.
If you are scheduling a single event, the report will be emailed on the date entered in the Start At field.
If you are scheduling a repeat event, the report will be emailed according to the schedule you set starting on the date entered in the Start At field and ending on the date entered in the End By field.
-
No End Date - Check this box if you want the schedule to repeat indefinitely.
This field is checked by default. Entering a date in the End By field automatically clears this box.
-
-
On the Recipients subtab:
-
The Recipient field is pre-filled with your email address. You can change the primary recipient by selecting from the Recipient dropdown list.
Note that if email notifications for the report schedule fail, timed-out reports and other notifications are sent to the primary recipient. The recipients in the Cc and Bcc lists do not receive these failure notification emails.
-
In the Copy Others dropdown list, select an additional recipient and choose whether to include in the Cc or Bcc list, and click Add.
-
Repeat step b for each additional recipient to be copied.
Note that a primary and copied to recipient(s) can be either an individual user or a group. Dropdown lists include each group that has a group email address.
-
-
On the Message subtab:
-
Enter custom subject and body text for email messages.
-
Choose the Sending Format from the list.
-
-
On the Attachments subtab:
-
In the Attach File field, select a file from your computer or file cabinet to attach to the email, and click Add.
-
Repeat to attach additional files.
-
Check the Zip attachments box if you want to attach a zip file of all selected attachments.
-
-
Click Save.