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

We are in a transition phase in the Managerial Administration models of any company or Government, because three factors are summing for that:

  • The new powerful business Information Technologies and its more and more smaller costs, like ERP, CRM, BI, etc.,

  • The creativity of the new MBA to generate value and its corresponding engineering - for example, Feedback Control System - in the administrative and managerial fields,

  • Several different layers in the companies in what refers to its managerial and administrative automation levels.

    This created not very orthodox solutions, and one of them is the installation of a Front-End System above the Transational System already existent in your company that - by any reason - cannot be substituted by a "pure" ERP System.

    Inside the existent tools and for reasons that will be exposed, we choiced the IBM Lotus Notes software for that purpose, briefly Notes as it's widely known.

    The Notes has the following programmable structures that can be used to change and to use in a Front-End System of any online managerial or accounting System that already exists in your company, like ACCPAC/SBT, Macola and others 150 companies:

    • It can be integrated into the Internet, to enlarge the area of the DAS/DDC functions at the regional, national or world levels.

    • He has the so called Replication, that allows the Head office of a company in New York to change an only field in its local database, and automatically and in Real-Time that same field assumes the same value in the local database of a Branch in Chicago or Tokyo. And vice-versa. That means to have a national database - or regional or world - and not only local. This Replication can be programmed, a field or a group of fields can be Replicated or not, in agreement with the goals of the company.

    • Theoretically that would create problems - for example, simultaneously an operator in New York change the content of the local field "m" and an operator in Chicago change the content of its same local field "m" - but Lotus Notes will solved this problem in a transparent way to both users with the use of the Replication, and the conflict doesn't exist.

    • Therefore, concisely we are speaking about an only online national database and in Real-Time.

    • He has an own Intranet e-mail System and/or through the Internet. This e-mail System differs from the traditional ones because he could be integrated automatically with the Notes database. For example, he can be programmed to send an e-mail to other operator, if - a condition - the field "m" of the database reach the value of "x". Or any input/output field of any mathematical model.

    • It allows to create sophisticated electronic Forms, to be used by its Workflow. The whole operational flow of a company - besides at the national or world levels - can be executed through this electronic Forms - freely created and scheduled - which can also be integrated in the e-mail System.

    • The whole management approvals flow can be programmed through the Notes Workflow.

    • Its Agents automatically can detect operational conditions in order to generate the corresponding actions. By corresponding actions understand any administrative or managerial functions in Real-Time, DAS or DDC or both.

    • He has its own methods to acquire data and/or information from the Back-End Transational System using any ODBC System and also it's possible to use several Add-Ons softwares for that purpose. Evidently if Notes will be used as a Font-End System above the Transational System of the company, he obligatorily should have means to acquire/send data from/to the Transational System, in Real-Time or not.

    • He has its Script Language, for general programming of its commands, its functions, etc.

    • He has a hierarchical Password System for controlled accesses to its Views, Forms, Agents, etc.

    • Through its Views can transform the original data of the Transational System into high level information.

    • Its Views are totally programmable - its columns are similar to the used un the spreadsheets - and they can be scheduled to have relationships with any other Views.

    • Its Views are very similar to the Visual Basic Views - as a matter of fact already exists Add-Ons for the interconnection between Notes and Visual Basic.

    • Its Views allows you to integrate in a column any mathematical functions or logical combinations as AND, OR, equality, larger than, smaller than, etc., and several other functions.

    However is possible to use any System with the same capabilities of the Notes - specially with ODBC, Replication, Views and integrated e-mail - as a fully programmable ERP System.

    In this first article we mentioned some capabilities to be used in a Front-End and in the next we will explain how to do your ERP Front-End.

    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.

    In The News:


  • pen paper and inkwell


    cat break through


    MySQL for Beginners ? How to Create a MySQL Database

    Whether you are an experienced web programmer or a complete... Read More

    How the Firefox: How to... Manual Helped Me

    A few months back I really got sick of my... Read More

    Benefits of Shareware

    Shareware has been fighting the stigma of being misunderstood for... Read More

    RFID: Strengthen the Position for SAP; United States

    SAP Inc., a global leader in client/server enterprise application software... Read More

    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    Software Piracy - Global Increase

    Pirated software is on the increase and now accounts for... Read More

    Adware and Spyware Blockers

    The most important things you can do for your computer... Read More

    C++ Tutorial 2, Input and Variables

    This is the tutorial where we really get into programming.... Read More

    Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

    If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

    Review of TikiWiki Content Management System

    TikiWiki is open source software - it is written in... Read More

    SyncUp ? A File/Folder Synchronizer For Windows

    SyncUp, a file synchronizer is designed to assist the home... Read More

    Microsoft CRM Customization

    Microsoft CRM customization techniques are very diversified and based on... Read More

    Microsoft Great Plains Integration Manager ? Advanced Techniques

    Great Plains Integration Manager scripting and translation - overview for... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

    Microsoft Great Plains fits to majority of horizontals and retail... Read More

    A Case Study on Selecting Contract Management Software

    Professional services firm cuts costs and improves productivity with integrated... Read More

    Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

    Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

    Microsoft Great Plains Integrations ? Retail Management Sample

    Microsoft Business Solutions is emerging as very attractive vendor for... Read More

    Vlans

    In order to implement VLANs in a network environment, you'll... Read More

    My Experience - Making a Vision into Reality

    Disclaimer: All the thoughts expressed are my views only! Your... Read More

    Microsoft Great Plains ? Licensing & Product Versions

    Current Microsoft Business Solutions Great Plains has more that 10... Read More

    40/sec to 500/sec

    IntroductionSurprised, by the title? well, this is a tour of... Read More

    Microsoft Great Plains as ERP and Microsoft CRM as CRM

    If you have Microsoft Great Plains and support it for... Read More

    Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

    As we could imagine, if you are reading this article... Read More

    Databases ? How We Love to Hate Them!

    You've finally created databases that you can actually use to... Read More

    S is for Spying, Surveillance -- and for Software as Well

    Words we choose to describe things and phenomena often show... Read More

    About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

    The Microsoft system preparation utility for Windows 2000 is a... Read More

    Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

    Microsoft Business Solutions Great Plains is very generic accounting application... Read More

    Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

    Many reasons made GBM a unanimous choice for experts, one... Read More

    Performance Tuning of a Daffodil DB / One$DB -JDBC Application

    This article illustrates the best practices to improve the performance... Read More

    Microsoft Great Plains GL: General Ledger ? Overview For Consultant

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    C++ Function Templates

    C++ Function templates are those functions which can handle different... Read More

    Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

    This is intermediate level SQL scripting article for DB Administrator,... Read More

    Microsoft Great Plains eCommerce: overview for developer

    Microsoft Business Solutions Great Plains was designed back in the... Read More