| |
| |
|
Small Business Information |
|
|
|
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.
MORE RESOURCES:
Small-Business - Google News |
|
|
|
RELATED ARTICLES
A Small Business Must Have a Solid Foundation We all know that a building has to have a strong foundation if it is to survive, so, too, a business.There are many planks that support a business but there are four corner-posts that bear the most weight?The four corner-posts are Marketing, Selling, Production and Financial Control. How to Start a Pet Transportation Business Pet Transportation Services are needed as the number of pets in the U.S. Why Small and Medium-Sized Businesses Should As the owner or an employee of a small-to medium-sized business, you might have never thought about media monitoring. Maybe you are not even sure what exactly is meant by this and have thus ignored it so far. Are You Running Your Business or Is Your Business Running You? Being a small or home-based business owner can be loads of fun and very rewarding.You may have decided to go into business because of your need for personal freedom or to fully unleash your creative genius. Passion Is Key To A Successful Business Passion. Passion alone can make your business successful. How to Define Business Objectives Why does a good business relationship rely on having some common business objectives?As you attend networking events, you will gradually find ways that make it easy for you to mingle and be heard. Your message will need to be clear, focused and consistent each time. The Number of Pages in the UFOC in Franchising is Still Growing Today Today required franchise disclosure documents are over 200 pages generally. How many pages do you think the Uniform Franchise Offering Circular; UFOCs were 35 years ago for these ten-foot tall pillars of the franchising community like Kroc, Monhan and Rosenberg founded their companies? They were of course the founders of McDonalds, Domino's Pizza and Duncan Donuts. Small Business Checks - Money Saving Options When you go into business for yourself, there are many things to consider. What you don't want to worry about is spending too much money on unnecessary items. Provide Affordable Health Care To Employees At Little To No Cost To You You can provide affordable health care plans to your employees. If you feel overwhelmed by health care plan costs, you may be able to achieve far more than you believe. If You Want Business - Be Consistent Why does consistency in the message have an effect on how the business relationship is formed?Your message to others needs to be consistent. You need to define your expertise and develop your elevator pitch. Predicting Business Retirement Satisfaction for Business Owners Most business owners do not think of selling their companies as "retiring". Instead, these vital entrepreneurs see selling their business as a "transition. How To Write A Business Plan Writing a business plan is a fundamental step to ensuring your business has every chance of succeeding. Common statistics state that 9 out of 10 businesses fail on the first 5 years of operation, and of the remaining 10%, 90% fail in the following 5 years. Profits are within 6 Degrees of Freedom How far away is the person you need to meet?We have spent some time discussing your inner circle and have suggested that you take time to list all of the people that you know and that KNOW YOU. This inner circle is the start of finding out who knows a person that you need to meet. Success Tips for Small Business Owners Running a small business requires many skills. However, to do this successfully you need to organize yourself first. Small Business Spoiler - Procrastination One of the most common issues that comes up for business owners is procrastination -wasting time, putting obstacles in the way of taking action towards goals, making excuses for delays, creating confusion/busyness etc. Procrastination is a self-defeating behavior. Yeah, It IS Lonely At the Top Sometimes when you run a business you feel as lonely as the Maytag repairman. Loneliness and isolation are very common problems for business owners. Window Cleaning Business Start Up Should you buy a business opportunity or Franchise if you want to get into the window cleaning business? Or just start your own and work hard; grow the business into a full-time profession and expand from there? Let us talk briefly about window cleaning franchises is in general.One could argue without too much difficulty that buying a window cleaning franchise is simply a waste of money, after all you could simply go down to be 99 cents store and by a bucket 3 towels and a squeegee and hey, you are in business right? Well one could argue that, since to really be in business, you probably need to get a business license, insurance, buy some business cards and make a few flyers. How To Accept Credit Cards If you plan to do business online, then your website will need to accept credit cards. For many, the idea of applying for a merchant account sounds like a daunting task, but the truth is that building an online store is incredibly easy these days. Aircraft Washing Business Tip - Interior Private Jet Cleaning Aircraft Interiors of personal and corporate jets have hundreds of thousands of dollars invested. We have had an opportunity to speak at length in Tucson, AZ recently about the special custom interiors the weight they cost in performance and the needs in cleaning. Venus Transit - and Small Business? On June 8, 2004, the world witnessed what no one living today had ever seen..
|
|
|
|
|
