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
tidy up service Glenview ..Opening a carpet cleaning business is a great way to... Read More
My colleague, Jane, recently lamented to me an all too... Read More
How do you find groups that are in need of... Read More
Running a small business requires many skills. However, to do... Read More
Hi, Charles...here, Your Cap and t-shirt guy From Texas. How... Read More
Aircraft Interiors of personal and corporate jets have hundreds of... Read More
Washing manufactured homes, mobile homes, can be a lucrative and... Read More
SBIR vs. STTR: If you are participating in the SBIR... Read More
Anyone in business today realizes both the natural dependency on... Read More
The easiest way to lift profits is to cut the... Read More
You can provide affordable health care plans to your employees.... Read More
Like most regulatory bodies in the United States, the Federal... Read More
Your product is dying. With the same inevitability that we... Read More
"Order Now!" "Your Business Will Fail If You Don't Have... Read More
Ask anyone trapped in a cubical about their entrepreneurial dream... Read More
A cluttered world of marketing communications diminishes the ordinary. The... Read More
Most small businesses simply go about their daily business and... Read More
Why does a good business relationship rely on having some... Read More
Researching information for a recent business plan, I came across... Read More
Is it right for you?If you decide to advertise your... Read More
Office support services can range from basic data entry to... Read More
Most small business owners are faced with so many responsibilities... Read More
Why should you always maintain a good report with a... Read More
At first blush this idea might be difficult to wrap... Read More
Most small business owners seek advisors who can help them... Read More
full-service cleaning Mundelein ..If you are thinking of turning your current into a... Read More
There are countless ways to save your business money. Unfortunately,... Read More
There will come a time in your business where you... Read More
Here are some of the questions that you need to... Read More
1. Don't Spend Too Much Time PlanningWhen you are entering... Read More
Every employee would like to earn as high a salary... Read More
To have one of the popular in home daycare businesses.... Read More
As a successful small business owner,you're accustomed to long hours;... Read More
Whether your target audience is in your neighborhood or across... Read More
As a home business proprietor, you may already realize why... Read More
Starting a business? For many people, the bravery to venture... Read More
Many of our nations 400,000 franchisees run their businesses out... Read More
Looking for ways to boost your cash flow? As a... Read More
Would it help you as a real estate investor to... Read More
Q. I am a former pastor who left the ministry... Read More
Becoming a contractor or sub-contractor for the U.S. government can... Read More
The FTC Franchise Rule maybe changed, as the Federal trade... Read More
Here's why 'WHY' is such a profit-making marketing trigger."Stop taking... Read More
Here are just a few ways to increase and diversify... Read More
You are probably hard at work promoting your business (and... Read More
Many pressure washing companies will be glad to take on... Read More
Why should you always maintain a good report with a... Read More
While there are few career paths that some would call... Read More
One of the biggest fears people have about starting a... Read More
What types of companies do you want to align yourself... Read More
Small Business |