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

recurring cleaning service Mundelein ..
In The News:

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.
New Android malware NGate steals NFC payment codes in real-time, allowing criminals to withdraw cash from ATMs without your card. Learn protection tips.
DoorDash confirms data breach exposing customer names, emails, addresses after social engineering attack. Learn how to protect yourself from scams.

Cabinet Refacing Business Opportunities

With all the cabinet refacing business opportunities out there, you... Read More

Real World Accounting for Small Business Owners

If you're like me, you love accounting. It's so fascinating... Read More

Starting A Concrete Cleaning Pressure Washer Business

Concrete cleaning can be a lucrative business to start. Here... Read More

The ABCs of Fundraising

There are many little details that go into making sure... Read More

Entrepreneurs Ask: What Can a Virtual Assistant Do For Me?

Great question!Freeing your time is an indisputably key element in... Read More

Starting a Small Business: Balancing Risk and Reward

In a perfect world, starting a small business would be... Read More

The More you GIVE the More you GET

Why give freebies?We have all seen freebies at trade shows... Read More

Technology Community Helps SMBs Focus on Their Core Business

If you're starting your own business or currently work for... Read More

Top 10 Lessons for Small Business Success - As learned From My Twin 3 Year Olds

Small business success is very similar to learning to walk,... Read More

Women and Small Business

In the book Women and Small Business author gives all... Read More

Overcoming Your Biggest Competitor

Before you read any further in this article, I'd like... Read More

How the Crab Effect Obstructs Growth and How to Conquer It

Some of the greatest words of wisdom for any man... Read More

Local Search and Internet Yellow Pages - A Whole NewVocabulary for Small Businesss

Buyers want both online and local information about where to... Read More

Small Business Debt Collection Laws

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

7 Tips to Improving Your Cash Flow

Cash is King... That is what everyone tells us and... Read More

How to Raise Your Fees and Thrill Your Customers

Think the best way to get more customers is to... Read More

How to Wash Mobile Homes as a Business

Washing manufactured homes, mobile homes, can be a lucrative and... Read More

Business Checks are an Added Cost to Your Small Business - Try Making Them Yourself!

Starting and managing a small business is no fun chore,... Read More

Selling Your Business, Entrepreneurs Role

$elling $elling $ellingWhat makes a great sales person? Well, the... Read More

Truck Wash Business Case Study

Often smart entrepreneurs look for out of the way businesses,... Read More

Dealing With a Crooked on the Take Government Worker

Many government department heads are on the take. Oh they'll... Read More

How to become a Career Coach for Profit

A career coach could be simply defined your job seeking... Read More

Postcards Make It Rain Referrals

One of the simplest ways to expand your marketing efforts... Read More

11 Things Small Business Owners Can Learn From Rudy Giuliani

1. Leadership Is Learned ? While many people appear to... Read More

Combating Over Regulation of Small Business

Many small businesses do quite well due to the blood,... Read More

tidy up service Buffalo Grove ..