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
Rolling Meadows Cadillac Escalade rental .. Lockport Chicago limo O’HareMany job applicants want a job but often do not... Read More
Cleaning the trailers towed by big trucks is not easy,... Read More
Most small businesses will not even try to advertise on... Read More
I've got good news and bad news. The good news... Read More
Thankfully, most of us will never find out. That is... Read More
Articles abound advising the business community how to properly screen... Read More
No, I'm not talking about gambling or dairy cows ?... Read More
Most small businesses simply go about their daily business and... Read More
"Order Now!" "Your Business Will Fail If You Don't Have... Read More
All franchises must meet the legal definition of a franchise... Read More
Canon City, Colorado is known for it's 6 Prisons; State... Read More
Competition in the business world is often viewed as a... Read More
Should you buy a business opportunity or Franchise if you... Read More
Do you like animals? Would you like to work for... Read More
If you run a mobile car wash, mobile fleet washing... Read More
What image do you and your people portray to your... Read More
Here are seven ways for owners of small businesses to... Read More
One of the simplest ways to expand your marketing efforts... Read More
By outsourcing to skilled professionals you'll be able to grow... Read More
One of the greatest pitfalls in e-commerce is Field of... Read More
If you run a pressure washing company in a rural... Read More
Here's why 'WHY' is such a profit-making marketing trigger."Stop taking... Read More
And is having a logo really that important?My answer to... Read More
Manufactured and Mobile Home owners know that the weather this... Read More
Most business owners do not think of selling their companies... Read More
Des Moines rental limo ..With the massive explosion of start-ups and home businesses developing,... Read More
Where do you look for the appropriate alliance?One of the... Read More
The story is told of a tiger chasing some goats... Read More
Did you know that satisfaction is the number one emotion... Read More
Many physical therapists in private practice have the appearance of... Read More
Rule 15C211Under SEC Rule 15C211, a U.S. securities broker or... Read More
According to the American Society for Aesthetic Plastic Surgery, since... Read More
If you're like the rest of us, you've spent a... Read More
When the recent Games of the XXVIII Olympiad came to... Read More
Starting and growing a small business can be a daunting... Read More
Commonly folks have asked me what the technical difference is... Read More
Many of us have noticed how some nearby communities seem... Read More
One of the biggest excuses franchisees of home based and... Read More
A successful joint venture marketing effort is the goal of... Read More
As long as you eat and breathe you will stay... Read More
Due to the over regulation in the Franchising Industry and... Read More
You've probably heard the statistic that 95% of small businesses... Read More
There is much competition in the mobile auto detailing business.... Read More
How far can you go based on your relationship with... Read More
Do you need grant funding for your nonprofit organization? If... Read More
There are both fixed and mobile detailers. Consumers often will... Read More
Today is a Red Letter Day! It's special because today... Read More
When you feel like you're always busy working on your... Read More
Does your small business have a banking and credit card... Read More
We were more than excited. Our women's doubles tennis team... Read More
Small Business |