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://mba-open-university.net.

    top rated cleaning service Lake Forest ..
    In The News:

    NASA's Perseverance rover discovers shiny metallic rock on Mars that could be a meteorite from an ancient asteroid, containing high levels of iron and nickel.
    Holiday scams spike during Black Friday and Cyber Monday as criminals exploit your leaked personal data. Learn how to protect yourself from fake stores and phishing.
    Commerce Department proposes TP-Link router ban over Chinese security risks. Learn how this potential prohibition could affect your home network and devices.
    Hyundai AutoEver America suffered a data breach affecting 2,000 current and former employees, exposing names, Social Security numbers and driver's license information.
    Washington court rules automated license plate reader images are public records, even when stored by vendors like Flock Safety, setting precedent for transparency.
    Fake airline texts claiming flight cancellations are targeting travelers with convincing scams. Learn how cybercriminals steal personal data and credit card info.
    Discover how iOS 26's new Adaptive Power feature automatically extends iPhone battery life by learning your usage patterns and adjusting performance intelligently.
    New TikTok malware campaign tricks users into running PowerShell commands that download Aura Stealer, which steals credentials and authentication tokens.
    Gaia Family offers fixed upfront pricing for IVF cycles with unlimited embryo transfers and financial protection, partnering with over 100 U.S. fertility clinics.
    The Jetsons Act aims to position Pennsylvania as a leader in advanced air mobility by establishing regulations for hybrid ground-air vehicles.
    Fake Geek Squad invoice emails are targeting users with convincing charges and urgent phone numbers to steal personal information and money.
    Fox News Digital's artificial intelligence newsletter digs into a robot in Russia that faceplanted, George Clooney's alarm and OpenAI's rivalry with the New York Times.
    Major data breach at Conduent exposes personal information of 10+ million people. Government contractor hit by cyberattack affecting Medicaid, child support systems.
    Texas startup Janta Power raises $5.5M for innovative vertical solar towers that generate 50% more energy than traditional panels while using just one-third the land.
    NASA's twin ESCAPADE spacecraft launched aboard Blue Origin's New Glenn rocket Thursday afternoon from Cape Canaveral, beginning their journey to Mars with arrival expected in 2027.
    Learn how to set email reminders on iPhone and Android so you never forget to reply again. Simple built-in features help you stay organized and on top of messages.
    Discover how Apple's passkeys revolutionize Mac security by replacing vulnerable passwords with biometric authentication and encryption for ultimate protection.
    New survey reveals 78% of parents fear AI scams targeting their kids, yet nearly half haven't discussed these threats. Learn why this dangerous gap exists.
    Chrome now autofills passport and driver's license info automatically. Google's latest browser update adds official document support with encryption and user control.
    Scammers impersonate Department of Veterans Affairs employees claiming veterans owe money, but real VA communications only direct to VA.gov or official channels.
    The AltoVolo Sigma hybrid-electric aircraft flies 500 miles at 220 mph while operating 80% quieter than helicopters, featuring safety systems and compact design.
    Google search scam alert: fake customer service numbers can give scammers remote control of your phone. Learn how to spot these traps and protect yourself.
    Electric vehicles overtake gas cars in total CO2 savings after just two years of driving, with emissions benefits growing over time as power grids get cleaner.
    Louvre Museum reportedly used "Louvre" as password for surveillance system during $100M jewel heist. Learn how weak passwords put even famous institutions at risk.
    Bipartisan AI jobs bill from Sens. Hawley and Warner would require companies to report AI-related layoffs and hiring to Department of Labor quarterly.
  • Change Your Word Docs in Record Time!

    Anyone who has ever used Microsoft Word knows that it... Read More

    Where to Find Free Fleet Maintenance Software

    Costs of fleet maintenance software can vary widely. It is... Read More

    7 Things to Consider Before Buying Small Business Accounting Software

    The world of small business accounting software can be a... Read More

    Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

    I've been active in the Cisco Certification track for four... Read More

    Software Upgrades Arent Always the Best Move

    When my daughter was getting into AOL instant messaging (AIM)... Read More

    Outlook... Not Just for Email! Using Your Outlook Calendar

    Microsoft Outlook is one of the most widely used software... 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

    Microsoft Great Plains: Large Scale Implementation

    Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

    Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

    This is a short article, written in question/answer/FAQ style to... Read More

    Lotus Domino: Application Integration ? A Programmer View

    There are two approaches for application integration:? Programmer's approach ?... Read More

    Blind CC (Bcc): Master Its Use When E-Mailing

    If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

    Pros and Cons of Using FREE Software in Your Business

    It???s easy to understand why you might be drawn to... Read More

    MCP Market News: Microsoft SQL Server & SQL Reporting Services

    Are you ready? SQL Server 2005, the next-generation data management... Read More

    Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

    IBM Lotus Notes with Domino email server is traditional document... Read More

    Crystal Reports for Microsoft Great Plains ? Overview for Developer

    Microsoft Great Plains is main accounting / ERP application... Read More

    Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

    Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

    Microsoft RMS Customization ? PO Items Receiving in Great Plains

    Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More

    Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

    Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

    Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

    Microsoft Great Plains serves majority of US based horizontal and... Read More

    Microsoft CRM Customization - Processing In/Out-Going Email Messages

    We would like to give you several situations, when you... Read More

    Instant Messaging is a Sweet Way to Communicate

    MSN messenger is a pretty cool invention. I mean I'm... Read More

    Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

    Microsoft Business Solutions Great Plains has I'd say end user... Read More

    Software Tools To Help Your Business Sell More

    Sales are all about leverage, because there is only so... Read More

    Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

    Microsoft Great Plains might be considered as ERP platform to... Read More

    Microsoft CRM Customization Secrets ? Second Edition

    This article is for advanced Microsoft CRM SDK C# developers.... Read More

    insured cleaning company Morton Grove ..