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