ERP Report Rationalization Decision Log Template
Years of custom reports pile up, and nobody dares delete any. This decision log turns a clean-up or upgrade into documented choices: keep, merge, retire or rebuild, each with an owner and evidence.
Fill in
ERP Report Rationalization Decision Log Template
Report Decision Record
Report: Open PO Past Due by Buyer ID: CUST_RPT_0142 System: Infor SyteLine custom report Business owner: Purchasing manager
Usage evidence
Last run: 2026-09-30 Runs in last 12 months: 148
Decision
Merge into another report
Reason: Same data as the weekly supplier delivery report with one extra filter. Merge as a parameter.
Follow-up
Add buyer parameter to supplier delivery report by 2026-11-30, then disable this report.
Rollback: Keep the report definition archived in source control for 12 months.
Dependencies checked
| Check | Result | Notes |
|---|---|---|
| Scheduled jobs or emails | ||
| Excel files linked to this report | ||
| Audit or regulatory use | ||
| Used by another report or dashboard |
Approvals
Starting point only. Add your change-control number. Check audit, tax and customer-reporting duties before retiring any report.
Get help sorting a large report estate
Optional expert review of your report inventory with suggested merge and retire candidates for your team to approve.
Optional. The tool and every export work without this. No spam.
How to use it
Start from a report inventory with run counts and last run dates from your ERP logs or scheduler. For each candidate, fill one record. Enter usage evidence, choose a decision, state the reason and list the follow-up. Complete the dependency table before retiring anything, since hidden consumers such as scheduled emails, linked Excel files and audit packs are the usual cause of surprise complaints. Collect owner approval and archive the signed record.
Choosing between the decisions
Keep reports used regularly and tied to a current process. Merge reports that differ only in a filter or sort. Retire reports with no runs in a year and no regulatory purpose, after a notice period. Rebuild reports that are valuable but fragile, for example hard-coded to old tables. Replace with standard when the vendor now ships equivalent output.
- No runs in 12 months: retire after notice
- Same data, different filter: merge
- Fragile but used: rebuild
- Vendor standard now covers it: replace
Common mistakes and ERP notes
Do not judge value from run counts alone; a quarterly or year-end report may run only a few times and still be essential for audits. Archive the definition before disabling, not after. During an upgrade or migration, such as moving to a new SyteLine or S/4HANA release, test the reports you keep against the new data model and record the result in this log.
Frequently Asked Questions
How do I find unused reports?
Use ERP audit logs, report server statistics or scheduler history to get run counts and last run dates. Where no log exists, move the report to an archive folder for a notice period and see who asks.
How long should the notice period be?
Long enough to cover one full business cycle, typically a quarter, and a year-end if the report might support closing or audit. Announce retirements to owners in writing.
Who should approve a retirement?
The business owner approves the need, and the ERP administrator approves the technical action. Add finance when the report supports tax, audit or statutory filings.
Should I delete or archive retired reports?
Archive. Keep the definition and a sample output in source control or a document store for at least a year, so a late request can be served quickly.
If you are facing hundreds of legacy reports, Netray can help analyze them and propose consolidation or rebuild options, with your team approving each decision.
Related Tools
Management Report Request Form Template
A one-page request form that tells the report developer exactly what a manager needs, including filters, frequency and acceptance test.
Costing & FinanceKPI Owner and RACI Assignment Worksheet
Editable worksheet that gives every KPI one accountable owner, a data source, a refresh cadence and a review meeting.
Discrete ManufacturingMonthly Operations Review Report Template
Fill-in monthly operations review covering delivery, quality, inventory and cost, with actions and decisions required.
Discrete ManufacturingKPI Target Setting Worksheet
Compare baseline, best recent result and target for each KPI, with gap and improvement percent computed per row.