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.
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.
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.
These are Sage's own steps. Names can differ slightly by version.
Select the report, tick Show Advanced in the Properties window, then use Generate Output File to pick the folder the output is saved to.
Fill in any parameters the report needs. The command is copied to your clipboard.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 →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.
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.
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.
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.
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.
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.