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
maid service near Lake Forest ..If you have a busy private practice, chances are you... Read More
We all know that a building has to have a... Read More
The air in my client's office nearly crackled with her... Read More
You only have so much time in a day right?So... Read More
1. Leadership Is Learned ? While many people appear to... Read More
Are you a home or small business owner and you're... Read More
A recent survey indicated that clean Taxi Cabs Fleets have... Read More
Summer is a time for the outdoors, for that well-deserved... Read More
I have a confession to make. My name is Caroline... Read More
What unspoken message are you sending your clients and customers?... Read More
The easiest way to lift profits is to cut the... Read More
Many government department heads are on the take. Oh they'll... Read More
One way to determine your companies mission statement is based... Read More
Why? Because they have access to world class public relations... Read More
If you're starting your own business or currently work for... Read More
What is Business Valuation? The term business valuation is the... Read More
What's your job profitability? I meet with business owners every... Read More
CARD SHARK7 Card Tricks That Improve Your Personal Networking PowerThe... Read More
The following tips have come from a wide variety of... Read More
I'll be the first to admit that I went a... Read More
One of the major complaints in the QSR Quick Service-Fast... Read More
Here are seven ways for owners of small businesses to... Read More
Starting the blind cleaning business is one of the best... Read More
Cleaning concrete is tough and there is an easy way... Read More
In the first part of this article I put forward... Read More
top rated cleaning service Des Plaines ..-- The One Pager Shortcut Series --People do business with... Read More
There are many factors to be considered when you are... Read More
Franchisor expansion policies are not as simple as one might... Read More
How many "get rich schemes" have you joined? Or have... Read More
As a business owner, you already know how important it... Read More
Most business owners know when they need an accountant, but... Read More
Last year, trillions of dollars transferred hands on the internet... Read More
The American system of business management has been admired and... Read More
Starting and growing a small business can be a daunting... Read More
1. Everyone Makes A Difference ? Despite not letting him... Read More
What is a guru?A guru is a teacher. A mentor.... Read More
1. Resolve to build a consistent network system.Since referrals are... Read More
The Federal Trade Commission which governs the franchise industry thru... Read More
Until the day I learned to play chess I loved... Read More
Sometimes the simple businesses are the ones, which make good... Read More
What is a Virtual Assistant?? A Virtual Assistant is that... Read More
To wash an airplane there are many items you will... Read More
After over 30 years of participating in hundreds of businesses,... Read More
If a customer owes your local business money, it's hard... Read More
Did you ever have one of those days or weeks... Read More
What makes a business relationship?What really makes a business relationship?... Read More
Traditional advertising methods are still being used for almost 90%... Read More
There are only a handful of car wash franchises in... Read More
Many people ask how many graphs or charts they should... Read More
If you are a small business you know that you... Read More
Small Business |