Saturday, August 18, 2007

Managing Your Customers with CRM Software


My good buddy recently sent me an email bragging about an Intranet solution for managing your customers. Best of all, it’s an Open Source project so the price is $0. :)

The product is called vTiger CRM and thes
e are its main strengths:
  • Sales force Automation (orders, potentials, leads, contacts, etc.)
  • Marketing Automation (campaigns, leads, etc.)
  • Customer Support & Service (FAQs, trouble tickets, etc.)
  • Order Management (sales, purchase, etc.)
  • Inventory Management (products, vendors, etc.)
  • Analytics & Reports (sales, inventory, leads, tickets, quotes, etc.)
    and much more…
After reading more about the product, I decided to install it on my home PC. My first impression is that the program is very polished, intuitive and powerful. I can see our company using something like this to really keep us ahead of the competition.
The best thing about vTiger is its Intranet-based architecture. Just install it on a PC with a web server (Apache, IIS, etc.), and the MySQL database. Personally, I would install it on Ubuntu Linux (free) with Windows Server 2003 as my second option.
You can start using the product’s many CRM (Customer Relationship Management) features by pointing your web browser to the correct internal URL from any desktop PC in the office.
After an employee logs in with their user id and password, she will be taken to a personal dashboard (see attached image) where she has access to everything (campaigns, trouble tickets, leads, quotes, orders, etc.) about her customers.
Right now, I don’t think there’s another application like vTiger here in Kenya. I look forward to writing more about this powerful Intranet application after I spend a little more time with it.

By the way, is your company using a CRM application?

Saturday, June 16, 2007

A Quick Look at Information Architecture

Although Accounting is my main point of focus, I find the ICT field very exciting. I did hear somewhere that accountants are boring. Now that can't be true. Well, thank goodness that doesn't apply to me.

I just recently started reading an interesting book called "Information Architecture for the World Wide Web, 2nd Ed." I’m hoping to take the vast organizational knowledge in this book and apply it to future projects here at the office or, perhaps, on a side project. Here’s how the book (pg. 19) defined IA:

"If you're new to the field, you may still be wondering: what exactly is information architecture? This section is for you.

in·for·ma·tion ar·chi·tec·ture n.
  1. The combination of organization, labeling, and navigation schemes within an information system.
  2. The structural design of an information space to facilitate task completion and intuitive access to content.
  3. The art and science of structuring and classifying web sites and intranets to help people find and manage information.
  4. An emerging discipline and community of practice focused on bringing principles of design and architecture to the digital landscape.
Were you expecting a single definition? Something short and sweet? A few words that succinctly capture the essence and expanse of the field of information architecture? Keep dreaming!"
Are you still confused? Remember that architects and engineers are trained to have detailed plans (schematic, etc.) before any cement is poured. But in ICT, things are not as organized yet. I guess that’s what IA is all about: Organising information.
Just keep your eyes here over the next few weeks (or months) and I will try to regurgitate some of the book’s finer points. That’s if I have time. :-)
By the way, what book are you reading right now? Let me guess: Harry Potter? :-)

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!