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
house refresh service Morton Grove ..As small business owners we're in business to make money... Read More
Cleaning concrete is tough and there is an easy way... Read More
How many "get rich schemes" have you joined? Or have... Read More
Last week's question from Anthony R. on how to choose... Read More
When someone owes your small business money, you certainly feel... Read More
Don't let your customer satisfaction research initiative collect dust on... Read More
Traditional advertising methods are still being used for almost 90%... Read More
Ok, so next to the taxman, your company payroll department... Read More
Most business owners do not think of selling their companies... Read More
Seems as though there are a lot of business closings... Read More
When starting a business, you have to determine the method... Read More
Now that you have invested your time, energy and money... Read More
Canon City, Colorado is known for it's 6 Prisons; State... Read More
If you are in a franchise and have a territory... Read More
$elling $elling $ellingWhat makes a great sales person? Well, the... Read More
No matter how small your small business is, it is... Read More
Hew Hampshire car wash market. Well we have visited every... Read More
Where do you find the right people for a business... Read More
Why does consistency in the message have an effect on... Read More
Top 3 Ways to Maximize Your Small Business Server Consulting... Read More
Thinking of starting a business on line? If so there... Read More
Pity parties are nothing new. In fact, we do it... Read More
The air in my client's office nearly crackled with her... Read More
Often smart entrepreneurs look for out of the way businesses,... Read More
Fuel prices these days are quite high and they take... Read More
cleaning service near Mundelein ..Sexual Harassment is a disturbing part of employment life in... Read More
A successful joint venture marketing effort is the goal of... Read More
The FTC, Federal Trade Commission, is considering modifying the franchise... Read More
Until the day I learned to play chess I loved... Read More
Cleaning concrete is tough and there is an easy way... Read More
You've always liked flowers and you think the idea of... Read More
We all know that competition is an ugly word but... Read More
Are you a small business owner who wants to expand... Read More
To wash an airplane there are many items you will... Read More
Experts urge small business owners to "brand" their business ?... Read More
Q: After years of dreaming about starting my own business,... Read More
You want to know more about making money with your... Read More
To get approval for your small business loan application, you... Read More
Sometimes when you run a business you feel as lonely... Read More
TACTIC #1 -- Never simply slash your prices, unless you're... Read More
Would it help you as a real estate investor to... Read More
Franchising is the fastest way to build small businesses, provide... Read More
Today required franchise disclosure documents are over 200 pages generally.... Read More
With all the cabinet refacing business opportunities out there, you... Read More
If you're looking for start-up capital for your business, but... Read More
Why? Because they have access to world class public relations... Read More
Every employee would like to earn as high a salary... Read More
Are the promoters and consultants destroying the market for Reverse... Read More
Doesn't it frustrate you when you've given good service, sometimes... Read More
Q. I am a former pastor who left the ministry... Read More
Small Business |