List Categories | List All Articles | List Articles By Title
Do You Want Your Own Fully Programmable ERP? - Part 2
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://erp-enterprise-resources-planning-courses.us.
Is Your Business Legally Prepared?
It is imperative to have your business legally prepared. How you ask? You need to have a business license, a home occupation license, if running your business from home, a city or county license, (depending on what State you live) plus you need to register your business as fictious if you are not using your name as a business.
Explode Your Consulting Income
Here are just a few ways to increase and diversify your income from your consulting business.1.
Uncover Free Veins Of Gold By Prospecting Online Guru Newsletters (Part 1 of 2)
Incredible as it sounds, you have a goldmine of free business advice and resources available to you for starting an online business. Many entrepreneurs are taking advantage of the unbelievable opportunity of financial independence by starting an Internet business.
Finding a Venture Capital Firm
Many ventures are faced with the challenging task of raising venture capital. The first part of this process is finding the right venture capital firm (VC).
Creating Lists to Learn About Yourself, Your Business and Your Customers
I love lists. I make them for everything.
3.5 Million People And A Possible UK Home Business Opportunity
Has this ever happened to you..
Franchise Buyers from Hell
I ran a franchise company for many years, a car wash franchise, and we use to get the most ridiculous franchise buyers who thought they wanted a franchise. It seems we had to deal with these Kookoo birds because they have consumer rights and the Federal Trade Commission, which looks over franchising goes out of their way to let these consumers get away with these tall tales.
How to Create an Information Plan
What is in an information plan?Before you even meet with a potential customer, you should have an action plan in place. The action plan should consist of 5 areas.
The SBAs Savviest Program
Forget everything you've ever heard about the U.S.
Keeping a Partnership ALIVE and THRIVING
What are the best methods for keeping a good business relationship?Once you have a business relationship in place, you need to work on that relationship to keep it intact. As a matter of fact, people nurture their business relationships more than they do their families! The first and most obvious method is to follow up with questions and requests in a timely manner.
Proper Care and Feeding of the Business Owner
That sizzling sound you're hearing may be a symptom of a major hidden cause of businesses closing their doors. It's called burnout.
How Micro Loans Can Mean Macro Success for Your Business
"Inch by inch, row by row..
Its Spring - Time For A Compensation Program Tune Up
Now that winter has passed, the annual ritual of spring cleaning is in full swing. Spring cleaning is more than cleaning the windows and clearing the cobwebs that hid in the corners during the winter.
Creating a Power Plan
Part of the power plan is making sure you have all the necessary contact information within a company. It is one thing to have the CEO's information, as he is the decision-maker, but it is quite another to have the information on others that you may be working with directly.
How To Get Slightly Famous in Print
Early in my career, I wrote an article for a small business magazine about self-publishing as a marketing tool for businesses. Because I specialize in helping businesses get into print, the article only took a few hours to write.
Increase Your Profits with a Point of Sale (POS) System
Whether you operate a chain of restaurants, a mom-and-pop convenience store, or a medium-sized retail shop, you are in business to make money. And, one of the most critical aspects to your profit and loss is your ability to track information? you need to know which products are making you money, what items need to be re-ordered, who your customers are, and so on.
How to Compete with the Big Guns?!
Many small business startups fail within the first 2 years of existence. There are several different factors reason for the failure.
Auto Detailers and Competitive Aspects of Automobile Detailing
There are both fixed and mobile detailers. Consumers often will use either or both during the life of their car.
How to Start an Office Support Service
Office support services can range from basic data entry to a fully-staffed office handling all the details of a client's business.An office support service company can start very small, offering only a limited selection of services and expanding as you gain the capacity to do so.
Five Quick Ways to Speed Up Cash Flow
At one point or another, almost every business runs short of cash. Whether due to normal fluctuations in demand or an unexpected decline in sales, cash shortfalls are the bane of every company, and are responsible for sleepless nights for many business owners.
home | site map
All articles are copyright to their owners.
Note: this website lists articles, We do not Write Articles !