Jump to content

Enterprise Resource Planning/Reporting

From Wikiversity
Completion status: this resource is ~50% complete.
Educational level: this is a tertiary (university) 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