Software Information

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.


    MORE RESOURCES:

    Business Wire (press release)

    Elliott Terminates Tender Offer to Acquire Epicor Software Corporation
    MarketWatch - Nov 21, 2008
    ... LP and Elliott International, LP (collectively, "Elliott" or "we"), a major shareholder of Epicor Software Corporation (the "Company" or "Epicor"), ...
    Epicor drops after hedge fund ends hostile bid Forbes
    Hedge Fund Elliott Associates Withdraws Offer for Epicor Software Orange County Business Journal
    UPDATE 1-Hedge Fund ends offer for Epicor Reuters
    RTT News - Barron's Blogs
    all 45 news articles


    New York Times

    The best thing about the 2.2 iPhone software update
    CNET News, CA - Nov 21, 2008
    When it some to iPhone software updates, I'm all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia ...
    First Look: Apple's iPhone 2.2 Software Hits The Street (And ... CRN
    Lots to like about new iPhone 2.2 software update Ars Technica
    Apple releases iPhone Software v2.2 Apple Insider
    G4 TV - infoSync World
    all 143 news articles


    Canada.com

    Microsoft: New software not Symantec, McAfee rival
    Reuters - Nov 19, 2008
    BOSTON (Reuters) - Microsoft Corp's upcoming security software is not designed to take sales from Symantec Corp and McAfee Inc as it is a stripped-down, ...
    Microsoft to offer free security software to attract beginners eTaiwan News
    Microsoft Plans to Introduce Free PC Security Software Wall Street Journal
    Microsoft to offer free security software NetworkWorld.com
    Washington Post - Bizjournals.com
    all 304 news articles


    Vertical Releases Feature-Rich Software Update for Wave
    MarketWatch - 20 hours ago
    ... today announced the release of the Wave 1.5 software upgrade to it's award winning Wave IP 2500(TM) Business Communications Solution, the industry's ...


    Hann’s On Software bouht by Mediware
    Bizjournals.com, NC - Nov 21, 2008
    Mediware Information Systems Inc. has bought the assets of Hann’s On Software, a pharmacy-management software provider based in Santa Rosa, for $3.5 million ...
    Mediware Acquisition Adds 320 Pharmacy Facilities MarketWatch
    Mediware Information buys assets of Hann's On Software - Quick Facts RTT News
    all 19 news articles


    PC World

    BlackBerry Storm Sales Delayed By Software Glitch? Screen Gimmick ...
    Silicon Alley Insider, NY - 41 minutes ago
    RIM's new BlackBerry Storm is proving to be popular with some people -- many Verizon Wireless stores sold out of their first batches yesterday. ...
    Software Flaw Might Cause BlackBerry Storm Shortage eFluxMedia
    Storm Is a Fun BlackBerry, but No iPhone Killer U.S. News & World Report
    8 Reasons to Pick iPhone Over BlackBerry Storm PC World
    ZDNet Blogs - engadget
    all 655 news articles


    AVG Sees Uphill Battle for Microsoft in Its Launch of Free Anti ...
    MarketWatch - Nov 21, 2008
    AVG, which for eight years has offered free anti-virus software to users worldwide, noted the multiple challenges Microsoft faces in supporting a free ...
    AVG sees 'uphill battle' for Microsoft Morro TechRadar UK
    Microsoft Announces Upcoming Events for the Financial Community NewsBlaze
    Microsoft Announces Upcoming Events for the Financial Community MarketWatch
    all 30 news articles


    ITProPortal

    Microsoft’s Mike Neil Keynotes at SYS-CON's 4th International ...
    SYS-CON Media, NJ - 20 hours ago
    ... Black Duck Software, Blackbaud, Blade Network Technologies, Blue Coat, Blue Lane, BlueArc, BlueNote Networks, BluePheonix Solutions, BMC Software, ...
    Teaching Everyone to Speak Big Blue New York Times
    IBM To Acquire Virtualization Specialist Transitive InformationWeek
    IBM To Buy Virtualization-Software Company Transitive NewsFactor Network
    eWeek - SearchDataCenter.com
    all 95 news articles


    Frankly speaking, speech software better but still not great
    Seattle Times, United States - 12 hours ago
    Getting a computer to turn your speech into words on the screen requires buying expensive, resource-intensive software and mastering a sometimes confusing ...


    Microsoft purges phony security software from 1 million PCs
    Computerworld, MA - 23 hours ago
    Windows users have been plagued with a flood of worthless security software in recent months as criminals have discovered that they're money-makers. ...

    Software - Google News

  • home | site map
    © 2006