Enterprise Resource Planning/Reporting

Completion status: this resource is ~50% complete.
Educational level: this is a tertiary (university) resource.

Programme

edit

This is a module part of the Open Source ERP/Executive Masters course conducted by a private university.

Subject

edit

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

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

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

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

Reporting Basics

edit

(15 hrs)

  • Printer Selection
  • Printing Basics
  • Print Formats

Document Printing

edit

(20 hrs)

  • Orders and Invoice Printing
  • Inventory Movement
  • Payments

Advanced Reporting

edit

(20 hrs)

  • Aging Analysis
  • Cash Flow Analysis
  • Budgetary Reporting

Financial Reporting

edit

(20hrs)

  • Column set definition
  • Row set definition
  • Creating Financial Analysis
  • Using Jasper Reports

Using JasperReports

edit

(15 hrs)

  • IReports Editor
  • Parameters and DataTypes
  • Compiliing and deployment