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
Summer is a time for the outdoors, for that well-deserved... Read More
Most doctors never distinguish the difference between customers and patients.... Read More
When you hear the word "success" does it bring on... Read More
Sexual Harassment is a disturbing part of employment life in... Read More
Get maximum results with minimum effort. Sounds great doesn't it?... Read More
What makes a business relationship?What really makes a business relationship?... Read More
Recently one of my customers told me the chaos swirling... Read More
There is a Batting Cages Business for those people who... Read More
THE PSYCHOLOGY OF PRICINGIn case you hadn't noticed, people can... Read More
A recent survey showed that only 28.7% of small business... Read More
Congratulations, you are starting a small business! You are taking... Read More
How many hours do you work a week? When was... Read More
Hogwash!That's what I say to people who tell me that... Read More
How do you know when an alliance needs to be... Read More
Franchising companies often use Business Broker to help attain sales... Read More
Many times small businesses want to expand their businesses and... Read More
You've probably heard the statistic that 95% of small businesses... Read More
One of the first things you will need to set... Read More
When is advice free and when should you charge for... Read More
I agree that knowledge should be free, but the next... Read More
Mobile detailers will find themselves with lots of competition even... Read More
Imagine that you have operated a successful franchise business for... Read More
The easiest way to lift profits is to cut the... Read More
Many physical therapists in private practice have the appearance of... Read More
Incredible as it sounds, you have a goldmine of free... Read More
Home based travel businesses are no longer the wave of... Read More
On Monday the Department of Corporations in California revoked franchise... Read More
Concrete cleaning can be a lucrative business to start. Here... Read More
As a home business proprietor, you may already realize why... Read More
Who is responsible for maintaining the business relationship?Nurturing a business... Read More
Like most regulatory bodies in the United States, the Federal... Read More
According to the American Society for Aesthetic Plastic Surgery, since... Read More
Auto Detailing: Maintaining A Commercial Carpet ExtractorYou should drain your... Read More
To get approval for your small business loan application, you... Read More
That sizzling sound you're hearing may be a symptom of... Read More
Start thinking about buying an established business if you want... Read More
Why give freebies?We have all seen freebies at trade shows... Read More
Outsourcing is the strategic use of outside resources to perform... Read More
The Customer Analysis section of the business plan assesses the... Read More
Business Process Automation or BPA for short. This was a... Read More
1. TargetYou are not all things to all people. Decide... Read More
What is a Virtual Assistant?? A Virtual Assistant is that... Read More
It's obvious when a small business has accepted the fact... Read More
The air in my client's office nearly crackled with her... Read More
You can't imagine how many people ask me how I... Read More
You've heard marketing and advertising gurus quip, "Sell the sizzle,... Read More
Why does a good business relationship rely on having some... Read More
Most small businesses incorporated in 2005 will fail by the... Read More
Auto detailers are often asked to clean boats and detail... Read More
As you reflect on this year and prepare for next... Read More
Small Business |