ERP Reporting 5 — Questions and Answers
Question 1: What is the purpose of a rolling forecast report in ERP management?
- Report actual results for the prior fiscal year
- Continuously update the forward-looking financial plan by replacing the oldest period with a new future period (Correct answer)
- Track employee vacation balances
- Summarize fixed asset additions
Correct answer: Continuously update the forward-looking financial plan by replacing the oldest period with a new future period
A rolling forecast replaces static annual budgets by updating projections on a continuous basis, improving planning accuracy as conditions change.
Question 2: Which ERP reporting configuration setting controls whether negative inventory quantities trigger an alert on operational reports?
- Report bursting frequency
- Threshold or exception alerting rules (Correct answer)
- Data masking settings
- Report scheduling time zone
Correct answer: Threshold or exception alerting rules
Exception alerting rules define thresholds that, when breached (like negative stock), automatically flag or notify relevant users on operational reports.
Question 3: A manufacturing plant manager reviews an OEE (Overall Equipment Effectiveness) report in the ERP. OEE measures:
- Employee overtime eligibility
- Combined availability, performance, and quality of equipment (Correct answer)
- Order fulfillment lead time
- Supplier invoice accuracy
Correct answer: Combined availability, performance, and quality of equipment
OEE multiplies availability, performance rate, and quality rate to give a single percentage representing how effectively manufacturing equipment is utilized.
Question 4: What is a common risk when ERP reports are exported to spreadsheets and edited manually before distribution?
- Reports become larger in file size
- Data integrity is compromised because the ERP audit trail no longer applies (Correct answer)
- The ERP system loses connection to the database
- Report formatting is automatically reset
Correct answer: Data integrity is compromised because the ERP audit trail no longer applies
Manual edits to exported data break the chain of custody from the ERP source, creating opportunities for errors or manipulation outside the system's controls.
Question 5: In ERP systems, 'report personalization' typically allows individual users to:
- Change another user's access permissions
- Save custom column layouts, filters, and sort orders for their own view (Correct answer)
- Modify the underlying database schema
- Override system-wide reporting defaults for all users
Correct answer: Save custom column layouts, filters, and sort orders for their own view
Report personalization saves a user's preferred display settings so they don't need to reconfigure them each session, without affecting other users' views.
Question 6: Which ERP report helps management understand the full cost of a product including materials, labor, and overhead?
- Vendor aging report
- Cost of goods manufactured (COGM) report (Correct answer)
- Trial balance report
- Fixed asset register
Correct answer: Cost of goods manufactured (COGM) report
The COGM report accumulates all production costs—direct materials, direct labor, and manufacturing overhead—to determine the total cost of finished goods.
Question 7: A compliance officer needs to verify that financial reports were reviewed and approved before distribution. Which ERP feature supports this?
- Report color coding
- Workflow-based report approval and digital sign-off (Correct answer)
- Auto-scheduling of reports
- Data archival settings
Correct answer: Workflow-based report approval and digital sign-off
Workflow-enabled report approval routes reports through defined reviewers, capturing electronic signatures and timestamps to satisfy audit and compliance requirements.
ERP Reporting 5
What is the purpose of a rolling forecast report in ERP management?