Constructing an FPMS in a medium-sized consulting company using a combination of an ERP system and Microsoft Excel
by Anders Rom, Carsten Rohde
International Journal of Accounting and Finance (IJAF), Vol. 2, No. 1, 2010

Abstract: This paper reports on a study on how Integrated Information Systems (IISs) support financial project management in a medium-sized consulting company. The study applies the case study method and the Constructive Research Approach (CRA). It was found that the Enterprise Resource Planning (ERP) system (an Online Transaction Processing (OLTP) system) primarily supports the task of data collection, while Microsoft Excel (an Online Analysis Processing (OLAP) system) can be used for reporting, budgeting and budget control. These two subsystems of the IIS are integrated with regard to ex post data stored in a common database. This allows access to real-time data throughout the IIS. However, some degree of disintegration exists as the project budgets are only stored in the spreadsheets, which presents a number of limitations with regard to reporting and analysis. The reason for using the combination of OLTP and OLAP systems is the need for flexibility and user-friendliness. Based on the findings, this paper expands the limited knowledge on how different kinds of systems support different management accounting tasks. The findings indicate that not only do OLTP systems support the management accounting of companies, but the user-friendliness and flexibility of OLAP systems also complement the OLTP systems in that respect.

Online publication date: Tue, 02-Mar-2010

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Accounting and Finance (IJAF):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com