|
|
| 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.
|
|
|
|
RELATED ARTICLES
Australian Workplace Agreements - How They Work For You The employer / employee relations environment has been constantly evolving during the last 25 years. In Australia, as in many western nations, the balance between employers and employees has shifted back and forwards usually in response to supply and demand. Franchisor; Ongoing Support and Ideas Ongoing support for a franchise system is omnipotent. A major part of any family relationship is communication. A large franchise system is similar to a giant family; it needs constant communication. By providing on going support for your franchisees, we will guarantee both success and open communication lines will strengthen you company and team in the market place. Some things, which many franchisors do not do or do not do enough are little things which are really low cost and simple. For instance sending out sales tapes. Secrets of Cleaning Truck Trailers in Your Fleet from a Veteran Truck Washer Cleaning the trailers towed by big trucks is not easy, those big forty-foot to fifty-three foot boxes are quite intimidating up close when you are holding nothing more than a brush and pressure washer gun, looking at a soap bucket. The hardest thing to do is to clean the back doors of trailers because they get really greasy from all the debris and stuff the truck has driven through. When they run through bad weather areas, they get even dirtier. Pay special attention to rear doors on trailers. Sometimes you'll have to brush them twice. You may even have to do them three times until you get them right. Use a harsh soap or degreaser and watch for left over dirt around the tubular bars that act as the door locks and sealing mechanism. Now on the top of the sides of the trailer you'll have lots of soot if you have a tractor that's been leaking or maybe has a small oil leak or an exhaust problem. This leaves this big exhaust stain down the side of the trailer from the exhaust stack on the tractor. This is a problem because it is hard to clean and you need to clean it. So sometimes you will have to stand on top of the tractor and brush downward. This is done because you cannot get enough leverage from the ground. You may need to pour cleaner directly on your brush or you may need to put cleaner directly on the sides of the trailer. You may need to do both. Make sure the brush is really wet and then set the nozzle on the spray bottle for a steady stream. Spray with the wind and shoot the spray up to the top of the trailer and kind of saturate it a little bit. Then brush it. Now it should be able to come clean. Make sure you rinse really well; otherwise you'll have soap streaks running down the sides. These will be black soap streaks because they will have some of the exhaust mixed in with the soap. Small Business Credit Card Advantages Obtaining a business credit card enables the small business owner to separate personal expenses from business expenses. Offering business credit cards to their employees eliminates the need for employees to use their personal credit cards or cash to make company purchases. Employees using a business credit card will not need to fill out expense statements, wait for approval and reimbursement from their company. Transactions are itemized and reported on quarterly statements that make it easy for management to make changes if needed. Business credit cards can be provided to the employees with preset spending limit and helps in controlling employee spending. Youll See It When You Believe It - Growing Your Business from the Inside Out What unspoken message are you sending your clients and customers? Is your personal energy field projecting positive, high vibrational energy or just the opposite? The latter will cost you business--and worse, you won't even realize it. The energy I'm talking about here has been called many things, "being in flow," "in the zone," "locked on", "jazzed", "sending out good vibes," (that last one is for anyone old enough to remember the 60's). Small Business - Would You Still Need An Accountant If You Didnt Need A Tax Return? After over thirty years advising small business it still comes as a surprise to see the number of small business owners who are only interested in their financial results when it is time to do their tax return. Mobile Carwash; Senior Citizens and Mobile Homes Senior citizens are generally not a large marketing segment for mobile detailers or car washers, however, they should not be ignored. You will find in a near by area a seniors-only mobile home park. You will also find square dance clubs and senior centers. All of these places can be extremely good places to look for new business. If you want to accelerate word of mouth advertising, you should meet with people in these groups. Wash cars at senior centers while they play cards. Hand out flyers, etc. Street Wars Between Mobile Car Washers and Mobile Auto Detailers There is much competition in the mobile auto detailing business. There are two different lines of reasoning emerging as to how the business should be run. One is go for volume and discount and wash the world. The other is go after the high end customer which is 10% of the market, do exceptional work and charge as much as the market will give. These two principles are the reason for a war between mobile auto detailers and mobile car washes. Mobile car wash companies are often seen washing the Honda car for the single mom in an office complex. While the auto detailers would not touch the car unless she was a total babe and they thought they might get a date out of it. Small Business and Branding ? Why and How? When we speak of branding most of the time people try to relate it to big business house, however, the fact is that every business needs to establish their brand in order to survive the competition. This is nothing new; experts and management gurus had been preaching the same sermon for years now but what they have not told is why you need to brand your small business? How is branding going to help you to establish your business? How can you establish your brand without spending a fortune on it? Book Yourself Solid Key #5: Go Forward With Gusto & Articulate What You Do Want your small business to flip instead of flop?! Statistically half of the entrepreneurs reading this will be out of business in three short years. Establishing a long standing, profitable and successful business absolutely depends on your ability to convey a clear message. A heartfelt message that tells clients exactly what you do, the specific 'invest-able opportunities' you bring to the table and all the ways clients will have a bigger, better, fuller life as a result of working with you. Learning and Growing As you reflect on this year and prepare for next year, what are the lessons you have learned in business and how do you plan to use those lessons to grow your business in the year ahead? SBIR vs STTR SBIR vs. STTR: If you are participating in the SBIR program you may also want to consider participating in the Small Business Technology Transfer (STTR) Program. The STTR program is considered SBIR's twin sister, although there are some added hoops one must jump through in order to participate. Like SBIR, the STTR is the US Government's way of providing "seed" money to spawn technology growth. The key difference however is in the structure of the effort, whereas a small business must partner (via a subcontract) to a university or non-profit research institution in order to acquire STTR funding. How to Protect Yourself & Your Business As a business owner, you already know how important it is for your customers to feel safe about doing business with you. After all, if a customer even suspects he may not receive everything he was promised, then chances are he's taking his business elsewhere. So to prevent that you offer guarantees, secure payment methods, prompt customer service, and more. You do whatever it takes to show each customer that you are sincere and trustworthy. Entrepreneurs and Franchisors Watch Out New Franchisors and Entrepreneurs need to watch out as they enter into the world of franchising. What advice can I give to a new franchisor, I was asked today by another entrepreneur with a wonderful new concept; what are the tiger traps that lay ahead? Got Stimulation? An observation while returning home from a seminar: Getting away from the everyday allows room for analysis and new thoughts. Stimulation while away from the everyday energizes analytical and concept ional thinking. 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. Rightly or not the payroll professionals come in for an awful lot of abuse if your pay is not perfect. Build Credibility, Value, and Trust on a Shoestring Setting priorities in your business? Your first job is to sell. Selling is - writing the orders; receiving the cash; feeding the beast. If you don't sell; the beast, (your business), dies. The impact of selling is immediate. You may love it, but it is a beast. You need to feed it and control it. 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. And you may be its next victim. Often the last thing a business owner considers is his or her health and sanity. The burnout that results from overwork and stress can deliver a death blow to the very enterprise you've been giving your all to create. Setting a course for your business that includes the proper care and feeding of the business owner is a critical success factor in every business. 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. One thing, which is very interesting is most all the comments came from attorneys who specialize in either suing franchisors or suing franchisees. A little conflict of interest isn't it. Worse off; the government looks at their comments closely when determining new rules of law. Lawyers are out to make money suing business people, not helping free-enterprise, few of them have ever worked an honest day in their lives. Starting An E-Commerce Business: Baby Steps Starting your own e-commerce business can be quite the adventure. There is nothing wrong with falling head over heels in love with your ideas and plans and becoming overly excited, but always remember, feet first. Creating a business from scratch is like a child learning to walk. You need to grab on to something solid, feel around, get a sense of balance, and take baby steps.
|
| home | site map |
| © 2005 |