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 ..This morning, I went to take a short walk outside.... Read More
Gather round while I tell you the story of Kennebec... Read More
Macon, GA goes after garage-gas station conversion detail/hand car washes... Read More
I only have to point to the 555 plus failed... Read More
Starting a business? For many people, the bravery to venture... Read More
Get maximum results with minimum effort. Sounds great doesn't it?... Read More
There's no question that hard work and a little luck... Read More
If you're serious about wanting to start a business, the... Read More
Part of the power plan is making sure you have... Read More
We very much like what we see in Lubbock, TX... Read More
Administrative and clerical tasks are the bane of every industry.... Read More
-- The One Pager Shortcut Series --People do business with... Read More
In a perfect world, starting a small business would be... Read More
The choice of financing is an important determinant of whether... Read More
How far away is the person you need to meet?We... Read More
What would happen if you decided to take an extended... Read More
Do you have a Business Plan? Congratulations, but you are... Read More
Starting and growing a small business can be a daunting... Read More
Many small business startups fail within the first 2 years... Read More
For really tough boat hull cleaning you will need to... Read More
What is in an information plan?Before you even meet with... Read More
More sales and more profit. Isn't that what you want... Read More
Why does a good business relationship rely on having some... Read More
Passion. Passion alone can make your business successful. As an... Read More
I love work, I can watch it all day.I am... Read More
full-service cleaning Mundelein ..Yes, that IS security when nobody can downsize you because... Read More
Owning a business is a challenging endeavor. If you're like... Read More
I recently met with a very successful magazine publisher who... Read More
Does your company have a community relation strategy? Have you... Read More
Costs of over regulation and over disclosure end up hurting... Read More
Last summer the FTC put forth a report and then... Read More
The choice of financing is an important determinant of whether... Read More
There are many little details that go into making sure... Read More
If you are a small business and qualify to participate... Read More
Writing a business plan for a mobile car wash is... Read More
Many pressure washing companies will be glad to take on... Read More
Do you own a franchised business? Over 400,000 franchised businesses... Read More
Get maximum results with minimum effort. Sounds great doesn't it?... Read More
Everything starts with a business plan: If you don't have... Read More
The FTC, Federal Trade Commission, is considering modifying the franchise... Read More
At first blush this idea might be difficult to wrap... Read More
Are you a small business owner who wants to expand... Read More
Many investors and business ethics professionals are calling for more... Read More
This year, some 700,000 American businesses will be sold. Most... Read More
In the heavy equipment cleaning business you can make good... Read More
Do you operate your business as a series of projects,... Read More
Hogwash!That's what I say to people who tell me that... Read More
You make the decision to go into business and for... Read More
Image of your franchise automotive outlet is so important. Some... Read More
Incorporation in Nevada has become an attractive option for savvy... Read More
Small Business |