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.
![]() |
|
![]() |
|
![]() |
|
![]() |
Completion not Perfection Five Keys To Doubling Your Productivity and... Read More
Let me get right to the point. The single most... Read More
And is having a logo really that important?My answer to... Read More
Why? Because they have access to world class public relations... Read More
When deciding to host a fundraiser for your company or... Read More
What is the satisfaction & expectation review of the business... Read More
Are you a small business owner who wants to expand... Read More
Small businesses need Public Relations, possibly more than large corporations,... Read More
Service Cleaning Businesses must maintain their equipment in order to... Read More
Over regulation of small business is so intense it is... Read More
Someone new to business ownership recently told me, "Before I... Read More
When the recent Games of the XXVIII Olympiad came to... Read More
Becoming a contractor or sub-contractor for the U.S. government can... Read More
A consultant must remember that the business belongs to the... Read More
TRUTH IN THE LAWN MOWING INDUSTRYWe do not wish to... Read More
Buyers want both online and local information about where to... Read More
As an Investment Representative you've worked hard to build trust... Read More
At first blush this idea might be difficult to wrap... Read More
What are the best methods for keeping a good business... Read More
You're pretty proud of yourself! After all, only four months... Read More
I love work, I can watch it all day.I am... Read More
Bookkeeping?the "dreaded" word is something we all have to worry... Read More
"The way to develop self-confidence is to do the thing... Read More
Has this ever happened to you... 'John, you have a... Read More
What does it take to grow a business and run... Read More
You want to know more about making money with your... Read More
This year, some 700,000 American businesses will be sold. Most... Read More
Many new ventures are preoccupied with all the money they... Read More
I ran a franchise company for many years, a car... Read More
If you are looking for a franchise opportunity, the choice... Read More
When is the Chamber ideal for your business?Joining a Chamber... Read More
You know what makes me really happy? Drinking a Starbucks... Read More
Is your business making money? Would you know?Figuring out whether... Read More
Thankfully, most of us will never find out. That is... Read More
Seems as though there are a lot of business closings... Read More
Many smaller businesses choose niche markets for various reasons and... Read More
Sacred cows take a long time to die. We get... Read More
Every business regardless of size needs a "Business Image Manual"... Read More
When someone owes your small business money, you certainly feel... Read More
Writing a business plan for your Solo Entrepreneur business doesn't... Read More
Franchising is the fastest way to build small businesses, provide... Read More
Here are seven ways for owners of small businesses to... Read More
WHEN you are operating or planning a small business that... Read More
The Federal Trade Commission decided to sit down and revamp... Read More
The choice to incorporate a small business in Florida has... Read More
Home based travel businesses are no longer the wave of... Read More
Get maximum results with minimum effort. Sounds great doesn't it?... Read More
Has this ever happened to you... 'John, you have a... Read More
The key to organizational focus and helping those who need... Read More
The following tips have come from a wide variety of... Read More
We have all seen the mobile washing units cruising our... Read More
1. Look Over Your Shoulder ? Of course, Punxsutawney Phil... Read More
Starting your own e-commerce business can be quite the adventure.... Read More
Ongoing support for a franchise system is omnipotent. A major... Read More
Buying a franchise is not for everyone. This guide will... Read More
As small business managers, we juggle limited resources in a... Read More
Everything starts with a business plan: If you don't have... Read More
THE PSYCHOLOGY OF PRICINGIn case you hadn't noticed, people can... Read More
Small business success is very similar to learning to walk,... Read More
There is a great deal of abuse going on in... Read More
What is Business Valuation? The term business valuation is the... Read More
In general, all of us know how to accomplish the... Read More
Business Process Automation or BPA for short. This was a... Read More
In franchising an individual desirous of their own business will... Read More
A top executive called up me late in the night.... Read More
Aircraft Interiors of personal and corporate jets have hundreds of... Read More
Small Business |