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
rental limo Atlanta .. Lockport Chicago limo O’HareI propose this thought on the subject of Franchisee territory... Read More
Are you thinking of starting a small pressure washer business... Read More
Is it right for you?If you decide to advertise your... Read More
Most small business owners seek advisors who can help them... Read More
Running a business on the net these days can be... Read More
If small business had no important outside audiences, it wouldn't... Read More
How many "get rich schemes" have you joined? Or have... Read More
Why does research and education play an important part of... Read More
"Inch by inch, row by row...that's the way my garden... Read More
Do you know what your genius work is? It's the... Read More
Here are some useful tips on what to consider before... Read More
Gather round while I tell you the story of Kennebec... Read More
Many of us have noticed how some nearby communities seem... Read More
Q: After years of dreaming about starting my own business,... Read More
How do you find groups that are in need of... Read More
When a person knows and knows not that he knows.... Read More
Everyday more web based companies enter the business scene. The... Read More
What are the 5 best ways to gain new contacts?There... Read More
So you want to get into the auto detailing business... Read More
Every home business has the same problem of how to... Read More
Think of all of your business ideas as tiny seeds... Read More
Many investors and business ethics professionals are calling for more... Read More
When you awoke this morning, you found yourself buzzing with... Read More
For many small businesses, the "S" corporation is the business... Read More
Never underestimate the power of perception! Perception plays a major... Read More
Bedford Park taxi to Midway ..Why Alliances FailWhen do you know an alliance is falling... Read More
If you're just ramping up your small business email newsletter,... Read More
You can make your trade show experience much easier by... Read More
So often small service businesses fail to exploit niches, which... Read More
Success is the desire of everyman on the face of... Read More
Providing high quality customer service is a must for any... Read More
Before you want to build your business, you need to... Read More
Which questions do you need to ask to even get... Read More
One of the greatest pitfalls in e-commerce is Field of... Read More
It's obvious when a small business has accepted the fact... Read More
We are noticing an increase in the length of time... Read More
Your business is making profits, but where is the cash?... Read More
There is much competition in the mobile auto detailing business.... Read More
Have Some Time to Yourself One of the most important... Read More
I've got good news and bad news. The good news... Read More
As a practise gets larger & larger the associated problems... Read More
Work smarter, not harderWhat is one of the best ways... Read More
IntroductionIt is widely recognised that Email and the Internet is... Read More
What image do you and your people portray to your... Read More
When should you create a foundation in order to solidify... Read More
Should your business have a toll free number for customers... Read More
Washing the exterior of a truck. Sounds easy right? Well,... Read More
Company mottos can easily be printed on a business card.Sometimes... Read More
Here is an interesting case study of a company, which... Read More
You are probably hard at work promoting your business (and... Read More
Small Business |