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://erp-enterprise-resources-planning-courses.us.
A thing worth doing is worth doing badly. Yes I... Read More
Introduction: This article is written as a general discussion on... Read More
Business card size works well for invitations to special events.What... Read More
In the Truck Washing Business every single type of vehicle... Read More
Many times small businesses want to expand their businesses and... Read More
If you are a motorcycle detailer and need to expand... Read More
Under the Securities Act of 1933, any offer to sell... Read More
If you are the boss and you think your job... Read More
You know what makes me really happy? Drinking a Starbucks... Read More
Have Some Time to Yourself One of the most important... Read More
A Brilliant Marketing Idea... sounds great but what is it?... Read More
Paper Shredding Business Opportunities are blossoming up everywhere because in... Read More
As long as you eat and breathe you will stay... Read More
The Dynamics of Daylight Savings Time changes the way we... Read More
Do You Really Need a Toll-Free Number for Your Business?... Read More
Some marine biologists feel that the concentration of dead marine... Read More
What is in an information plan?Before you even meet with... Read More
A successful joint venture marketing effort is the goal of... Read More
When is advice free and when should you charge for... Read More
The day care industry is expanding. There are now more... Read More
Entrepreneurs are hardy stock. But sometimes hardiness can get you... Read More
Cleaning concrete is tough and there is an easy way... Read More
You can make your trade show experience much easier by... Read More
As an entrepreneur you can learn a lot by following... Read More
Want your small business to flip instead of flop?! Statistically... Read More
Car Wash Crime in the Hood. Apparently not everyone is... Read More
Who is responsible for maintaining the business relationship?Nurturing a business... Read More
I've got good news and bad news. The good news... Read More
TRUTH IN THE LAWN MOWING INDUSTRYWe do not wish to... Read More
First you have to start with knowing your budget and... Read More
Washing manufactured homes, mobile homes, can be a lucrative and... Read More
Do you spend every waking minute in your business? Do... Read More
You make the decision to go into business and for... Read More
In the 2003 Auto Laundry News Survey it was determined... Read More
One of the critical success factors for service-related businesses is... Read More
Business Process Automation or BPA for short. This was a... Read More
As a small business owner, outsourcing work to Virtual Assistants... Read More
The current lack of industry leaders represents an exceptional opportunity... Read More
You can't imagine how many people ask me how I... Read More
If you intend to franchise your company you will need... Read More
If you own a mobile truck washing, pressure washing or... Read More
Why does a good business relationship rely on having some... Read More
We're birds of a feather, public relations and small business.... Read More
How do you find the best business partners?Finding a good... Read More
Introduction: This article is written as a general discussion on... Read More
While driving through Pennsylvania farmland, you have probably noticed an... Read More
IntroductionIt is widely recognised that Email and the Internet is... Read More
When someone owes your small business money, you certainly feel... Read More
Most of us remember going to at least one garage... Read More
Do you spend every waking minute in your business? Do... Read More
Who is responsible for maintaining the business relationship?Nurturing a business... Read More
What was your aim when you went into business for... Read More
The FTC- Mighty Federal Trade Commission has unilaterally decided to... Read More
Take advantage of world politics today and start your own... Read More
If you run a pressure washer business you need complete... Read More
What kinds of things effect mobile service businesses P and... Read More
It's the dream of every person who starts a business... Read More
Many businesses offer small business franchise opportunities. There are many... Read More
If you are in the professional car care business you... Read More
As an Investment Representative you've worked hard to build trust... Read More
The following tips have come from a wide variety of... Read More
People will always stress that having a well researched business... Read More
Macon, GA goes after garage-gas station conversion detail/hand car washes... Read More
Many have not experienced a fire up close. One year... Read More
Let me get right to the point. The single most... Read More
You may find this Newsletter a little long winded but... Read More
Small Business |