Enterprise Resource Planning/Reporting
Completion status: this resource is ~50% complete. |
Educational level: this is a tertiary (university) resource. |
Subject classification: this is an information technology resource. |
Programme[edit | edit source]
This is a module part of the Open Source ERP/Executive Masters course conducted by a private university.
Subject[edit | edit source]
ERP Reporting - Towards Business Intelligence
Reporting is perhaps the killer app within any computerised operational system. A simple report that gives the right format for an end user particularly managerial level can be a deciding factor as to whether the system is doing its job and is highly prized.
Objectives[edit | edit source]
The objectives of this subject are:
- To appreciate the era of Business Intelligence in ERP
- To be familiar with BI Tools and usual processes
- To handle standard Print Formats for ERP Documents
Learning Outcomes[edit | edit source]
On completion of this subject the students shall be able to:
- Understand Reporting Needs of ERP
- Perform some standard Printout of documents and Financial Analysis
- Handle integration of ERP to 3rd party reporting tools
- Modify reporting formats to professional user requirements
Sypnosis[edit | edit source]
This subject looks into the reporting needs of an ERP System leading to Business Intelligence for the end users. Popular concepts from Master-Detail, Cross-Tab until cube drilling are exposed here. Practical hands-on skill building in preparing standard printouts.
Subject Details[edit | edit source]
Reporting Basics[edit | edit source]
(15 hrs)
- Printer Selection
- Printing Basics
- Print Formats
Document Printing[edit | edit source]
(20 hrs)
- Orders and Invoice Printing
- Inventory Movement
- Payments
Advanced Reporting[edit | edit source]
(20 hrs)
- Aging Analysis
- Cash Flow Analysis
- Budgetary Reporting
Financial Reporting[edit | edit source]
(20hrs)
- Column set definition
- Row set definition
- Creating Financial Analysis
- Using Jasper Reports
Using JasperReports[edit | edit source]
(15 hrs)
- IReports Editor
- Parameters and DataTypes
- Compiliing and deployment