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 Des Plaines ..
    In The News:

    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.
    Free up iPhone storage fast by clearing large photos and videos from Messages app. Simple steps for iOS users to delete attachments without losing chats.
    Scammers are flooding inboxes with fake tracking alerts that mimic real carriers, exploiting the holiday rush to steal logins and personal data.
    The Fox News AI Newsletter brings you the latest news on AI technology advancements and the challenges and opportunities AI presents now and for the future.
  • DVD Burning Tips

    CD and DVD replication is a process that works by... Read More

    Getting Technical Support Help Online

    Sometimes your PC will start acting strange for no apparent... Read More

    Increase Office Efficiency With One Simple Tool

    When you need a phone number, you do a quick... Read More

    Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

    Microsoft Great Plains has substantial mid-market share in the USA... Read More

    Enterprise Resource Planning Overview

    ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

    Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

    Microsoft Business Solutions is now in process of creating so... Read More

    Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

    Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

    Three Steps To Windows Safety Heaven

    Now there are Three Steps To Heaven Just listen and... Read More

    How To Avoid Getting Hooked By Pfishing

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

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    Microsoft Great Plains Customization Tools ? Overview

    Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

    Spyware - The Internet Devil Of Our Times!

    Spyware and Adware infest over 90 percent of computers in... Read More

    Corporate ERP Selection: Microsoft Great Plains

    In our opinion, traditional approach when you select ERP/MRP system... Read More

    Crystal Reports for Microsoft Great Plains ? Overview for Developer

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

    How To Choose A Fire Wall Software Program

    In the real world a "fire wall" is a fireproof... Read More

    Start Developing Your Own Software

    Learning how to program software seems like a daunting task... 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

    Downloading Spyware Removers: Think Before, not After

    Just imagine: you are walking, say, towards your car, and... Read More

    Microsoft CRM Programming Secrets ? Tips For Developers

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

    Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

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

    Groupware: Avoid the Ad Hoc Shuffle

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

    Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

    At the end of XX century, in the late 1990th... Read More

    Free PDF Publishing Software

    In a previous article, I wrote about OpenOffice... Read More

    Create A Flash Presentation For Free With Open Office

    The intentions of this short tutorial are not to teach... Read More

    Great Plains Dexterity Customization Options ? Overview For Developers

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    bathroom cleaning service Lake Forest ..