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’HareEveryone is talking about small businesses. In 1993, when it... Read More
Many small business startups fail within the first 2 years... Read More
Opening a carpet cleaning business is a great way to... Read More
Pet Transportation Services are needed as the number of pets... Read More
No matter how small your small business is, it is... Read More
All cities have a purchasing office and/or a procurement officer.... Read More
Every company has a value proposition. That is a statement... Read More
Starting and growing a small business can be a daunting... Read More
Tap these treasures of ideas. The best money you can... Read More
Writing a business plan is a fundamental step to ensuring... Read More
There are many choices when thinking about a small business... Read More
Cleaning the trailers towed by big trucks is not easy,... Read More
If you are the boss and you think your job... Read More
Here are some useful tips on how to select a... Read More
There will come a time in your business where you... Read More
1. Look Over Your Shoulder ? Of course, Punxsutawney Phil... Read More
Image of your franchise automotive outlet is so important. Some... Read More
Pity parties are nothing new. In fact, we do it... Read More
So there I was ? sitting in the audience of... Read More
Before you read any further in this article, I'd like... Read More
Sacred cows take a long time to die. We get... Read More
There is a continual trend we are seeing which I... Read More
If you plan to upgrade your workshop into an Authorized... Read More
What will your business look like a year from today?If... Read More
If you're just ramping up your small business email newsletter,... Read More
Mishawaka limo O'Hare ..One of the best marketing strategies a business or organization... Read More
In a perfect world, starting a small business would be... Read More
If your home business is not performing the way you... Read More
Recently one of my customers told me the chaos swirling... Read More
Ongoing support for a franchise system is omnipotent. A major... Read More
Have you ever wondered what the difference is between a... Read More
What unspoken message are you sending your clients and customers?... Read More
If you own a small business, then you know the... Read More
Buying a franchise is not for everyone. This guide will... Read More
It's a strange anomaly.Most people who set out to start... Read More
Sexual Harassment is a disturbing part of employment life in... Read More
There's been a recent rise in the number of elderly... Read More
Are you -- like 70 percent of small business owners... Read More
No matter what kind of small business you have, you... Read More
Why does research and education play an important part of... Read More
E-mail and Internet use are integral parts of the typical... Read More
Why do you need an account plan?When you first decide... Read More
Some of the greatest words of wisdom for any man... Read More
Think of all of your business ideas as tiny seeds... Read More
The following are six essential skills to business success. You... Read More
SBIR vs. STTR: If you are participating in the SBIR... Read More
Disclosure laws in franchising are suppose to help the consumer.... Read More
The Operations Plan is a critical component of any business... Read More
Are you tired yet of all the books out there... Read More
When you awoke this morning, you found yourself buzzing with... Read More
Small Business |