Wednesday, April 11, 2007

ERPs

The buzzword in IT for sometime now has been fully integrated systems and more recently the ERPs. Meaning that all the systems read basically from the same database – that once data has been posted in to the system, that information is available to all modules and users who might need it.

For example, a cash sale by salesman, once captured at the point of sales, updates your cash balance, turnover figures, stocks and payroll data with the sales-man commission etc. It also means that, where your organisation is involved in different business lines, any common information for the various lines of business, needs only be captured once into the system. And that all this information is available to the financial module and can be summarised at a click of a button without user intervention into financial reports – profit and loss statement and a balance sheet.

To what extent have various organisations achieved this?
In my view, this ideal situation is more easily achievable for trading enterprises particularly where the organisation is dealing in fairly similar products.

However, my experience in the service industry has been that this ideal situation has been quite elusive.

The major stumbling block to my mind has been the tendency of most solution providers to start by trying to meet the most complicated and involving demands of the users and then trying to work their way towards achieving the basics.

This is like climbing the legendary tree from the top. A more logical way of doing it and for which I believe the technology now exists is to start by achieving the basics and building in the complication of the industry as you go along.

The systems I have in mind here are all necessarily financial, where the end and most important report are the performance reports of the institution in financial terms.

A computerisation project to my mind should therefore start with meeting the basics of financial reporting i.e. a Profit & Loss Account and a Balance Sheet. It should concern itself with processing the data of each line of these financial statements before proceeding to other enhancements, utilities and aesthetic qualities.

My experience on the contrary has been that solution providers are so keen on showing you how the system will be able to auto generate standard letters to the client or other such superficial issues, they forget to address the basics. So that at the end of it, the user has to export data to excel for example just to work out the turnover for the current month and then after that post a manual journal in order to capture the information for financial reporting purposes.

Taking an example from an organisation I know, the noble desire to computerise has led to situations where fairly complicated documentation and reports are now available from the system but where the accuracy and understandability of some basic reports for example debtors and creditors statements and aged summaries, period transactions listings, period income or turnover reports etc have been greatly compromised. The organisation has resulted to managing their payables using excel spreadsheets and they have to rework their income and turnover for each reporting period manually. And now they are too far-gone in the implementation to ditch the project.

The situation has further been worsened by the existence of foreign share-holders from more ‘advanced’ countries who believe they have the ultimate solution from their countries to solve our IT needs. And the locals suffering from inferiority complex of sorts unquestioningly accept their wisdom. . . .Recipe for disaster!

3 comments:

J said...

IT Solutions - Have you had any experience with open source ERP systems? A good number of companies wouldn't be able to afford proprietary and expensive systems. Even SME organisations could benefit from use of an ERP in some instances, I would think

http://en.wikipedia.org/wiki/List_of_ERP_software_packages

Info Tek said...

"A computerisation project to my mind should therefore start with meeting the basics of financial reporting i.e. a Profit & Loss Account and a Balance Sheet. It should concern itself with processing the data of each line of these financial statements before proceeding to other enhancements, utilities and aesthetic qualities."
---------

Excellent points Julius! Hey, I think that an EXCELLENT & FREE Accounting/ERP product for the African marketplace is webERP. You just install it on a server with Apache, MySQL (or PostgreSQL) & PHP. That's it! Here's a quick blurb from the horse's mouth:

Improve Your Business's Profitability
It was a long time before accounting software evolved from DOS based systems to take advantage of modern graphical capabilities. Similarly, it has taken some time for accounting software to graduate from client-server technology and fully realise the benefits of Web 2. Whilst many systems now have the option of a web "front end", they remain, essentially, client server applications. True web-applications like webERP with a full feature-set are rare indeed. Due to the intensive processing required for client server applications the infrastructure - server farm, OS licensing costs, fiber optic connections, dedicated IT staff etc - to run them is a serious burden for many businesses. It could be so much easier and business could be so much more profitable. With webERP it is.

75% of all people in the world have access to the internet and almost all companies have a web presence. Accesibility to company records any-time, almost any-place provides real and tangible advantages to the business. Answers when you need them, where ever you may be, stock, pricing, credit history, profitability, sales analysis. It is all possible now with webERP.


Don't forget to take a peek at webERP's features.

Good luck dude!

Info Tek said...

Oh, if you need more info on how to set up PHP, MySQL and Apache the EASY way, just take a look at a recent blog post of mine over at Go Africa go!. The title is: Free powerful Intranet software with XAMPP. Just remember that the future for business computing revolves around HTTP(S) & Intranets.