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://erp-enterprise-resources-planning-courses.us.

    In The News:

    This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

    The Verge

    AI software helped NASA dream up this spider-like interplanetary lander
    The Verge
    Using an AI design process, engineers at software company Autodesk and NASA's Jet Propulsion Laboratory came up with a new interplanetary lander concept that could explore distant moons like Europa and Enceladus. Its slim design weighs less than ...

    and more »

    GCN.com

    A framework for secure software
    GCN.com
    The Business Software Alliance is creating a framework policymakers can use to develop rules and legislation related to software security, according to Tommy Ross, BSA's senior director of policy. The International Cybersecurity Policy Framework is ...


    Wall Street Journal

    Amazon, Google Poised for Race to Hire High-Tech Talent
    Wall Street Journal
    Of the more than 42,000 jobs Amazon listed, the highest concentration were in three occupations—software-development engineers, software-development managers and so-called solutions architects. Among the 14,000 jobs Google posted over the same ...
    How Google Protected Andy Rubin, the 'Father of Android'New York Times
    Google Executive on Company Walkout, Sexual Misconduct PoliciesWall Street Journal
    Square, Airbnb And eBay Just Said They Would End Forced Arbitration For Sexual Harassment ClaimsBuzzFeed News
    Wall Street Journal -CNNMoney
    all 32 news articles »

    Forbes

    Three Steps To Take Before You Commit To A Marketing Automation Software
    Forbes
    The decision is already made. You are dead set on the [fill in the blank] marketing automation software. You've heard plenty of good things about it this conference season. Its tech is so advanced, it's leading edge. Now you're telling everyone it's ...


    Investopedia

    7 Multi-Billion-Dollar Software Deals This Year
    Investopedia
    On Sunday, German software industry giant SAP announced that it was acquiring Utah-based cloud unicorn Qualtrics just before its highly anticipated initial public offering (IPO). The $8 billion all-cash deal, slated to close in the first half of 2019 ...
    SAP joins a growing list of software giants making big acquisitions in 2018: Here's a full rundownCNBC

    all 11 news articles »

    CRN

    MapR Seeks Advantage From Cloudera-Hortonworks Merger With New Software Release, Data Assessment Service
    CRN
    The software offers a common data management, security and protection model for uniform data governance – data security and management are not based on data type or access method, according to the company. Those capabilities extend to edge ...


    Zacks.com

    MAM Software (MAMS) Q1 Earnings Top Estimates
    Zacks.com
    MAM Software, which belongs to the Zacks Computers - IT Services industry, posted revenues of $9.30 million for the quarter ended September 2018, missing the Zacks Consensus Estimate by 1.61%. This compares to year-ago revenues of $8.64 million.
    MAM Software: Fiscal 1Q Earnings SnapshotLancasterOnline

    all 13 news articles »

    Chron.com

    Marin Software: 3Q Earnings Snapshot
    San Francisco Chronicle
    SAN FRANCISCO (AP) _ Marin Software Inc. (MRIN) on Tuesday reported a loss of $21.5 million in its third quarter. On a per-share basis, the San Francisco-based company said it had a loss of $3.71. Losses, adjusted for one-time gains and costs, were 77 ...
    Marin Software (MRIN) Reports Q3 Loss of $0.77, Revenues Beat; Q4 Revenue Outlook Below ConsensusStreetInsider.com
    Marin Software Inc. (MRIN) CEO Christopher Lien on Q3 2018 Results - Earnings Call TranscriptSeeking Alpha
    Free Report for MRIN - Zacks.comZacks

    all 23 news articles »

    Windpower Monthly

    New icing-detection software launched
    Windpower Monthly
    The unnamed software is also capable of making recommendations for optimising the wind farm during icing, the Canadian company claimed. Blade icing causes increased loads, reduced aerodynamics and health and safety concerns as accumulated ice ...


    Bloomberg

    Boeing, US Regulator Weigh Software Fix on 737 Max After Crash
    Bloomberg
    Boeing Co. and U.S. aviation regulators are weighing whether to issue a software fix to the 737 Max, the aircraft type involved in a recent crash in Indonesia to ensure that the plane won't dive aggressively without pilot commands. Boeing and the ...
    Boeing, FAA weigh software fix on 737 Max plane after crashCrain's Chicago Business
    FAA, Boeing study need for 737 MAX software changes after crashStreetInsider.com

    all 577 news articles »
    Google News

  • Change Your Word Docs in Record Time!

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

    3 Reasons Why Medical Billing Software is Leading the Way

    Since technology changes so quickly, it is hard to begin... Read More

    20 Extra Hours Per Week: What Would You Do?

    While I was in college, if you would have asked... Read More

    What is Groupware?

    Vince Lombardi once said that, "The achievements of an organization... Read More

    The Top 5 Wrong Reasons For Not Hiring Testers

    Considering whether or not your software company should hire a... Read More

    Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

    Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

    Groove Network. Are you in it?

    If you are in a business that passes documents around... Read More

    Free Program Removes Spyware not Detected by Premium Security Scan

    What is Spyware?Spyware monitors your surfing habits and sends the... Read More

    The True Meaning of Freeware

    The vast majority of us will have, at some point,... Read More

    Dont Choose Adobe When Working With PDF

    While Adobe is the most known maker of PDF tools,... Read More

    An Easy Way to Deal with Email Viruses and Worms

    If you feel intimidated when someone tries to teach you... Read More

    What is Fleet Maintenance Software?

    Simply put, fleet maintenance allows companies to monitor and maintain... Read More

    The Opera Alternative

    Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

    RSS: Get Notified When Your Favorite Websites Are Updated

    RSS (Really Simple Syndication) is a way for a site... Read More

    Spyware Statistics -- Whats New in May 2005?

    Although statistics often is blamed for various deadly sins --... Read More

    OEComplete ? A Personal Information Manager

    OEComplete is a utility for managing the personal information of... Read More

    The Importance of Timely Timesheets

    Whether you are a small consultancy firm, a medium sized... Read More

    Where to Find Free Fleet Maintenance Software

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

    Ukraine IT Myths Dispersed

    While Ukraine is becoming a new popular IT outsourcing destination,... Read More

    The Dreaded Paper Label - Should it be Used?

    While paper labeling CDs and DVDs may appear to be... Read More

    Microsoft CRM for Corporate Business ? Working Offline

    If your company has regional and worldwide operations, you might... Read More

    Microsoft Great Plains Integrations - Tips for Developer

    In this short FAQ style article we would like to... Read More

    Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

    Software Development in 2005 - Back to the Future

    2005 ? Back to the Future.What does the future hold?... Read More

    Review on QuarkXpress 6.0

    After almost two decades of existence, Quark has become the... Read More