ERP ERP Reporting, Analytics & Business Intelligence 2 — Questions and Answers
Question 1: What is an ERP exception report used for?
- Listing all transactions in a given period
- Highlighting records that fall outside defined thresholds or business rules requiring attention (Correct answer)
- Generating employee pay stubs
- Displaying the system login audit trail
Correct answer: Highlighting records that fall outside defined thresholds or business rules requiring attention
Exception reports filter out normal records and surface only the anomalies — such as overdue invoices or inventory below reorder point — that require action.
Question 2: In ERP financial reporting, what does variance analysis measure?
- System uptime and availability
- The difference between planned (budget/standard) and actual results to identify performance gaps (Correct answer)
- User adoption rates
- The number of open support tickets
Correct answer: The difference between planned (budget/standard) and actual results to identify performance gaps
Variance analysis compares actual financial results against budgeted or standard costs to identify favorable or unfavorable deviations requiring investigation.
Question 3: Which ERP report type is most useful for monitoring customer payment behavior?
- Trial balance report
- Accounts Receivable aging report (Correct answer)
- BOM explosion report
- Payroll register
Correct answer: Accounts Receivable aging report
An AR aging report categorizes outstanding customer invoices by time buckets (e.g., 0-30, 31-60, 61-90 days) to prioritize collection efforts.
Question 4: What is a balanced scorecard in the context of ERP performance management?
- A reconciliation tool for general ledger accounts
- A strategic framework that monitors performance across financial, customer, internal process, and learning perspectives (Correct answer)
- A type of vendor evaluation scorecard
- A tool for balancing server load across ERP instances
Correct answer: A strategic framework that monitors performance across financial, customer, internal process, and learning perspectives
A balanced scorecard translates an organization's strategy into a set of KPIs across four perspectives: financial, customer, internal processes, and learning and growth.
Question 5: In ERP systems, what does ad hoc reporting allow users to do?
- Schedule reports to run automatically at a fixed time
- Create custom, on-demand queries and reports without requiring IT intervention (Correct answer)
- Approve purchase orders in real time
- Generate reports only in PDF format
Correct answer: Create custom, on-demand queries and reports without requiring IT intervention
Ad hoc reporting empowers business users to build and run their own custom reports on demand using self-service query tools.
Question 6: What is the purpose of report bursting in an ERP system?
- Compressing report file sizes for archival
- Automatically distributing a single report run as multiple segmented outputs to different recipients based on data filters (Correct answer)
- Running multiple ERP instances simultaneously
- Importing data from external CSV files
Correct answer: Automatically distributing a single report run as multiple segmented outputs to different recipients based on data filters
Report bursting splits one report run into personalized subsets and automatically distributes each to the appropriate recipient, such as regional managers receiving only their region's data.
ERP ERP Reporting, Analytics & Business Intelligence 2
What is an ERP exception report used for?