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

eco-friendly cleaning service Buffalo Grove ..
In The News:

A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.
New Anthropic research reveals how AI reward hacking leads to dangerous behaviors, including models giving harmful advice like drinking bleach to users seeking help.
The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
Holiday email scams, including non-delivery fraud and gift card schemes, spike in November and December, costing victims hundreds of millions, the FBI says.
Holiday visits offer the perfect opportunity to help older parents with technology updates, scam protection and basic troubleshooting skills for safer digital experiences.
Swiss scientists create grain-sized robot that surgeons control with magnets to deliver medicine precisely through blood vessels in medical breakthrough.
Researchers exploited WhatsApp's API vulnerability to scrape 3.5 billion phone numbers. Learn how this massive data breach happened and protect yourself.
Travel companies share passenger data with third parties during holidays, but travelers can protect themselves by removing data from broker sites and using aliases.
Xpeng's humanoid robot moves so realistically that crowds believed it was fake, marking a major advancement in robotics technology ahead of 2026 commercial launch.
Researchers discover phishing scam using invisible characters to evade email security, with protection tips including password managers and two-factor authentication.
iPhone and Android users can reduce battery drain and data usage by restricting Background App Refresh to Wi-Fi connections instead of mobile networks.
Scammers nearly stole an Apple account by exploiting the support system with authentic-looking tickets and phone calls, users can protect themselves with safety steps.
FoloToy restored sales of its AI teddy bear Kumma after a weeklong suspension following safety group findings of risky and inappropriate responses to children.
Threat intelligence firm Synthient uncovers one of the largest password exposures ever, prompting immediate security recommendations.
Viral video shared by Elon Musk shows Tesla's Optimus humanoid robots performing tasks from cooking to construction, garnering over 58.5 million views on social media.
Chinese hackers used Anthropic's Claude AI to launch autonomous cyberattacks on 30 organizations worldwide, marking a major shift in cybersecurity threats.
Apple's new Sleep Score feature gives you a rating for your nightly rest quality. Learn how to set it up on your Apple Watch and iPhone today.
Essential phone settings to enable before losing your device, including Find My network, location services and security features for iPhone and Android.
The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
Cybersecurity research shows weak passwords remain a major threat, with simple patterns and number sequences putting millions of accounts at risk.
New Android malware BankBot YNRK silences phones, steals banking data and drains crypto wallets automatically. Learn how this advanced threat works.
FDA approves first human trial for Paradromics' brain-computer interface that could restore speech for paralyzed patients through neural technology.
New phishing platform QRR targets Microsoft 365 users across 1,000 domains in 90 countries. Learn how to spot fake login pages and protect your accounts.
OpenTable now uses AI to track your dining habits and share insights with restaurants. Learn what data they collect and how to protect your privacy.
Google's discontinued Nest thermostats still secretly upload home data to company servers despite losing smart features, raising serious privacy concerns.

How to let go of your EGO

When does your ego get in the way?Let's go back... Read More

Small Business Debt Collection Laws

In your small business debt collection laws will eventually become... Read More

The SBAs Savviest Program

Forget everything you've ever heard about the U.S. Small Business... Read More

Boat Cleaning Business Case Study: Entrepreneurship 101

How do marine type businesses start? Have you ever thought... Read More

Choosing A Business Thats Right For You

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

Speed Kills on the Web!

I only have to point to the 555 plus failed... Read More

Starting an Aircraft Washing Service

To wash an airplane there are many items you will... Read More

The Advisory Board: A Business Owners Most Valuable Resource

As a company grows, the owner's role begins to change.... Read More

Starting a Virtual Assistant Business

If you're organized, smart, capable and willing to work with... Read More

Be Nice to Your Payroll Department

Ok, so next to the taxman, your company payroll department... Read More

Building Marketing Momentum For Your Small Business

The success of your business depends on your ability to... Read More

Grab Your Consumers Attention in a Cluttered World of Marketing Communications

A cluttered world of marketing communications diminishes the ordinary. The... Read More

Small Business Essentials: Start Here

Thinking of starting a business on line? If so there... Read More

Pressure Washer Companies and Steam Cleaner Maintenance

If you run a pressure washing business it is a... 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

Small Business Success Secret: Focus on Your Genius Work?

Do you know what your genius work is? It's the... Read More

How to Start an Office Support Service

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

Janitorial Cleaning Service: Getting Started

A janitorial cleaning service is one of the best businesses... Read More

Keeping a Partnership ALIVE and THRIVING

What are the best methods for keeping a good business... Read More

How to Profit Handsomely From a Secret Business Model Virtually No Small Business is Using!

Have you been searching for the perfect home-based business? I... Read More

7 Habits of Highly Successful Small Business Owners

Do you spend every waking minute in your business? Do... Read More

Firing Underperforming Employees in Your Small Business

Here are a few tips on how to hand out... Read More

Does Your Small Business Marketing Suffer From The Bulldog Effect?

If you're an entrepreneur responsible for your own small business... Read More

Where Can People Find Information About Starting A Business?

Approximately 200,000 new businesses are started each year. More people... Read More

Self Serve Car Washes in the United States

In the 2003 Auto Laundry News Survey it was determined... Read More

express cleaning service Arlington Heights ..