In the first article we mentioned the main characteristics that should have a software to be used as a Front-End with some functions of an Enterprise Resources Planning ERP:
and we used the Lotus Notes example, but in principle will be possible to use other softwares with similar functions.
Now we will see a practical case, a system to detect and control - marketing, sales, new purchase orders - your aground products. As we know, the salesman prefer to sold new products only, and your aground products will be less and less sold.
We assume that your company already have an online managerial/accounting system, with evidently its own database.
1. We will use a method to transfer your managerial/accounting data to the Notes relational database, and although this last one has tools for that - ODBC for example - we recommended the purchase of a specific software for that purpose in order to be more flexible and with more powerful features, that must allow the following transfers:
Normally this kind of software works with the following databases - and this probably include the database type used by your company:
ALLBASE/SQL, Btrieve, Clipper, DB2, dBASE, Excel, Gupta SQLBase, IMAGE/SQL, INFORMIX, INGRES, InterBase, Microsoft SQL Server, Microsoft Access, Microsoft FoxPro, Netware SQL, Oracle, Paradox, Progress 6, SQL/400, SQL/DS, Sybase, Teradata, Files text, XDB, and also the databases types ODBC, client/server and desktop, etc.
2. We will decide what fields from your managerial/accounting system - here so called of dbCompany - you need in your new ERP. We can, for example
3. We will decide if we need data transcriptions and/or data conditionally computed. A simple example would be the need - in Notes - to generate the resulting information x of the data y,k,z from the dBcompany.
4. Summarizing the above functions Second and Third - about each different product we need from your dBcompany:
5. We acquire - extract - those data, to be placed in specific Notes fields, and creating the Notes "Views".
We will continue in the next article.
--
Publishing Guidelines: You may publish my article in your newsletter, on your website or in your print publication provided you include the resource box at the end. Notification would be appreciated but is not required.
About The Author
J.C.Melo is a 73-years old IT professional with 54 years of experience in computer & technology entrepreneurship. He was the owner of the first minicomputer factory in South America and Consultant for the U.S. Government in several contracts. Now is the CEO of http://mba-open-university.net and http://mba-open-university.net.
http://mba-open-university.net
shuttle from O'Hare Bingham .. Lockport Chicago limo O’HareFranchising Corporations need to maintain an iron fist when it... Read More
In the first part of this article I put forward... Read More
Macon, GA goes after garage-gas station conversion detail/hand car washes... Read More
I love lists. I make them for everything. And I'm... Read More
No matter what kind of small business you have, you... Read More
If a customer owes your local business money, it's hard... Read More
It is essential that you fully understand how the fuel... Read More
If you're starting your own business or currently work for... Read More
So you want to start a business but you don't... Read More
Lance Armstrong this week won an unprecedented 7th Tour de... Read More
I recently met with a very successful magazine publisher who... Read More
There are several well-known truck washes in the Great State... Read More
The life cycle of the typical small business is short... Read More
There is a rather famous true story called "Acres of... Read More
A tongue-in-cheek look at the skills required to operate a... Read More
One of the biggest excuses franchisees of home based and... Read More
Small Business, Big Business ? What's the Diff?Well a lot... Read More
Here are a few tips on how to hand out... Read More
As a franchisor I am always asked by new and... Read More
Consistency is a huge word when operating your business. I... Read More
E-mail and Internet use are integral parts of the typical... Read More
Researching information for a recent business plan, I came across... Read More
Don't let your customer satisfaction research initiative collect dust on... Read More
Traditional advertising methods are still being used for almost 90%... Read More
Have Some Time to Yourself One of the most important... Read More
Mishawaka limo O'Hare ..Does your small business have a banking and credit card... Read More
If you are a small business you know that you... Read More
Every company has business pain, but the pain does not... Read More
If you own a small business, you should know that... Read More
How do you make sure you have the business solutions... Read More
Cleaning concrete is tough and there is an easy way... Read More
What is a Virtual Assistant?A Virtual Assistant is a person... Read More
In these days of insecurity and uncertain futures, the tendency... Read More
Technical writing services are employed to explain the details of... Read More
Are you a motivational speaker who consistently gets rave reviews... Read More
Setting priorities in your business? Your first job is to... Read More
The efficiency of debt collection is the difference between a... Read More
Boston itself covers 50 square miles of concrete and traffic,... Read More
Are you a home or small business owner and you're... Read More
If you're starting your own business or currently work for... Read More
You only have so much time in a day right?So... Read More
The success of your business depends on your ability to... Read More
What is the best time to expand a mobile car... Read More
It's obvious when a small business has accepted the fact... Read More
Small business owners can relieve a lot of their own... Read More
It is estimated that 78% of all small business start-ups... Read More
Are you thinking of starting a small pressure washer business... Read More
There are many potential niches for pressure washing companies that... Read More
When working from home, it is usual to find that... Read More
The Operations Plan is a critical component of any business... Read More
Small Business |