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
taxi from O'Hare Bismarck .. Lockport Chicago limo O’HareThe choice of financing is an important determinant of whether... Read More
Office support services can range from basic data entry to... Read More
Some things in business are relatively easy to measure ?... Read More
(Although this article is geared towards small business owners, the... Read More
A corporate shell could be liken to a house that... Read More
If you own a mobile service or home based franchise... Read More
Why Alliances FailWhen do you know an alliance is falling... Read More
Here are some useful tips on what to consider before... Read More
Canon City, Colorado is known for it's 6 Prisons; State... Read More
Remember the cleaning business is all about time ratio to... Read More
Have you ever heard the phrase, 'PREPONDERANCE OF PROOF'?I recently... Read More
Treat your business as a serious, full-time business and be... Read More
Don't let your customer satisfaction research initiative collect dust on... Read More
The Workers' Compensation situation in this country is unbelievable. Why,... Read More
Have you ever wondered what the difference is between a... Read More
When do you need to get more involved with the... Read More
Those who are in the pressure washer business should not... Read More
You need to be visible to attract customers, right? But... Read More
As a practise gets larger & larger the associated problems... Read More
The Operations Plan is a critical component of any business... Read More
Q: A friend told me that as a woman of... Read More
Remember the training programs, seminars, and workshops you had to... Read More
Hogwash!That's what I say to people who tell me that... Read More
Q: I really want to start my own business, but... Read More
Starting and growing a small business can be a daunting... Read More
Granger Lincoln Stretch limo rentals ..As you reflect on this year and prepare for next... Read More
Do you know what your genius work is? It's the... Read More
Does your company have a community relation strategy? Have you... Read More
As a franchisor I am always asked by new and... Read More
There is a continual trend we are seeing which I... Read More
If you're an entrepreneur responsible for your own small business... Read More
Consistency is a huge word when operating your business. I... Read More
One of the first things you will need to set... Read More
What are the best methods for keeping a good business... Read More
I have a confession to make. My name is Caroline... Read More
If you plan to upgrade your workshop into an Authorized... Read More
Microfiber cleaning towels have been around for about ten years... Read More
There are countless ways to save your business money. Unfortunately,... Read More
I recently met with a very successful magazine publisher who... Read More
As a home business proprietor, you may already realize why... Read More
One of the best ways to make money in the... Read More
Where do you find more customers?How do you compete with... Read More
Who is responsible for maintaining the business relationship?Nurturing a business... Read More
If you're organized, smart, capable and willing to work with... Read More
Just when the entire state was kissing Wichita goodbye, economically... Read More
Your business account comes with an ATM, Debit card. Pick... Read More
We are noticing an increase in the length of time... Read More
Entrepreneurs are hardy stock. But sometimes hardiness can get you... Read More
Every business plan book tells you how the Executive Summary... Read More
Are you a motivational speaker who consistently gets rave reviews... Read More
Small Business |