What we do
Tools
Industries
Department
How we workLet's talk →
Home/Sage Reporting
Sage

Sage Reporting on a Schedule: How Far Sage Intelligence Goes on Its Own

It's the second working day of the month and the management pack is due. Someone opens Excel, refreshes the Sage Intelligence report, checks it and emails it round. Sage Intelligence can run that report for you through Report Manager and Windows Task Scheduler. The catch is what it runs on: one computer that has to be switched on, under an account with rights to every report.

Intelligence Reporting and Report Designer are different jobs

Sage Intelligence Reporting is the Excel-based report writer built into most Sage accounting and ERP products. It connects to your live Sage data and lets you build financial and management reports, like budget comparisons or departmental breakdowns, with the formulas and layouts finance teams already know.

Report Designer handles the layout of documents Sage prints or emails: invoices, statements, purchase orders. If you want to change how an invoice looks to a customer, that's Report Designer, not Intelligence Reporting.

On Sage Intacct? It has its own report writer with scheduled reports built in, so the steps below don't apply to you.

Scheduling a Sage Intelligence report with Report Manager

These are Sage's own steps. Names can differ slightly by version.

  1. 1

    Choose where the finished file goes

    Report Manager Show Advanced Generate Output File

    Select the report, tick Show Advanced in the Properties window, then use Generate Output File to pick the folder the output is saved to.

  2. 2

    Generate the scheduler command

    Right-click the report Generate Scheduler Command

    Fill in any parameters the report needs. The command is copied to your clipboard.

  3. 3

    Create the Windows task

    Task Scheduler Create Task

    Name it, add a schedule on the Triggers tab, paste the command into Program/script on the Actions tab, set the Settings options and save. It shows up as an active task.

    Watch for: the computer has to be on at the scheduled time, and the account running the task needs rights to the reports and everything they read.

  4. 4

    Add email delivery if people want it in their inbox

    Report Manager can attach an email distribution instruction to a report. By default it sends through the Outlook profile on that machine, and Exchange or SMTP can be used instead.

Why the scheduled Sage report didn't show up this month

The PC was off, asleep or restarting for updates

How you'll know: There's no new file in the folder, and Task Scheduler shows the task didn't run or failed.

Fix: Run it from a machine that stays on, or take the extract off the desktop altogether.

The account lost a permission

How you'll know: It ran fine last month. Since then a password changed, or the person whose login it used left.

Fix: Run the task under an account that isn't tied to one person, with rights to every report's data.

Outlook wasn't there to send it

How you'll know: The file was created, but nobody got an email.

Fix: Point distribution at Exchange or SMTP instead of a desktop Outlook profile.

The report is right but answers half the question

How you'll know: Leadership wants margin by job or by rep, and the CRM or field system holds the other half.

Fix: A Sage-only report can't get there. It needs Sage data and the other system's data in one place.

When a Sage report outgrows one desktop

01

Sage data pulled on a server, on a timer

n-frames copies the tables your reports use into a database on a schedule, so no desktop has to be awake and no single login holds the month-end together.

02

One dashboard with Sage and the rest of the business

Sage numbers next to the CRM pipeline, job costs from the field system or stock from the warehouse tool, in a live browser dashboard instead of an Excel attachment.

03

Separate Sage companies or installs, in one view

Where Sage Intelligence can't reach across separate Sage installs or different Sage products, we bring both into one model, with the mapping between their charts of accounts written down.

Let's talk

Is the month-end pack still waiting on someone's laptop?

n-frames builds Sage reporting that refreshes on a server, puts Sage next to the other systems your managers ask about, and lands where people already look. If a properly set up scheduled task in Sage Intelligence covers it, that's what we'll set up.

Move the pack off that laptop →

Questions people ask

Is Sage Intelligence Reporting free?

It comes with many Sage products rather than as a separate line item, but what's bundled varies by product and edition. Check your own license for what's included.

What's the difference between Sage Intelligence Reporting and Report Designer?

Intelligence Reporting is for financial and management analysis, built in Excel on live data. Report Designer is for the layout of documents Sage prints or emails, like invoices and statements.

Can Sage Intelligence Reporting pull data from more than one Sage company?

It can consolidate companies within the same Sage database setup. Pulling across genuinely separate Sage installs or different Sage products usually needs more configuration or a custom data connection.

How do I build a custom report in Sage Report Designer?

Report Designer gives you a layout canvas. You place fields, labels and data from your Sage records onto a document template, save it, and apply it to the document type it's for, such as invoices or statements.

Does Sage have a business intelligence tool beyond basic reporting?

Sage Intelligence Reporting covers most management reporting for small and mid-sized Sage users. For BI across several data sources, businesses usually feed Sage data into a dedicated BI tool or a custom dashboard rather than lean on Sage's own reporting alone.

Can Sage Intelligence Reporting run reports on a schedule?

Yes, through Report Manager's Generate Scheduler Command and a Windows Task Scheduler task. It depends on that computer being on at the scheduled time and on an account with rights to the reports. n-frames moves the job to a server when that dependence keeps breaking.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.