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.

    bathroom cleaning service Northbrook ..
    In The News:

    Learn how to act against cybercriminals in 2026 with essential security steps like two-factor authentication, software updates and credit freezing.
    Choose between OpenAI releasing Sora text-to-video model, the AI race heating up, or Waymo driverless cars launching in cities across the country
    Learn how to set up Google Maps and Apple Maps on your phone to automatically remember where you parked. Step-by-step instructions for enabling location services and parking detection.
    Phishing scammers use rnicrosoft.com domain to impersonate Microsoft by replacing "m" with "rn" in typosquatting attacks that steal login credentials.
    OpenAI announces new teen safety rules for ChatGPT users under 18, blocking romantic roleplay and requiring extra caution on body image topics.
    A 2025 data breach at fintech company 700Credit exposes personal information of more than 5.8 million people through compromised third-party integration partner.
    Retailers lose $76.5 billion annually to return fraud as nearly 10% of U.S. retail returns involve fraudulent activity, with $850 billion in returns expected in 2025.
    ShinyHunters claims responsibility for stealing 94GB of Pornhub user data affecting over 200 million records and demands Bitcoin ransom.
    ChatGPT 2025 now connects to Apple Music, Canva, Expedia, TripAdvisor and OpenTable through built-in apps that help users create playlists, design graphics and more.
    Apple releases emergency patches for two zero-day vulnerabilities actively exploited in attacks. iPhone and iPad users urged to update immediately.
    DoorDash launches Zesty, an AI-powered social app that recommends restaurants through conversational search, now testing in San Francisco and New York.
    Cybersecurity firm Infoblox reveals that over 90 percent of parked domains now redirect visitors to scams and malware, making simple typos extremely dangerous.
    The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents now and for the future.
    GPT-5.2 is now live for all ChatGPT users with improved coding, writing and image interpretation, with Kurt Knutsson offering his review.
    New iPhone replacement scam uses pressure tactics and fake carrier calls to steal devices from buyers. Criminals claim shipping errors and demand urgent returns.
    Amazon Ring's new facial recognition feature sparks privacy controversy as Electronic Frontier Foundation critics argue the AI upgrade expands surveillance risks.
    New Android banking trojan Sturnus steals credentials, reads encrypted messages and controls devices.
    Denmark's 3D-printed student village proves automation builds 36 apartments faster than traditional methods. Skovsporet project shows housing future.
    Discover Android's new Sound Notifications feature that alerts you to smoke alarms, doorbells, and baby cries even when wearing headphones.
    New SantaStealer malware reportedly threatens holiday shoppers with password theft. This Christmas-themed info-stealer targets browsers and crypto wallets.
    The Christmas season brings a surge in Netflix phishing scams targeting shoppers with fake emails. Stacey P received convincing scam but verified account first.
    San Francisco Giants invite Jamie Grohsong to throw ceremonial first pitch at Oracle Park after he learned to play baseball with a bionic hand following an injury.
    FBI warns cybercriminals are stealing family photos from social media to create fake proof of life images in virtual kidnapping scams targeting victims.
    Instagram's new 'Your Algorithm' tool lets you control your Reels feed in real time. The app now gives you power to customize what videos you see.
    Major Marquis fintech breach exposes 400,000-plus Americans' data through unpatched SonicWall vulnerability, with Texas hardest hit at 354,000 affected.
  • Microsoft Great Plains Security Setup - Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... 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

    Marketing Your WinRunner Team

    It won't matter how effective your WinRunner Team is if... Read More

    Keeping Track

    One of the things we can be as certain of... Read More

    Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

    Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

    10 Programming Tips

    (1) Avoid using the same variable again and again for... Read More

    Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

    Crystal Reports is the most flexible tool on the market... Read More

    Great Plains DOS Support ? Notes for Consultant

    Great Plains Accounting, accounting package for mid-size and small companies... Read More

    Putting Screensavers Under Control

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

    Run Your Own Search Engine

    Our hosted solution allow you to run your own search... Read More

    Reloading Windows XP

    If you have been running Windows XP for a couple... Read More

    The Truth: Netzero 3G

    We've all seen the ads on TV for Netzero 3G.... Read More

    Microsoft Great Plains Customization: Project Organization ? International Business Example

    Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

    Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

    Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

    Microsoft CRM Implementation for Large Corporation ? overview

    Microsoft Business Solutions CRM is now approaching the phase of... Read More

    40/sec to 500/sec

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

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

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

    Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

    C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

    Benefits of Shareware

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

    Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

    Manufacturing in the USA is far away down from mid... Read More

    Accessing XML Using Java Technologies

    The most important benefit of XML is its simplicity. Though... Read More

    Lotus Domino Implementation and Development: Infrastructure ? Present and Future

    Domino server is a buffer between the operation system and... Read More

    How To Avoid Getting Hooked By Pfishing

    "Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

    Cisco Certification: Introduction To ISDN, Part V

    The major reason I recommend getting your hands on real... Read More

    Hubris - Definition: Microsofts Passport

    Before September of 1995, Microsoft ignored the Internet because their... Read More

    insured cleaning company Wilmette ..