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
Ashley limo service .. Lockport Chicago limo O’HareThat's right ? are you making enough mistakes in your... Read More
Franchising Directory Sites-Paid Advertising, Lead Generation for FranchisingFranchising Directory Sites... Read More
What are the best methods for keeping a good business... Read More
Are you tired yet of all the books out there... Read More
Data. Most people think it is a term relegated to... Read More
Owning a business is a challenging endeavor. If you're like... Read More
We are noticing an increase in the length of time... Read More
Today is a Red Letter Day! It's special because today... Read More
If you've been considering incorporating your small business, you've probably... Read More
Franchising is the fastest way to build small businesses, provide... Read More
Most businesses accept checks as form of payment for goods... Read More
Cash is King?That is what everyone tells us and it... Read More
Every business regardless of size needs a "Business Image Manual"... Read More
So there I was ? sitting in the audience of... Read More
You see it often in large shopping complexes. Customers seem... Read More
In my previous article, Step 1, your challenge for the... Read More
Many pressure washing companies will be glad to take on... Read More
Why Alliances FailWhen do you know an alliance is falling... Read More
"Order Now!" "Your Business Will Fail If You Don't Have... Read More
Franchising has made the world look really small. The well... Read More
If I had $1.00 every time I heard someone say... Read More
At first blush this idea might be difficult to wrap... Read More
A recent survey showed that only 28.7% of small business... Read More
Mobile carwashing is hard work, it is tough on the... Read More
The air in my client's office nearly crackled with her... Read More
car service from Midway Arena ..You bet it's worth it. Publicity via news releases, along... Read More
Small Business, Big Business ? What's the Diff?Well a lot... Read More
In franchising an individual desirous of their own business will... Read More
After over 30 years of participating in hundreds of businesses,... Read More
Tammy, a skilled and gifted horticulturist, called me to discuss... Read More
Starting a business? For many people, the bravery to venture... Read More
Do you like animals? Would you like to work for... Read More
Free money! Receive up to $25,000 that never has to... Read More
When is the Chamber ideal for your business?Joining a Chamber... Read More
Search Engines account for almost 90% of all web traffic!In... Read More
Have Some Time to Yourself One of the most important... Read More
1. There Are No "gimmes" ? They count two-foot putts... Read More
Most business owners do not think of selling their companies... Read More
The success of your business depends on your ability to... Read More
If you're an entrepreneur responsible for your own small business... Read More
In today's marketplace the words 'job security' have become an... Read More
Many new ventures are preoccupied with all the money they... Read More
It's a strange anomaly.Most people who set out to start... Read More
No matter what kind of small business you have, you... Read More
Motivational author and speaker Jim Rohn says that for a... Read More
Your on-line success is based on your efforts and yours... Read More
A Mattress Cleaning Business might be just for you if... Read More
The story is told of a tiger chasing some goats... Read More
CONSIDERATIONS FOR YOUR INTERN: Specify the number of hours the... Read More
If you are looking for a way to own your... Read More
Small Business |