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.

    no-contract cleaning service Glenview ..
    In The News:

    A new phishing scam targets family photos with fake "Cloud Storage Full" alerts. Criminals steal credit card information through fake sites. Learn protection tips.
    South Korean scientists create ultra-thin fabric muscles that turn clothes into robotic assistants, lifting 33 pounds while weighing under half an ounce.
    Archer Aviation has acquired Hawthorne Airport for $126M to launch an LA air taxi network ahead of the 2028 Olympics, featuring AI-powered eVTOL operations and next-gen aviation tech.
    Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
    Fake AI apps disguised as "ChatGPT" and "DALLĀ·E" are flooding app stores with dangerous malware that steals data and monitors users without detection.
    Fake buyers demand specific vehicle reports from unknown sites to steal credit card information from car sellers, but warning signs can help identify these scams before paying.
    Android users can now manage apps across multiple devices more easily with Google Play Store's updated remote uninstall button in the latest update.
    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.
  • Hear It in Digits

    Music downloads are off the charts! We're listening to digital... Read More

    Algebra Help Software

    Need help making sense of algebra? Have algebra lectures in... Read More

    Need of Document Management System (DMS)

    Document Management or Enterprise Information Management is perhaps one of... Read More

    Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

    Microsoft Business Solutions Great Plains has substantial market share among... Read More

    Microsoft CRM Integration & Customization: SharePoint Document Gateway

    MS CRM is very close to document workflow automation, including... 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

    Groupware: Avoid the Ad Hoc Shuffle

    GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

    How to Tell You Have Spyware, Ad-ware or Viruses

    Usually, the easiest way to tell you have spyware is... Read More

    Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

    Microsoft Business Solutions Great Plains is mid and even corporate... Read More

    Windows Screensavers Explained

    In this article you will find some background information about... Read More

    Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

    Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More

    Make 2005 the Year You Save Time!

    Today's business world is fast-paced. No matter what it is... Read More

    Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

    Putting Screensavers Under Control

    No matter how much you enjoy your favorite screensavers, sometimes... Read More

    Microsoft Great Plains Security Setup - Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... Read More

    MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

    If you look back to the history, you will see... Read More

    Great Plains Dexterity History and Programming Overview

    As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

    Collaboration Software: Index of Collaboration Software Technologies

    Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

    Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

    It would be easy to think, like most people apparently... Read More

    Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

    If you are software developer or database administrator - we... Read More

    What is Fleet Maintenance Management?

    Fleet Maintenance Management is a critical position in any company... Read More

    Great Plains Dexterity ? Microsoft Great Plains Customization Overview

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

    When is a Software Engineer Not a Software Engineer?

    The title of "software engineer" has got to be among... Read More

    Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

    Currently Microsoft Business Solutions is on the way of creating... Read More

    Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

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

    house cleaning company Glencoe ..