ERP Reporting

From Wikiversity
Jump to navigation Jump to search
Progress-0500.svg Completion status: this resource is ~50% complete.
Fileshare.png Type classification: this resource is a course.
Sciences humaines.svg Educational level: this is a tertiary (university) resource.
Gnome-fs-client.svg Subject classification: this is an information technology 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