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:

  • ODBC,

  • Replication,

  • Computed Views,

  • Integrated e-Mail,

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:

  • From Notes to your relational database

  • From your relational database to Notes

  • From a Notes database to another Notes database

  • From ASCII files to Notes database

  • From Notes database to ASCII files

  • Synchronization of both databases

  • Scheduled type transfers - in a defined time, or hour or minute or day, etc.

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

  • To establish the relationship of one-to-one, field x in Notes field y in the dBcompany,

  • Or we need a non-existent information, what fields we have to bring from the dBcompany to compute - in Notes - in order to obtain the desired information. We are speaking about "information", not of data.

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:

  • All the P.Os, products received, code, description, during the period t, with dates, quantities, costs, vendors, etc

  • The whole sales, during the period t, with dates, quantities, sales prices, responsible salesman, etc.

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

taxi from O'Hare Bismarck .. Lockport Chicago limo O’Hare
In The News:

The EO Canopy is a self-sustaining, solar-powered camping platform designed to provide all the comforts of home while completely off the grid.
Experts say hackers who used to focus on Windows operating systems are increasingly targeting Apple IDs as part of a new phishing campaign.
Unitree, a Chinese robotics company that developed a backflipping robot, has now introduced a humanoid robot capable of doing a side flip.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
According to the FBI, cybercriminals are sending extortion letters, threatening to release victims' sensitive information unless a ransom is paid.
FireSat is a satellite project designed to detect and track wildfires early, aiming to detect a fire that's the size of a classroom within 20 minutes.
Tech expert Kurt “CyberGuy" Knutsson reports that researchers have uncovered a Chrome vulnerability used in a cyber espionage campaign.
Preserving voicemails securely on Android: Tech expert Kurt “CyberGuy" Knutsson reveals easy methods to keep memories alive forever.
This phishing kit bypasses 2FA via session hijacking and real-time credential theft. Kurt “CyberGuy" Knutsson offers four ways to stay safe from Astaroth phishing attacks.
Tech expert Kurt “CyberGuy" Knutsson discusses Joby Aviation and Virgin Atlantic planning to launch 200-mph U.K. air taxis linking airports and cities.
Fake Apple virus warnings, security alerts and messages are tactics used to prompt you to call a number or click on a malicious link. The CyberGuy explains how to protect your devices.
The combination of artificial intelligence and neuroscience allows a paralyzed man to manipulate a robotic arm by using his brain to imagine movements.
With the help of artificial intelligence, sophisticated fraud techniques emerging today are virtually undetectable to the untrained eye.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
If you need to free up space on your Mac, consider deleting duplicate photos in your image library. Apple makes it easy to do, and the CyberGuy explains the process.
Microsoft is discontinuing Skype in May after 22 years of service. Kurt the CyberGuy addresses other options for internet-based phone and video service.
Tron 1, a Chinese company's two-legged robot, is versatile and can walk, roll and pivot, even on rough terrain. Tron 1 stands 33 inches tall and weighs 44 pounds.
Hackers are tricking people into installing password-stealing malware by making them press keyboard shortcuts under the pretense of proving they're not bots.
Saving the voices of loved ones can be a comforting way to keep alive memories. Kurt "the CyberGuy" Knutsson explains how to preserve voicemail messages.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
The FBI warns that some free online document converters load malware onto people's computers, making their private information vulnerable to attack.
Toyota's compact electric FT-Me is designed to tackle challenges of city living while offering an accessible and eco-friendly transportation solution.
Kurt “CyberGuy" Knutsson says 23andMe's bankruptcy raises data privacy fears: Opt out, download and delete data now.
UBTech and Zeekr unite with AI robot swarms to make car manufacturing faster and smarter. Tech expert Kurt “CyberGuy" Knutsson explains how the process works.
Tech expert Kurt “CyberGuy" Knutsson says Apple's Passwords app had a three-month phishing flaw from iOS 18 to 18.2 patch.

Common Sources of Financing for Small Business

The choice of financing is an important determinant of whether... Read More

How to Start an Office Support Service

Office support services can range from basic data entry to... Read More

Creative Metrification - A Technique to Improve

Some things in business are relatively easy to measure ?... Read More

(P)Refer to Grow Your Business

(Although this article is geared towards small business owners, the... Read More

Corporate Shells

A corporate shell could be liken to a house that... Read More

Franchise Territories are Generally Delineated On a Map; Why?

If you own a mobile service or home based franchise... Read More

Alliances: What works, what does not

Why Alliances FailWhen do you know an alliance is falling... Read More

What To Consider Before Buying A Franchise

Here are some useful tips on what to consider before... Read More

Canon City, Colorado - Good for Small Business

Canon City, Colorado is known for it's 6 Prisons; State... Read More

Pressure Washing; How to Bid Concrete Cleaning Jobs

Remember the cleaning business is all about time ratio to... Read More

Tell Me The Reasons Why I Should Believe You?

Have you ever heard the phrase, 'PREPONDERANCE OF PROOF'?I recently... Read More

Big Successes Never Happen Overnight

Treat your business as a serious, full-time business and be... Read More

Using Technology to Manage Customer Loyalty

Don't let your customer satisfaction research initiative collect dust on... Read More

The Workers? Compensation Situation in this Country is Nuts, Arnold in CA Takes Action

The Workers' Compensation situation in this country is unbelievable. Why,... Read More

The 5 Habits of Highly Successful Small-Business Owners

Have you ever wondered what the difference is between a... Read More

How to Integrate Yourself in Someone Elses Business

When do you need to get more involved with the... Read More

Pressure Washing Market Niche

Those who are in the pressure washer business should not... Read More

Postcard Marketing ? Low Cost Visibility

You need to be visible to attract customers, right? But... Read More

Patient Records - Your Responsibilities

As a practise gets larger & larger the associated problems... Read More

Effectively Completing the Operations Plan Section of Your Business Plan

The Operations Plan is a critical component of any business... Read More

SBAs 8(a) Program Can Help Some Companies Compete

Q: A friend told me that as a woman of... Read More

Business Owner--Educate Thyself!

Remember the training programs, seminars, and workshops you had to... Read More

Shocking Experienced Copywriter Reveals Little-known Secrets To Closing BIG Ticket Deals!

Hogwash!That's what I say to people who tell me that... Read More

Choosing A Business Thats Right For You

Q: I really want to start my own business, but... Read More

25 Valuable Phone Numbers For Small Businesses Success

Starting and growing a small business can be a daunting... Read More

Granger Lincoln Stretch limo rentals ..