| |
| |
|
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
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. The Failures Guide to Small Business Success How many "get rich schemes" have you joined? Or have you invested in numerous legitimate business endeavors only to have them not work for you? Have you started you business and now facing a complete shut down? Do you consider yourself a failure? Are your loved ones pressing you to give up?Risk-taking is a large part of entrepreneurship, in fact it is what drives it, and it's why so many people avoid small business, despite its many potential rewards. Those of us who have tried it only to have failed may find ourselves right back where we started, which could leave us feeling like total failures. Quality Controls for Franchising Companies Sample Outline Quality control in franchising companies is paramount and all franchising companies must have strict guidelines to insure consistency. To insure this takes place throughout your franchise system you must make this a policy in your confidential operations manual. Eight Key Steps to Selling Your Business and Cashing In This year, some 700,000 American businesses will be sold. Most will be small and mid-sized businesses like yours. Top 10 Rules for Small Business Success 1. TargetYou are not all things to all people. Employee Induction - Are you Inducting your People - A Practical How To In today's fast paced marketplace it is easy to neglect the small important things!Recently we assisted an organisation prove they had complied with their obligations in inducting their employee. The employee tried to bring a claim for severe stress against the business. Motorizing for Profit - The Craftsmen Have Left the Building In the summer, I can't drive two blocks without seeing the activity of the construction industry. Road contractors, house builders and landscapers are everywhere. 432 Page Franchise Report by the FTC The Federal Trade Commission is upgrading the franchise law and they have made a report. Recently I have been reviewing the FTC's franchise rule report page by page. How Micro Loans Can Mean Macro Success for Your Business "Inch by inch, row by row.. What Happened to the Money and Freedom? Ask anyone trapped in a cubical about their entrepreneurial dream and they will tell you, "I want to own my own business. I'll make more and have more time. Image of Your Franchise Automotive Outlet is So Important Image of your franchise automotive outlet is so important. Some say image is everything, well then if you buy a franchise you should be constantly thinking of image and cleanliness. Franchisee; Vacation Managing Do you own a franchised business? Over 400,000 franchised businesses currently operate in the United States, which is a true testament of free enterprise. There are many advantages of franchised businesses, which anyone who owns a small business has thought about. Collection Agency Selection Frankly, given the legal and regulatory requirements involved in attempting to collect a debt, it makes as much sense to do it yourself as it does to try to remove your own appendix. A collection agency is, on the whole, much cheaper than a doctors - and lawyers. Entrepreneurs Ask: What Can a Virtual Assistant Do For Me? Great question!Freeing your time is an indisputably key element in growing your business! When you delegate tasks to the capable hands of a professional Virtual Assistant (VA), you can quickly and easily refocus your energies on other aspects of business directly linked to generating revenue.Partnering with a professional Virtual Assistant will:Increase your revenue. Effective Customer Interviews Make Life Much Easier! One of the critical success factors for service-related businesses is our ability to understand a client's needs and requirements. Misunderstandings can lead to loss of repeat business, economic loss, and damage to reputation. Your Babys Ugly..and Youve Got Bad Breath I've got good news and bad news. The good news is that 98% of businesses are small businesses. Survival Tips For Small Businesses You may be in Mail Order, Direct Mail, or you may be a local merchant with 150 employees; whichever, however or whatever---you've got to know how to keep your business alive during economic recessions. Anytime the cash flow in a business, large or small, starts to tighten up, the money management of that business has to be run as a "tight ship. Lawyers Everywhere Telling Regulators What Laws to Make The Federal Trade Commission decided to sit down and revamp the franchise rule of the 1970's. They started to do it in 1995 and postponed it then had some comments collected in 1997 and then in 1999. Be Nice to Your Payroll Department Ok, so next to the taxman, your company payroll department might well be the most criticised people on the planet. Of course, when your pay is accurate and on time then you love the payroll people with a passion but when things go wrong it is a completely different matter. Explode Your Consulting Income Here are just a few ways to increase and diversify your income from your consulting business.1.
|
| home | site map |
| © 2006 |
