Do You Want Your Own Fully Programmable ERP? - Part 2 > NetSparsh

Home
>
Small Business
>
Do You Want Your Own Fully Programmable ERP? - Part 2

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

Do You Want Your Own Fully Programmable ERP? - Part 2

Small Business Small Business