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
efficient cleaning crew Northbrook ..As stability emerges in the Middle East there will be... Read More
Shopping for a franchise is easy if you know what... Read More
Setting priorities in your business? Your first job is to... Read More
A Private Investigator is a professional trained in the art... Read More
It is essential that you fully understand how the fuel... Read More
You're a small business owner with a hot new product... Read More
If you are just starting your business, or if you... Read More
Owning a small business in Wichita, KS might not be... Read More
Most new small businesses won't be in business this time... Read More
Your on-line success is based on your efforts and yours... Read More
Some marine biologists feel that the concentration of dead marine... Read More
In today's marketplace the words 'job security' have become an... Read More
Am I the only one that does not have an... Read More
No matter your age or station in life, we all... Read More
A top executive called up me late in the night.... Read More
There's no question that hard work and a little luck... Read More
When working from home, it is usual to find that... Read More
Many smaller businesses choose niche markets for various reasons and... Read More
My colleague, Jane, recently lamented to me an all too... Read More
A Mattress Cleaning Business might be just for you if... Read More
Too often in business we get trapped into reviewing our... Read More
It has been discussed allowing Franchising companies to electronically disclose... Read More
On Monday the Department of Corporations in California revoked franchise... Read More
If you are worried about how many different business cards... Read More
The Service-Disabled Veteran-Owned Small Businesses (SDVOSB) is a program that... Read More
cleaning lady near Wilmette ..If you are a franchisee of a large franchise system;... Read More
There's no question that hard work and a little luck... Read More
"So what?" is a lovely question.It can lead to a... Read More
Owning a business is a challenging endeavor. If you're like... Read More
Everything starts with a business plan: If you don't have... Read More
This morning, I went to take a short walk outside.... Read More
No matter what kind of small business you have, you... Read More
Your business is making profits, but where is the cash?... Read More
It has been discussed allowing Franchising companies to electronically disclose... Read More
If you have ever had your antique shop or mall... Read More
Your grandfather probably told you to "learn something new everyday".... Read More
How do marine type businesses start? Have you ever thought... Read More
Why Alliances FailWhen do you know an alliance is falling... Read More
The FTC, Federal Trade Commission, is considering modifying the franchise... Read More
As a practise gets larger & larger the associated problems... Read More
When it comes to cost, how much can you afford... Read More
Microfiber cleaning towels have been around for about ten years... Read More
According to the American Society for Aesthetic Plastic Surgery, since... Read More
I have to admit, I was curious. When I saw... Read More
There are many little details that go into making sure... Read More
Q: After years of dreaming about starting my own business,... Read More
Once you've decided to incorporate your small business the next... Read More
Pity parties are nothing new. In fact, we do it... Read More
Scenario OneDuring a recent presentation, a business owner was given... Read More
No matter your age or station in life, we all... Read More
Small Business |