ERP Reporting 4 — Questions and Answers
Question 1: Which ERP report is most useful for detecting unauthorized transactions or policy violations?
- Sales forecast report
- Audit trail report (Correct answer)
- Budget variance report
- Headcount report
Correct answer: Audit trail report
An audit trail report logs all system transactions with user, timestamp, and change details, enabling compliance teams to detect anomalies.
Question 2: A purchasing manager wants to evaluate which suppliers consistently deliver on time. Which report provides this information?
- Accounts payable aging report
- Vendor on-time delivery report (Correct answer)
- Purchase price variance report
- Inventory reorder point report
Correct answer: Vendor on-time delivery report
A vendor on-time delivery report measures the percentage of orders received by the promised delivery date, supporting supplier performance management.
Question 3: In ERP reporting, what is the role of a 'data cube' or OLAP cube?
- Store transactional data in row-based tables
- Enable multidimensional analysis of large datasets across dimensions like time, product, and region (Correct answer)
- Encrypt sensitive financial data
- Automatically generate purchase orders
Correct answer: Enable multidimensional analysis of large datasets across dimensions like time, product, and region
OLAP cubes pre-aggregate data along multiple dimensions, allowing fast, flexible analysis and slicing for management reporting.
Question 4: A CFO requires a report showing profitability broken down by product line, region, and customer segment simultaneously. Which tool best supports this?
- Standard GL trial balance
- Multidimensional BI/reporting tool integrated with ERP (Correct answer)
- Accounts payable ledger
- Employee expense report
Correct answer: Multidimensional BI/reporting tool integrated with ERP
Multidimensional BI tools linked to ERP data allow slicing profitability across multiple attributes at once for deep management insights.
Question 5: What distinguishes an exception report from a standard summary report in ERP?
- Exception reports include all records regardless of value
- Exception reports highlight only records that fall outside defined thresholds (Correct answer)
- Exception reports are generated weekly by default
- Exception reports are only available to system administrators
Correct answer: Exception reports highlight only records that fall outside defined thresholds
Exception reports filter out normal activity and surface only anomalies or threshold breaches, focusing management attention where it's needed most.
Question 6: Which financial ERP report shows the company's assets, liabilities, and equity at a specific point in time?
- Income statement
- Balance sheet (Correct answer)
- Cash flow statement
- Budget utilization report
Correct answer: Balance sheet
The balance sheet (statement of financial position) presents a snapshot of what the company owns, owes, and the residual equity at a given date.
Question 7: A manager wants to identify ERP report fields that contain personally identifiable information (PII). Why is this important?
- To speed up report generation times
- To ensure compliance with data privacy regulations like GDPR or CCPA (Correct answer)
- To reduce the number of report columns displayed
- To improve chart visualization aesthetics
Correct answer: To ensure compliance with data privacy regulations like GDPR or CCPA
Identifying PII in reports is critical for restricting access and ensuring the organization meets regulatory requirements for data privacy.
ERP Reporting 4
Which ERP report is most useful for detecting unauthorized transactions or policy violations?