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
family-safe home cleaners Northbrook ..To maximum potential profits and dollars in a mobile washing... Read More
Gather round while I tell you the story of Kennebec... Read More
As a practise gets larger & larger the associated problems... Read More
Shipping materials can be expensive! Even the styrofoam "peanuts" can... Read More
You know your prospects need what you sell. You know... Read More
Competition in the business world is often viewed as a... Read More
What is in an information plan?Before you even meet with... Read More
You've heard marketing and advertising gurus quip, "Sell the sizzle,... Read More
Most doctors never distinguish the difference between customers and patients.... Read More
Consistency is a huge word when operating your business. I... Read More
So what exactly is a "Small Business Lone Ranger?" A... Read More
Lance Armstrong this week won an unprecedented 7th Tour de... Read More
Are you responsible for your results?What comes to mind when... Read More
Does your small business have a banking and credit card... Read More
Now that you have invested your time, energy and money... Read More
In this series of articles I'm going to show you... Read More
North County San Diego has had some significant growth, and... Read More
If you own a mobile service or home based franchise... Read More
In today's marketplace the words 'job security' have become an... Read More
Many businesses offer small business franchise opportunities. There are many... Read More
You have spent considerable time pulling your business plan together,... Read More
Q: After years of dreaming about starting my own business,... Read More
Database Problems in MarketingI have been working on a direct... Read More
Managing cash flow is every small business owner's most important... Read More
One of the biggest excuses franchisees of home based and... Read More
residential cleaning services Deerfield ..No, I'm not talking about gambling or dairy cows ?... Read More
You're pretty proud of yourself! After all, only four months... Read More
Most doctors never distinguish the difference between customers and patients.... Read More
You can't imagine how many people ask me how I... Read More
If you don't know what a Virtual Assistant (or VA)... Read More
We are noticing an increase in the length of time... Read More
If I had $1.00 every time I heard someone say... Read More
Multimedia is everywhere on the Internet, whether in the form... Read More
Do you like animals? Would you like to work for... Read More
There are several well-known truck washes in the Great State... Read More
For really tough boat hull cleaning you will need to... Read More
Experts urge small business owners to "brand" their business ?... Read More
How to identify future solutions and opportunities?Your power page, if... Read More
Most of us remember going to at least one garage... Read More
Are you -- like 70 percent of small business owners... Read More
Some things in business are relatively easy to measure ?... Read More
Bookkeeping?the "dreaded" word is something we all have to worry... Read More
The Workers' Compensation situation in this country is unbelievable. Why,... Read More
Since you own a business you probably have liability insurance... Read More
Why does consistency in the message have an effect on... Read More
A tongue-in-cheek look at the skills required to operate a... Read More
Completion not Perfection Five Keys To Doubling Your Productivity and... Read More
Sometimes when you run a business you feel as lonely... Read More
At first blush this idea might be difficult to wrap... Read More
Incredible as it sounds, you have a goldmine of free... Read More
Small Business |