ERP Reporting 2 — Questions and Answers
Question 1: Which ERP reporting feature allows users to schedule reports to run automatically at defined intervals?
- Ad hoc reporting
- Batch scheduling (Correct answer)
- Drill-down analysis
- Real-time dashboards
Correct answer: Batch scheduling
Batch scheduling automates report generation at predefined times, reducing manual effort and ensuring timely delivery.
Question 2: In ERP reporting, what does 'drill-down' functionality allow a manager to do?
- Export data to CSV format
- Navigate from summary data to underlying detail records (Correct answer)
- Schedule recurring reports
- Apply data encryption to reports
Correct answer: Navigate from summary data to underlying detail records
Drill-down lets users click on summarized figures to reveal the granular transactions or records that comprise them.
Question 3: A company wants to compare actual costs versus budgeted costs in its ERP system. Which report type is most appropriate?
- Aging report
- Variance report (Correct answer)
- Trial balance report
- Inventory turnover report
Correct answer: Variance report
A variance report highlights differences between planned (budget) and actual figures, enabling management to identify overspending or savings.
Question 4: What is a key advantage of using real-time reporting in an ERP system compared to batch reporting?
- Lower system resource consumption
- Immediate visibility into current operational data (Correct answer)
- Simpler report configuration
- Reduced need for user access controls
Correct answer: Immediate visibility into current operational data
Real-time reporting reflects the current state of the database, allowing managers to make decisions based on up-to-the-minute data.
Question 5: Which of the following best describes a KPI dashboard in an ERP context?
- A static PDF report sent via email
- A visual interface displaying key performance indicators updated dynamically (Correct answer)
- A module for entering journal entries
- A tool for scheduling employee shifts
Correct answer: A visual interface displaying key performance indicators updated dynamically
A KPI dashboard aggregates critical metrics into a visual interface, giving managers an at-a-glance view of organizational performance.
Question 6: When configuring ERP report access, the principle of least privilege means:
- All users receive the same report access by default
- Users are granted only the report access necessary for their role (Correct answer)
- Managers can view all reports across all departments
- Reports are restricted to C-suite executives only
Correct answer: Users are granted only the report access necessary for their role
Least privilege limits user access to only the data and reports required for their specific job function, reducing security and compliance risks.
Question 7: An ERP system's accounts receivable aging report categorizes outstanding invoices by:
- Customer industry type
- Number of days past due (Correct answer)
- Invoice currency
- Sales representative
Correct answer: Number of days past due
Aging reports bucket unpaid invoices into time brackets (e.g., 0-30, 31-60, 61-90 days) to help managers prioritize collections.
ERP Reporting 2
Which ERP reporting feature allows users to schedule reports to run automatically at defined intervals?