ERP LAMP

LAMP is an acronym for an arrangement of Open-Source technologies that fit together with great synergy to provide working database driven systems and database maintaining systems. By definition, wordpress and most shopping cart packages that you can install on a web-server are a LAMP application. Because of the inclusion of Apache in the recipe, LAMP is by definition, internet or intranet related, and these applications would use a browser for GUI purposes.

Modern ERP and CRM applications, even those with heavy internal firewalling and proprietary GUI software have worked for years developing a seperation between the business logic layer and the client interface. For example, the complex liturgy of calculated taxes and deductions related to the gross and net amount of a New York paycheck are the business logic segment of an ERP or accounting program. The pretty looking check on the screen of your Quickbooks program is a graphical representation of the underlying data and calculations. Once upon a time, a programming language shouldered the burden of both tasks.

In the LAMP philosophy, the PHP layer, sometimes also called the Perl layer, can be subdivided again to achieve this result. The Smarty Template system is a convenient way to do this. In the Smarty Template framework, visual elements are written in a high level html with css using only a tag to invoke business logic elements where needed. For example, the gross calculation from payroll hours, which may be the product of regular time, overtime, holiday time, vacation pay, etc. and the series of tax deductions, retirement contrbutions and health plan participation costs may be embedded in the very display of the paycheck with a single tag that instructs a web-page, before formatting the html, to invokde the gross to net.

For Example;

<head><title>Paycheck for employee {{dv_emp_id}} – {{dv_emp_name}}</title></head>
<body>{{bl_pr_gross_to_net dv_emp_id}}

Would start creating a web page (I forget to define the source for the css) but invoke business logic from the payroll modules called gross_to_net for the employee number contained in the dynamic variable dv_emp_id before creating the body of the web browser document.

LAMP ERP

Linux based open source software packages offer the richest and most rapidly evolving applications.

ERP or Enterprise Resource Planning also entails the normal accounting operations required in a small and medium sized business, the integration between the post-mortem analysis functions, planning procedures and the basic data collection and organizational functions required for a backbone business information system leave business planners wanting an integrated package of data processing functions to interface with the planning procedures.

Linux based open source software packages offer the richest and most rapidly evolving applications. That Redmond Washington vendor can enter a market and abandon it in a matter of a few years, leaving users with unsupported application software. While the life cycle for a release of a desktop operating system may be less than five years, many ERP implementation last two decades or more. Elements of major million dollar ERP software packages contain business logic with roots in the Fortran and Cobol of the 1960’s.

Certain SQL based packages lack much business logic entirely and the relatively new, but robust procedural language of the Oracle flavor, Plsql is developing and creating an inventory of business logic. But licensing costs drive information system specialists to continue to use applications based on the Unix operating system and the known source code model. These models rely on vendors like Redhat and Novell to maintain expertise at a lower cost while providing the option to ‘go it alone’ that indeed major banks and telecoms exercise.

Linux, Apache, MySql and PhP combine to provide applications for the business community, and with the use of Perl banking providers like Paypal provide incredibly robust and yet secure micro application environments that employ technology in innovative and profitable ways. But businesses that merely outgrow the Quickbooks model, which lacks the aforementioned integration desires that forward thinking business owners seek leave small manufacturers for example to look at packages of the next tier such as Peachtree, MAS-90 and even the Redmond solutions.

However, businesses might come across three very innovative vendors that use Linux as a basis, yet provide compatibility with Windows and Macinstosh for the most part. Linux in the previously mentioned telecom operations provides the least downtime, and many times Oracle has used Linux to set world records in the database transaction processing arena. For more information on visit www.pqwee.com for more information on open source modeled and Linux based LAMP ERP solutions.