Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Do You Want Your Own Fully Programmable ERP? - Part 2 > NetSparsh - Viral Content you Love & Share

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://erp-enterprise-resources-planning-courses.us.

johnncmelo@yahoo.com

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Forbes

Amazon Launches A Site Just For Small Businesses...And Other Small Business Tech News This Week
Forbes
Here are five things in technology that happened this past week and how they affect your business. Did you miss them? 1 — Amazon launches a small business shop. This week, Amazon launched Amazon Storefronts—a new section of its site that only lists ...


Portland Tribune

Small business, big opportunities
Portland Tribune
Small business development is central to what we do at the Portland Business Alliance. Nearly 80 percent of our 1,900 member businesses have fewer than 50 employees. At the Alliance, our small business members have a seat at the table at board ...

and more »

Business.com

How to Make the Cloud Work for Your Small Business
Business.com
The concerns small businesses have about moving to the cloud are not as big problems as you might think. There are several ways to suit the cloud to benefit even the smallest business. If you're a small business, it's tempting to dismiss cloud storage ...


The Mountaineer

Small Business Center to hold free seminar, 'Choosing Your Small Business Legal Structure' Oct. 2
The Mountaineer
The Small Business Center at Haywood Community College will offer a free seminar titled, “Choosing your Small Business Legal Structure,” from 5-7 p.m., Tuesday, Oct. 2, in room 3021 at the HCC Regional High Technology Center. The speaker is Tonya ...


Will NY City Council Finally Take Action To Save Small Businesses From Extinction?
Gothamist
As small businesses disappear from the city, and bodegas and hardware stores and music venues are supplanted by chain drugstores and bank branches, or sit vacant for months, it's worth remembering that New York City had commercial rent controls for 18 ...


CNBC

Small business owner 'thrilled' by Trump's tariffs on China, others
CNBC
Drew Greenblatt of the National Association of Manufacturers is actually hoping that a result of the new tariffs will be better trade deals.
Small Business Owner Says Tariffs Necessary | Blue MauMauBlue MauMau

all 5 news articles »

Chamber 's Small Business Series starts Wednesday
Quad-Cities Online
During the first session focused on customer relations, attendees will identify the top three to four items related branding, marketing and sales that are keep their business from growing to the next level. Through interactive coaching, attendees will ...


Money Magazine

This Business Credit Card Gives You 2% Cash Back on All Spending. Here's Why It's the Best of 2018
Money Magazine
The best reward credit cards for business owners are ones that make it easy for you to both earn and redeem cash back, and this business credit card delivers. A lot of the small-business cards offer a slate of revolving retail categories in which ...
USAA Credit Cards: Find & Apply for Credit Cards Online | USAAUSAA

all 174 news articles »

The Missoulian

Small businesses need health care
The Missoulian
Why is health care such a dirty word with some politicians? Politicians who talk out of both sides of their mouth, on one hand saying how small businesses are the engine of economic growth in Montana, and on the other hand trying to eliminate health ...

and more »

Aviation Week

Opinion: Drones Enable Small Businesses And Help Drive US Economy
Aviation Week
Drones are creating opportunities for entrepreneurs to start new small businesses and make established small businesses services more productive. In essence, these flying robotic tools are proving beneficial to the overall U.S. economy. The industry of ...

Google News

You Are Invited

Business card size works well for invitations to special events.What... Read More

13 Steps to Protect Yourself from Your Bank

The success of your business is critically dependent on how... Read More

Are You Making These Mistakes In Your Business?

You've probably heard the statistic that 95% of small businesses... Read More

Building Marketing Momentum For Your Small Business

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

The PR Commitment to Small Business

We're birds of a feather, public relations and small business.... Read More

The Step Zero Effect

The key to organizational focus and helping those who need... Read More

Finance Your Small Business: So Much Money, So Little Time

$37.4 million funded from venture capital today. $86.4 million funded... Read More

Creative Business Card Marketing

Announcements can be handed out as a business cardAnnouncements can... Read More

Expanding A Mobile Car Wash Business

What is the best time to expand a mobile car... Read More

Employee Monitoring - Business Risks For Employers And How To Avoid Them

E-mail and Internet use are integral parts of the typical... Read More

How to Define Business Objectives

Why does a good business relationship rely on having some... Read More

Family Business and Conflicts

What is a Family Business? A family business is basically... Read More

Environmental Pressure Washing in Pennsylvania

If you run a mobile car wash, mobile fleet washing... Read More

Do Your Best; Hire the Rest

One of the hidden perks of raising six children is... Read More

Small Business Success: Thriving During Change (And Landing On Your Feet!)

If I had $1.00 every time I heard someone say... Read More

10 Hiring Tips for Small Business Owners

As a successful small business owner,you're accustomed to long hours;... Read More

The Wrap on Ag Plastic

While driving through Pennsylvania farmland, you have probably noticed an... Read More

Mini-Blind Cleaning Business, Case Study

Sometimes the simple businesses are the ones, which make good... Read More

How to Achieve Real Success in Business: Five Breezy Tips

Achieving real success should be the goal of any good... Read More

Small Business Publicity -- Worth It?

You bet it's worth it. Publicity via news releases, along... Read More

4 Areas Where Your Business is Losing Money

In my 18 years of consulting I have heard it... Read More

A Portable Trade Show Exhibit Makes for an Easier Show

You can make your trade show experience much easier by... Read More

Do You Microbifer in Your Cleaning Business?

Microfiber cleaning towels have been around for about ten years... Read More

Franchising VS Business Opportunity; What is the Difference?

The modern Franchise business model and the much different business... Read More

Success Tips for Small Business Owners

Running a small business requires many skills. However, to do... Read More