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
recurring cleaning service Mundelein ..In the heavy equipment cleaning business you can make good... Read More
Commonly folks have asked me what the technical difference is... Read More
Most small business owners seek advisors who can help them... Read More
Manufactured and Mobile Home owners know that the weather this... Read More
If an organization lacks a mission statement, it is worthwhile... Read More
For really tough boat hull cleaning you will need to... Read More
Many of us have noticed how some nearby communities seem... Read More
In my 18 years of consulting I have heard it... Read More
We all know how glorious those first warm days of... Read More
In the world today, many people are further in debt... Read More
As a franchisor I am always asked by new and... Read More
Small business success is very similar to learning to walk,... Read More
If you have ever had your antique shop or mall... Read More
People will always stress that having a well researched business... Read More
If you are in the professional car care business you... Read More
There is much competition in the mobile auto detailing business.... Read More
The key to organizational focus and helping those who need... Read More
Seems as though there are a lot of business closings... Read More
When you hear the word "success" does it bring on... Read More
Your business is making profits, but where is the cash?... Read More
If you're just ramping up your small business email newsletter,... Read More
Administrative and clerical tasks are the bane of every industry.... Read More
A corporate shell could be liken to a house that... Read More
Company mottos can easily be printed on a business card.Sometimes... Read More
What is a Family Business? A family business is basically... Read More
tidy up service Buffalo Grove ..When a person knows and knows not that he knows.... Read More
You've probably heard the statistic that 95% of small businesses... Read More
If you discovered the bottom line in your business depended... Read More
Sometimes the simple businesses are the ones, which make good... Read More
We were more than excited. Our women's doubles tennis team... Read More
One of the great challenges for independent professionals and small... Read More
How do you find groups that are in need of... Read More
In a quest for customers and to keep those customers,... Read More
Purchasing a franchise has become one of the most popular... Read More
As stability emerges in the Middle East there will be... Read More
(Although this article is geared towards small business owners, the... Read More
Having a successful business means also having a good working... Read More
The less a business pays for goods and services the... Read More
Whether it has been thrust upon you by external market... Read More
There are many factors to be considered when you are... Read More
In today's economic climate, the first priority for the small... Read More
Most small business owners are faced with so many responsibilities... Read More
One of the primary concerns all small businesses have is... Read More
What is the Big Race all about when it comes... Read More
No matter type of business you operate you've got to... Read More
Pardon my enthusiasm, but a large part of your small... Read More
Washing manufactured homes, mobile homes, can be a lucrative and... Read More
Marketing is one of the four corner-posts of a solid... Read More
Here is an interesting case study of a company, which... Read More
Concrete cleaning can be a lucrative business to start. Here... Read More
Small Business |