Running Adempiere on Tomcat (Experimental only!!!!)

tomcat

Pre-requisites

We have only tested against an adaxa internal build 1.03  (code in the Adaxa branch on Sourceforge).  We expect that it should work against Adempiere 3.60 and 3.70 but we have not tested. If  you wish test against the Adaxa 1.03 build then it can be downloaded from here.  Datebase for Adaxa 1.03 can be downloaded from here.

Installation

  1. Download attached file tomcat.zip and save in adempiere home directory
  2. extract tomcat.zip
  3. if new install, RUN_setup.sh to do initial configuration
  4. edit AdempiereEnv.properties
  5. change ADEMPIERE_APPS_TYPE=tomcat
  6. add ADEMPIERE_TOMCAT_DEPLOY={ADEMPIERE_HOME}/tomcat/webapps (substituting appropriate value for {ADEMPIERE_HOME}
  7. RUN_silentsetup.sh
  8. run ADEMPIERE_HOME/tomcat/bin/startup.sh to start tomcat (or shutdown.sh to shutdown)

Adempiere ZK interface will be available at url http://localhost:8080/adempiere

Adempiere monitor application at url http://localhost:8080/adempiere/adempiereMonitor

Adempiere home page at url (with link for webstart) http://localhost:8080/adempiere/adempiere.html
(note other links on that page are broken)

Post Installation

  • Set Server Email under Client window to FALSE
  • Enable Client side accounting engine in System Configurator with CLIENT_ACCOUNTING=’I’.
  • Make sure all Report & Process entries are Server Process = FALSE

*Note:  WebStore, Mobile UI, and old html UI are not deployed.  Webstart client will download and run, but database connection must be manually configured.

We repeat: this is provided for experimental purposes. It is not production code.

1. Usability

1. Usability

ADempiere Core Commands

This document introduces the user to the basic operation of ADempiere including the window toolbars, menu structures and workflow buttons.

ADempiere Commands

User Interface

This document gives an overview of the ADempiere User Interface for the Windows interface and the HTML (browser) interface.

How to – User Interface

Achieving Tasks in ADempiere

This document provides an overview for using the ADempiere system including working with data records, searching, navigation and printing.

How to – Achieve tasks in ADempiere

Excel Pivot Tables

This document details how to use Excel Pivot Tables to analyse data stored in ADempiere. This article was written some time ago and many of the references to system sizes and capability are now outdated. However this in no way detracts from the overall content of the article.

How to- Excel Pivot Tables

eGility

This document details how to install and customise eGility the eCommerce solution for ADempiere ERP.

How to-eGility

2. Configuration

2. Configuration

Adaxa Implementation Methodology

This document details the Adaxa approach to System Implementation and management of complex projects using SMART objectives (Specific, Measurable, Actionable, Realistic and Time-Bound) to ensure that a project’s strategic objectives and functional requirements are thoroughly planned, managed and realised in production.

HowTo Implementation Methodology – Version 2017-12

Adding User Accounts

This document covers the procedures for adding user accounts to ADempiere, allocate one or many Roles to the user account, password management and how the new user can login to the system and selecting a role based on their credentials. Also shown is the Window that needs to be maintained by the System Administrator so that ADempiere can connect to an organisation’s email system so ADempiere users can send email from within the application.

HowTo – Add Users 2013

Bare Metal Install of Adaxa Suite

This guide documents the procedure for setting up the Adaxa Suite ‘Bare Metal’ demonstration installation including hardware requirements, operating system configuration and virtual machine setup. Please note Adaxa markets the ‘Adaxa Appliance’ which is a pre-configured hardware platform suitable for proof of concept/ boardroom pilot testing.

Howto Bare Metal Installation of Adaxa Suite

Counter Documents Configuration

This HowTo guide introduces the ADempiere concept of Counter Documents with a detailed worked example. Counter Documents streamline the generation of pre-defined document types between organisations within the ADempeire client.

HowTo – Configure Counter Documents

Standard Costing

This document details the Standard Costing methodology in ADempiere using a worked example of a business with fast moving inventory.

How to- Standard Costing

UOM Conversion

This document explains how Unit of Measure (UOM) conversions are configured in ADempiere.

HowTo – UOMconversion2

Data File Importing In ADempiere

This HowTo Guide shows the standard data import process used in the ADempiere system typically for loading data prior to go-live and also for importing items such as Orders and Invoices from other external data sources. As an example of the import process, the document shows the matters to be considered in importing Product data.

HowTo – Data File Importing in Adempiere

Import Currency Rates

This spreadsheet template defines how to setup data for importing into ADempiere for maintaining currency exchange rates.

HowTo – Import Currency Cross Rates

Import GL Journals

This spreadsheet details the method for setting up the Import Loader Format for importing GL Journals into ADempiere.

HowTo – Import GL Journals

Ad-hoc Data Importation

This document details the usage of the additional importers and shows step-by-step the process to load data into ADempiere tables using Adaxa’s generic data import functionality.

HowTo – Ad-hoc Data Importer

3. Financials

3. Financials

Accounting Structures

This document details the Accounting Structures of ADempiere including the Accounting Schema, Elements, Accounts and Costing & Tax Rules.

Financial Reports & Report Cube

This How To guide investigates creating financial reports in ADempiere as well as detailling the ‘Report Cube’ functionality that allows for the creation of highly summarised data using user-selected dimensions. The Report Cube can be used as a source of data for the Financial Report Writer module or the data can be exported using the Cube Viewer.

Creating Summary Reports

This document explains ADempiere’s architecture that automatically provides a reporting function on all tables of information that are accessible to a User in the system. This Report capability is referred to as the List Report Writer. The List Report Writer produces reports which display one line per row/record in the table being reported on. Sometimes it is desirable to suppress some of the detail by “rolling up” a series of items into a single report line. This can be done quite easily by adding a view to the database which pre-summarises the data as required. This view can then be reported on using the standard ADempiere

List Report Writer.The following guide is produced to show the steps required to set up summary reporting on the general ledger transactions stored in the FactAcct table. The guide includes screen shots of each window visited to make the necessary changes.

Drill Down & Across Reporting

This guide details how ADempiere’s architecture automatically provides a reporting function on all tables of information in the system that is accessible to a User. The Reporting functionality in turn provides the functionality to enable export of information to a variety of formats including spreadsheet formats.

In ADempiere this reporting capability is referred to as “Drill-Down” and Drill-Across” functionality. Knowledge of this functionality is fundamental to the effective use of ADempiere.

Manual Bank Reconciliation

The purpose of this document is to explain the process of manual bank reconciliation in the ADempiere ERP system. By manual bank reconciliation we mean either where the Payments have already been entered into the system by manual posting, Payment Selection for paying vendors in bulk or importing from a CSV or similar downloaded from your bank. It is also possible to create payments by code by creating your on bank statement import class. This case is not considered in this document.

Reconciliation Module

This guide explains how Adempiere uses a series of clearing accounts in the processing of documents. Examples of these clearing accounts are:

  • Bank-in-Transit
  • Payment Selection / Unallocated Customer Receipts
  • Goods Received but not invoiced
  • Goods invoiced but not received
  • AP and AR control accounts.

The characteristic of these accounts is that a debit will be created in the suspense account and at a later date/time a matching credit will be created clearing the balance back to zero. In some case the credit is created and followed by a debit. The balance of the account at any time will consist of those transactions for which the offsetting transaction had not been posted at the selected date, or both are posted and there was a mismatch in the values. In clearing accounts with many transactions it can be quite complex to determine which transactions form the balance of the account. This module is designed to simplify these reconciliation tasks.

Non-Vendor Payments

This HowTo guide describes the way in which Adempiere ERP & CRM can be used to process non-inventory related payments. Many expenses and some revenues will appear in the company’s accounts that do not relate to inventory purchases. These exepnses (and some revenues) will typically affect accounts unrelated to inventory. Examples of such transactions are Payroll transactions, Dividends, BAS and Income Tax Payments, Transfers between bank accounts, Loans from parent companies and utility bills. Payments which are not inventory purchases will typically be allocated to a Charge.

Credit Card Transactions

This how-to document suggests a number of ways of managing the processing of credit card transactions in ADempiere. Credit Card transactions can occur due to employee expenses, paying vendors by credit card and receiving customer payments by credit card. Each of these processes is explored. Credit Card transactions raise a series of issues by employers which can be addressed in a number of ways. The most common issue is a need to pay the credit card company before an employee has provided all the details of the amounts spent. Companies adopt a number of methods to deal with this issue.

Foreign Currency Payments

This document explains the process used in ADempiere to enter and pay foreign currency Invoices ($USD in this example) from a bank account that is denominated in the system accounting currency ($AUD in this example).

Housekeeping and Month End Processes

The purpose of this document is to details the specific tasks that typically have to be completed for month-end close of an accounting system. All systems require a degree of administrative effort to ensure that they are running properly. The task typically falls to accounting staff since they will be the ultimate users of information that is generated by the actions and inactions of users of the ADempiere system. This document outlines some of the tasks that need to be undertaken to ensure that the system is running properly and that the accounting information is up to date.

Payment Selection

The purpose of this HowTo guide is provide instruction on the concept of ‘Payment Selection’ which allows for Adempiere to pay a batch of invoices due via automated processes determined by business rules such as payment terms, dispute status or manually.

Reporting and Listing Improvement

Adaxa has extended ADempiere reporting in the Financial report writer and List Report Writer.

Adaxa Revenue Recognition – Statement of Capabilities

Adaxa has implemented Revenue Recognition for both Time and Event based recognition requirements.

4. Specific Functionality

4. Specific Functionality

Manufacturing Light

This document details the Manufacturing Light module developed by Adaxa to extend ADempiere to meet the needs of manufacturing organisations that do not have the present need, or perhaps capability, to implement a full MRP2 compliant production system but need to manage their manufacturing capabilities.

eGility

This document introduces the eGility platform that has been developed by Adaxa to enable small & large businesses alike to run single or multiple webstores with an integrated fully functional Enterprise Resource Planning (ERP) system. With the power of ADempiere and Drupal you have access to a sophisticated which includes Supply Chain Management, Financial Management and Reporting, Customer Relationship Management and much more with an easy to use and custom branded web store.

ADempiere Mobile Application

This guide details the Mobile Application designed and developed by Adaxa for easy access to ADempiere ERP and CRM data from an iPhone or Android mobile device.

Automated Freight Calculations

The purpose of this document is to describe to describe the Automated Freight Calculation module developed by Adaxa to extend Adempiere’s standard freight handling functionality. This extension to ADempiere seeks to provide richer functionality and to allow freight to be automatically calculated and added to a Sales Order without user intervention. There are many charging algorithms used by freight companies and there will certainly be charging methods which are not addressed by this new functionality, however this additional functionality provides greater flexibility in enabling the automatic calculation of freight charges and can be further enhanced in subsequent release of the software.

Case Study – A Complex Distribution System Using Open Source Technology

This Case Study documents how Adaxa customised ADempiere to provide complex and specific functionality for an Australian based medical products distribution company. Specific functionality requirements were:

  1. Replacement of the ADempiere webstore with an open source content management system called Drupal, including a modified version of Ubercart, and its real time integration with ADempiere
  2. Integration of the client’s supply chain with the warehousing systems of a third party logistics provider
  3. Ffunctional requirements of a sixty person call centre and the integration of an Asterisk soft PABX with ADempiere
  4. Replacement of the client’s internal ‘issues management’ system with ADempiere Request functionality
  5. Migration of large volumes of data from the existing ERP system
  6. Management of complex relationships between Business Partners

Bunnings EDI

An Adaxa client has Bunnings as a major customer. Bunnings require that orders and invoices be processed via their EDI gateway. This HowTo guide is the documentation for the system built to assist the Adaxa client to transact with Bunnings from within the client’s Adempiere ERP&CRM system. The Adempiere system has native EDI functionality which was more developed around the USA based ANSI ASC X12 however the Bunning’s implementation used the UN/EDIFACT standard. Significant extensions to the native Adempiere functionality were required for the system to work effectively. There were also gaps in the
basic Adempiere functionality relating to Functional Acknowledgements which were addressed. The system has been in use for over a year and has worked reliably during that time.

Phase 1 – Planning

Phase 1 – Planning

Assemble the project team
Clarify project goals and success criteria
Detail Project Scope
Review existing business processes
Identify gaps

Phase 2 – Design – Conference Room Pilot

Phase 2 – Design – Conference Room Pilot

  • Train project team
  • Identify transaction flows
  • Map data conversion cycle
  • Evaluate and design system enhancements and/or customised requirements
  • Document reporting requirements
  • Create data integration points and data transfer design documents