Overview of Accounting in Adempiere
Alphamedia Consulting

Category Archives:Tutorial

Overview of Accounting in Adempiere


Overview of Accounting in Adempiere
Performance Analysis

In any business , ultimately will only want to know the same thing , namely ” How much money we have generated ” . This amount can vary based on the accounting rules you use. Adempiere ERP allows you to define the Accounting Schema ( accounting scheme ) in multiple ( several at once ) and ” GAAPs ” for a client .

An Accounting Schema is a combination of a national accounting standards ( eg U.S. GAAP ) , a Costing Method ( eg accrual or standard ) and currency (currency ) . Compiere allows you to define several schema Accounting bookkeeping so that you can maintain for the financial statements and data for management decision making in parallel . It also negates the troublesome work of conversion , transformation and consolidation of foreign branch and considering the easy separation of management and legal reporting ( legal reporting) .


Each Accounting Schema also defines the elements that make up the combination account for use on GL transactions . Organization and Account are required . Optionally you can also define the Business Partner , Product , Caimpaign , Project and others . In addition , Compiere allows you to define two user defined elements to accommodate the unique business profile . For example , if an account Schema defines Product and Business Partners as optional elements will be a combination Account 01-1200-2000 – Joe .



• “01″ is the Organization HQ
• “1200″ is the Accounts Payable (Accounts Payable) Element Account
• “2000″ is a Flower Products
• “Joe” is Joe Brown Inc. Business Partner.

Description displayed for this account combination would be like: HQPAYABLES_FLOWER_JOE_BROWN Inc.. You do not have to worry about what elements to be included along with each of each transaction as Adempiere will generate all accounting transactions for you automatically where Element Values ​​(element values​​) obtained / derived from transactions or from a document.


Agung Budi Santosa

Jakarta – Indonesia


ADempiere Installation on Windows


Install ADempiere 3.60LTS on Windows 7

 Download this artikel inPDF format

Adempiere ERP system installation on windows is not difficult , however, there are still many who have difficulty in installation . The following tutorial is aimed at novice users who need a step by step guide to install Adempiere 3.60 on Windows.Catatan operating system : In Windows 7 make sure you have administrator privileges
Installation preparation

Prior to the installation of Adempiere , the preparation required is as follows :
1 . Prepare a PC with specifications : Pentium 4 Processor with at least a minimum of 512 MB ​​of memory for training and a minimum of 1GB for the production , which of course if you have a computer with higher specifications , the better the results , and recommended for production use RAID hard drive system .
2 . Prepares Java JDK1.6 installation file which you can download at : http://java.sun.com/javase/downloads/index_jdk6.jsp
In our example we will use JDK 1.6.0_10
3 . Prepares latest version of PostgreSQL installation files that you can download in http://www.postgresql.org/ , in the example we will use the PostgreSQL version
4 . Prepares Adempiere 3.6.0 LTS installation file can be downloaded at :


Start the installation process Install JDK 1.6
1 . Prepare the Java JDK 1.6 installation file that you have downloaded ( or if not , you can download at : http://java.sun.com/javase/downloads/index_jdk6.jsp )
Note : in the example we are using a file – windows- i586.exe JDK6u10 , you can use this version or higher baru.2 . Execute / Double-click the file JDK6u10 – windows- i586.exe ( file name may differ depending on the date of the latest update ) downloaded above . Then the files will be extracted to the installation preparation , as shown in the following figure :











3. press Next to continue











4, Choose “Accept” button on license agreement to continue











5. Then you are asked to choose a package that will be installed (or press Next to install typically). By default the application will install
development tools, demo files, source code, and Public JRE. You must select Development Tools to install, while Demos, Source Code, and the Public JRE you do not have to select it, you do not want to apabla installed please select the drop-down and select Do not install this feature now.

You also need to choose the installation location, where the location of the default installation of windows is in C: \ program files \ the location of the installation in our example is in C: \ program files \ java \ JDK1.6.0_10 \ (if desired you can change to another location as you want)

6. installation process, wait a moment











7. Then you are prompted to select the folder where you want to install the JRE. The default installation location is C: \ program files \ Java \ jre6 \

Note: Please note the location because it will be used in subsequent installations.

8. Installation running, wait a moment











9. Press “Finish”, and installation completed.


After the installation of the Java JDK6 is complete, then we have to set the environment of the first computer to be used. For that please go to System Properties via the menu Settings> Control Panel> System> Advanced system settings (Figure 2.8).

1. Go to Control Panel> System> Advanced> Environtment Variable, select System Variable and press the “New” and then add the Path value above

2.  in the same way, select New and add the variable as follows:

a. For Adempiere Server, enter the following variables:
Variable Name = JAVA_HOME,
Variable Value = C: \ Program Files \ Java \ Jdk1.6.0_10

Select new again and enter the following variables:
Variable Name = ADEMPIERE_HOME
Variable Value = C: \ Adempiere

b. For Adempiere Client, enter the following variables:
Variable Name = JAVA_HOME,
Variable Value = C: \ Program Files \ Java \ Jre1.6.0_10

Select new again and enter the following variables:
Variable Name = ADEMPIERE_HOME
Variable Value = C: \ Adempiere

3. Then select Path and press “Edit”, and add the following path:
a. For Adempiere Server, add the following path:

% JAVA_HOME% \ bin;% JAVA_HOME% \ jre \ bin \ client; C: \ Program Files \ PostgreSQL \ 8.4 \ bin

b. As for Adempire Client, add the following path:


Note: You should set the parameters above correctly, To check and verify your parameter  you can run from the command prompt (Start> Run> cmd) command:
And to check the path you can run the command:



To be able to run Adempiere, you need a database. Where in the example below we will install the PostgreSQL database with the following steps:
1. Prepare PostgreSQL installation file that you have downloaded (or if not, you can download it at: http://www.postgresql.org), which in this example we will use version 8.4.2 with postgresql-8.4 file names. 2-1-windows

Note: In our example we will use the version 4.8.21. You can use the same version or a newer update if available.
then double click on file postgresql-8.4.2-1-windows.exe

2. Press “Next” to start installation processi

3. Choose Installation directory  or press “Next” to use default location

4. Choose Directory data as you wish or press “Next” to use default location.

5. Enter password twice.

6. Choose locale to be use as new  database Cluster.

7. Press “Next” to continue installation proces.

8. Installation running, wait a moment

9. After Installation completed, following windows will appear:

10. UnCheck “Launch stack builder at exit”, and press tekan “Finish”


1. After you install PostgreSQL, you must create a user and database in postgresql. For that run pgAdminIII with mendoble click pqAdminIII from the Windows menu.
2. Connect to postgresql, by pressing right click and select connect.

3. Enter you DB password


4. Right click on Login Role, and create new login role baru, with name “adempiere” and password “adempiere”.

5. Move to Role previledge tab, check: “superuser”, “Can create database object”, “Can create roles”, “Can modify catalog directly”,


6. Then right click on database dan create new database with name “adempiere” and owner: “adempiere”, and “encoding UTF8”:


 7. Additionally, you can also specify the IP address that will accept connections. Suppose you want the connection to be received through IP then open them postgresql.conf file and find the setting for “Connection Settings”, then enter your IP address is as follows :

Connection Settings
listen_addresses = ’′ # what IP address(es) to listen on * = all

If you want to receive from all the existing IP on your server, replace the IP address with a “*”.

8. Well add your IP in pg_hba.conf file. For example, suppose your computer’s IP is then add the following lines:
host all all trust
host all all trust # This is the IP of your computer.

This will make the computer computer on a network segment with your computer will be accepted by the computer / server.

9. Stop PostgreSQL and start again



1. Unzip / Ekstrak Adempiere_360LTS.zip to folder C:\Adempiere


2. Open Command prompt from Start>Run>cmd dan tekan OK,


3. Enter command as follow:

4. Following windows will appear:

5. Fill in the parameters according to your computer configuration. Enter type = postgresql database, database name = Adempiere and postgresql enter the admin password as well (which you entered during the installation postgre SQL). When all the parameters have been tested and all came out a check mark, press “Save”

6. From the Command Prompt, run the following command:
C: \ Adempiere \ Utils \ Run_ImportAdempiere.bat

7. Then run the command:
C: \ Adempiere \ Windows Run_Adempiere.bat it will appear as follows:

Select a database type: postgresql then enter your host name.

8. Press Test Test Application Server and Database. In order for this process is successful, check whether the Application Server and Database already Running.

Note: To run the Application Server on your computer, you should run the command: C: \ Adempiere \ Utils \ RUN_Server2.bat
As for running PostgreSQL (if not running automatically) by clicking on the menu: Start> Programs> PostgreSQL 8.4> Start Server

9. If all OK (marked with a green check mark), press the tick. If all goes well, the following window will appear:

10. Press “OK “(thick sign)

11. Press “OK” Button

When you saw windows display as above, Congratulation, your installation is success

War Regards,
Agung BS