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.

    custom home cleaning Lincolnshire ..
    In The News:

    Amazon Prime Day shoppers face threats from 120,000-plus scam websites as cybercriminals prepare phishing traps and malware ahead of the July sales event.
    Fox News' AI Newsletter brings you the latest on this rapidly evolving technology.
    The AEON humanoid robot tackles labor challenges with Nvidia AI, Microsoft Azure cloud and advanced spatial awareness, working alongside industry leaders Schaeffler and Pilatus.
    Google's Ask Photos feature brings AI-powered searches to your photo library, letting you find memories with natural language queries while maintaining privacy controls.
    The return of blue book exams emerges as universities fight widespread AI academic dishonesty and educators debate whether to ban AI tools or teach responsible usage.
    Signs your phone might be hacked include strange behavior, unauthorized texts, battery drain and pop-ups, while protection involves updating software and avoiding public Wi-Fi.
    Tokyo startup H2L has launched Capsule Interface technology enabling full-body robot control with muscle sensors, offering immersive remote operation.
    The A.I. industry seems set for growing pains as Big Tech companies scramble for solutions to the medium's unprecedented strain on the power grid.
    Fourth of July fireworks cause a 60% spike in lost pets, but GPS trackers and AI photo-matching services like Love Lost can help reunite missing dogs with their families.
    Protect yourself from jugging, the rising crime by which thieves monitor ATM users and follow them to steal cash, with six practical safety tips to stay alert and secure.
    U.S. airlines like Delta, American and United are selling your domestic flight records to government agencies through the little-known Travel Intelligence Program.
    Autonomous robots from Uber Eats are rolling out across U.S. cities, featuring LIDAR sensors, secure compartments and all-weather operation for food and grocery delivery.
    Costco has expanded into EV infrastructure with new ultra-fast charging stations that can charge most electric vehicles to 80% in 20-60 minutes while shoppers browse the warehouse.
    The new Gemini Robotics On-Device AI allows robots to perform complex tasks without internet, offering enhanced privacy, reliability and adaptability for real-world use.
    Protect yourself from Amazon phishing scams by spotting red flags like suspicious sender addresses and spelling errors while using Amazon's Message Center to verify communications.
    GAC Group's new Govy AirCab flying car combines lightweight design with advanced safety systems and smart cabin technology to revolutionize city travel with an 18.6-mile range.
    The Berkeley Humanoid Light (BHL) is a lightweight, open source humanoid robot that anyone can build using 3D-printed parts and off-the-shelf components.
    Meta’s new AI chatbot is getting personal, and it might be sharing more than you realize.
    A new threat targets both Android and iPhone users: SparkKitty, a powerful mobile malware strain that scans private photos to steal cryptocurrency recovery phrases and other sensitive data.
    Thanks to a team at the University of California, Davis, there's a new brain-computer interface (BCI) system that's opening up real-time, natural conversation for people who can't speak.
    Privacy risks are hiding in plain sight, as your personal data is likely being collected, tracked, and sold without your knowledge.
    VenHub, a fully autonomous, AI-powered smart store just opened at the LAX/Metro Transit Center in Los Angeles.
    A woman's Facebook account takeover reveals dangerous social engineering tactics and provides lessons on recovery, avoiding scams and enacting stronger security measures.
    Shanghai engineers are using 432 walking robots to relocate a complex, preserving Shikumen architecture while creating space for a modern underground hub and cultural center.
    Major healthcare data analytics firm Episource had a cybersecurity incident exposing 5 million patients' medical records and personal information in recent breach.
  • Reloading Windows XP

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

    Algebra Help Software

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

    MCP Market News: Microsoft SQL Server & SQL Reporting Services

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

    Linux vs Windows Operating Systems

    With so many Microsoft Windows related viruses, errors, and other... Read More

    Groupware and Online Collaboration: Collaboration Series #4

    This article is the fourth of a series of articles... Read More

    Microsoft Great Plains BR: Bank Reconciliation

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

    Downloading Spyware Removers: Think Before, not After

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

    Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

    Logistics automation is often considered as barcoding extension to Sales... Read More

    10 Ways to Learn a Software

    Following tips help you to learn a software in lesser... Read More

    How to Upgrade Dexterity Customization ? Tips for IT Manager

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

    Groupware: What Works the Way Businesses Do?

    GroupwareThe internet is full of 1.5 million to 7 million... Read More

    DB Integration - Software for Combine MS Access Databases

    Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

    Spyware Protection: A Must for Any Home Computer

    Now that spyware is the single most dangerous threat to... Read More

    When is a Software Engineer Not a Software Engineer?

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

    Reduce Pop-ups and Annoying Ads

    There is many things more frustrating than surfing a website... Read More

    A Symons Mark II Function Point Counting Example

    I provide, here clear explanations and a count of function... Read More

    Software For Your Hard-Drive

    All your software is stored on a hard-drive. But how... Read More

    Microsoft CRM Customization ? Programming Closed Email Activity

    Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

    Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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

    Adware, What Is It?

    Adware is a type of Spyware program that displays some... Read More

    Fundraising Software ? How Can That Help Me?

    Fundraising software lets you connect with donors in a way... Read More

    Preventive Maintenance Software Companies

    Several software companies design programs for preventive maintenance. Most of... Read More

    QuarkXpress Tips: How to Move Content Between Print and Web Layouts

    Since its release in 1987, QuarkXpress had made an immediate... Read More

    Screenshots Vista Windows

    Features Additionally, Vista will include many other new features.Aero Vista... Read More

    Microsoft Great Plains Upgrade ? Things to Consider and FAQ

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

    move in cleaning service Glencoe ..