Monthly Archives: May 2011

ERP and Reporting – Part 1

SAP Business One

Sometimes its quite easy to think that an Enterprise Resource Planning (ERP) software is greater than the sum of its parts. I tend to disagree. I think (and again, this is something I personally believe) an ERP is only as good as its reporting functionality.

Wikipedia somehow helps solidify my point of view by reporting:

Enterprise resource planning (ERP) integrates internal and external management information across an entire organization…

Management information usually falls into the realm of reports and reporting tools.

SAP Business One comes with (you should be sitting down for this!) not one but 6 (SIX!) Reporting tools, 7 if you include SAP Crystal Solutions Dashboard (formerly known as Xcelsius).

These reporting tools are:

  1. SQL Queries (within SAP Business One)
  2. Drag and Relate
  3. XL Reporter (XLR)
  4. Crystal Reports (CR)
  5. SAP Crystal Solutions Dashboard / Xcelsius *
  6. MS SQL Analysis Services
  7. 3rd Party Reporting tools – Excel etc

* SAP Crystal Solutions Dashboard / Xcelsius requires an additional license purchase

In the next few blog posts I’ll detail out the above tools and how they help in day to day operations as well as administration of SAP Business One.

Advertisements