ERP Reports

Standard ERP Reports and Report Writing

Current ERP systems come loaded with pre-written reports, but the list never covers all users needs. These systems all come with their preferred report that is advertised for the end user. Ultra has found that it often takes users weeks and often months to master these report-writing tools.

The importance of report writing is often overlooked as a critical step in the implementation of a new ERP system. Information is the goal of the ERP implementation. To achieve it requires both strategy and capable resources to achieve the goal.

Report writing needs fall into the following categories:

  • Forms such as invoices, order acknowledgments, purchase orders, receivables statements, payables checks, etc.
  • Managed reports that are produced on a recurring basis
  • Ad hoc reports that are usually, one-time, “I need this information now” reports
  • Analytical reports that are views of data that help analyze “what is happening”
  • Executive dashboards that provide the executives with a snapshot of business performance against the company’s key performance indicators (KPIs)

All of these needs need to be considered in a comprehensive report writing strategy, that identifies needs at all levels, report-writing tools, data deployment (data warehouse versus data marts), and report deployment methods.

Ultra’s Approach to ERP Reports

The development of reports and forms is a significant task that cannot be taken lightly. Often “access to information” is a key driver of the project.

During the Business Process Improvement (BPI) phase of the project, the project team should be sure to document forms and reports used in the business process. In addition, the team should gather key performance indicators used to manage the business.

In the development of the future state, the team will define the reporting strategy. The strategy will document the following:

  • Key performance metrics
  • Transactions and dimensions
  • Information needs
  • Analysis needs

In the education phase the team will understand the many types or reporting tools:

  • Transaction grid queries
  • Dashboards
  • Scorecards
  • Published reports
  • Ad hoc reports

The reporting strategy will define how all these reporting tools are used to “improve access to information”.