ADempiere Training Documentation
Alphamedia Consulting

Monthly Archives: May 2014

ADempiere Training Documentation

acc_trn

Adempiere Accounting Training 7 – 8 April 2014

GALERY FOTO ADEMPIERE TRAINING 2013

GALERY FOTO ADEMPIERE TRAINING 2013
Dokumentasi dari berbagai kota kegiatan Training Adempiere di Indonesia.

1. BANDUNG, Kagum Hotel – Agustus 2013,

Adempiere Training di Kagum Hotel – Setia Budi – Bandung – Indonesia, Agustus 2013

2. BANDUNG, Soekarno-Hatta, April 2013

ADempiere Training, Soekarno-Hatta Bandung – Indonesia, April 2013

3. PEKAN BARU, IBIS Hotel - Agustus 2013

Adempiere Training di IBIS Hotel, Tegal Sari – Pekan Baru – Sumatera – Indonesia, Agustus 2013

3. SURABAYA, Fave Hotel - Tunjungan – Agustus 2013

ADempiere Training, FAVE Hotel – Tunjungan Surabaya – Indonesia, Agustus 2013

4. JAKARTA, Puri Denpasar – Kuningan – September 2013

ADempiere Training, Puri Denpasar Hotel, Kuningan Jakarta – Indonesia, September 2013

5. JAKARTA, Sofyan Hotel - Menteng – September 2013

ADempiere Training, Sofjan Hotel, Menteng – Jakarta – Indonesia, September 2013

6. Jakarta, Setiabudi2 Building, Kuningan

Warm Regards
agung_bs@yahoo.com
Jakarta – Indonesia

ADempiere for Plantation

ademsawit

ADempier for Oil Palm Plantation(Ademsawit)


The Palm oil industry in Indonesia is growing rapidly, so does the demand for ERP plantations. Adempiere whisch is already have a very complete feature and has been proven to successfully implemented in many areas of industry, but the basic features of Adempiere is not enough for all the needs of the plantation industry. It required several additional modules and features to accommodate the needs of the oil palm plantation industry better. To fulfill that requirement, we did some custom and enhance   to accomodate plantation business process requirement. We call this project as “ADemsawit”.
PROCUREMENT
  1. In Procurement there are some following procedures:
    a. Purchase Requisition (with online approval)
    Record all Purchase Requisition from block/afdeling/estate and submit to head office for approval (online)
    b. Generate PO From Purchase Requisition
    Purchasing Requisition that has been approved can be generate as Purchase Order (PO), and can be grouped base on Supplier, product, etc.
    c. Request For Quotation
    Procedures to conduct the Request For Quotation from suppliers, quotation/bids can be made ​​online via the web making it more efficient. System will deliver results sorted offer prices ranging from cheap to expensive too.
    d. Purchase Order
    Purchase Order is used to record the purchases made to the Supplier, this process will produce a document that can be sent to PO suppliers in hardcopy or online via email in PDF form.
    e. Material Receipt
    Receipt Goods from one PO can be done all at once or in partial, this can facilitate some receiving scenario.
    f.  AP invoice (Vendor)

    AP Invoice Process, to record Bill from vendor as Account Payable.

  2. SALES
    Sales Process has some procedures as follow:
    a. Quotation
    Create Quotation for Customer
    b. Sales Order
    Create and Maintain Sales Order for Customer
    c. Shipment/pengiriman barang
    Shipment process, deliver goods to customer, with DO/surat jalan document.
    d. Support Multi Price list, Multi Currency, sales commision dll
  3. MATERIAL MANAGEMENT 
    a. Support Multi Warehouse
    Supports multiple warehouse locations and support system to facilitate the storage of goods storage of goods in large quantities (eg spare parts).
    b. Support Multi UOM

    Supports all units and supporting such conversion into a dozen pcs, pack, etc.

    c. Inter Warehouse Transaction

    Material movement, between two warehouse.

    d. Physical Inventory

    Physical Inventory to maintain accuracy of physical goods quantity with system quantity.

    e. Inventory use (Conversion of goods stock to charge)
    The use of materials and conversion of inventory into account the cost.

                                                                       .
  4. Modul Finance & Accounting 
    a. Account Payable (AP)
    Record Account Payable to supplier/vendor, schedules and payment process.
    b. Account Receivable (AR)
    Record Account Receivable from Customer, print aging report and process receipt.
    c. Bank Statement
    Manage bank from AP/AR payment and other bank transaction.
    d. General Ledger (GL)
    GL Journal to record GL Transaction for some Accounting transaction.
    e. Cash journal
    Record Cash transaction from/to cashbook.
  5. Estate Management
    a. Pre-Nursery & Nursery Management

    Manage and record the costs incurred to care for plants ranging from germination, seedling age of 1 month, 3 months and so on. Where the end result could be known how the cost that has been incurred for each seedling.
    Report: Total / partial operational costs, COGS/HPP Reports

    b. Activity Management

    Keep track of all the activities and events in the garden along with materials used and costs, the end result can be seen the total cost per hectare garden, as well as the total cost per ton harvest.
    Each garden will be created RKB / CTR (working Plans Monthly / Annual Work Plan) which will be the reference budget monthly / yearly for each block. Which, along later be compared with the actual / actual overall budget (actual). Reports: Budget per blok/division/estate , Realization per blok/division/estate  

    c. Vehicle & Machine Running Account
    Record all activities of vehicles and machines where costs are allocated to each activity in order to monitor the operational costs of vehicles and machinery / heavy equipment.
    d. Workshop Running Account
    Record all activities such as work hours, materials and services used, and the progress of work in order to monitor the operational costs of the workshop.
  1. MILLS MANAGEMENT
    a. Weight bridge
    Record incoming data from the weighing machine to be used as a data reception of fresh coconuts oil (TBS).
    ** under development

    b. Product Storage Reading

    Record the number of CPO stocks last storage based on the analysis of sound (sound) which will be Kilo conversion using table tank and temperature
    ** under development

    c. Harian Laboratorium

    Daily reports from the laboratory of analysis of real fresh fruit bunches or report processing of Mill

    d. Penerimaan TBS

    Record incoming fresh coconut oil palm (TBS)

  2. PLANTATION BUDGET
    a. Field Budget
    Field Budget is a budget based on the Annual Work Plans of the concerned block

    b. Oil-Palm Production Budget

    Production of CPO and Kernel Based on the capacity of the engine is based on the production and reception of real fresh fruit bunches and purchase.

    c. Vehicle Budget

    Forcast allocation of vehicles and heavy equipment costs include salaries, fuel, and vehicle and heavy equipment activity is concerned.

    d. Workshop Budget

    Forcast cost allocation workshops include salaries, fuel, and workshop activities are concerned.
  3. PLANTATION PAYROLL
    Payroll application payroll derived from standard plantation. Noting salary calculation, adjustment, pph21 taxes, benefits, and allowances based on company policy. Integrated with financial accounting module.
    ** under development
  4. LAND MANAGEMENT

    To record the actual condition of the garden such as topography, soil type, area type, and other lai including document certification .

  5. INFRATRUCTURE & BUILDING MANAGEMENT
    Caring and building operational infrastructure such as buildings, roads, bridges, ditches, etc.
  6. PROJECT MANAGEMENT

    To take care of the project activities and its progress both physically and financially progress.

    ==================
    Warm Regards,

    Agung Budi Santosa
    agung_bs@yahoo.com
    Jakarta – Indonesia

ADempiere Installation on Windows

logo-adempiere

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 8.4.2.1
4 . Prepares Adempiere 3.6.0 LTS installation file can be downloaded at :

http://sourceforge.net/projects/adempiere

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.

ENVIRONMENT SETTING

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:

%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin\client

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:
C:>SET
And to check the path you can run the command:

C:>Path

POSTGRESQL INSTALLATION

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”

CREATEA DATABASE

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 192.168.1.1 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 = ’192.168.1.1′ # 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 192.168.1.1 then add the following lines:
host all all 127.0.0.1/32 trust
host all all 192.168.1.1/24 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

 

INSTALL ADEMPIERE SERVER

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:
C:\Adempiere\Run_setup.bat

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
agung_bs@yahoo.com

Adempiere Implementation with POS

pos-PC2

Adempiere For Retail / POS (Point Of Sales) 

In the modern retail business, ERP applications are needed to support its operations. Where in the modern retail business is usually a company has many retail outlets with a large warehouse as a storage center and control the movement of goods between warehouses with outlet, outlet to outlet and warehouse outlets. That requires an application that can integrate all the good deals at the outlet side, warehouse / inventory, procurement, planning, etc.
With such of requirement, ERP Applications is needed to integrate entire multi-outlet operations so that it can perform centralized control of head office / central office. Thus the operating conditions of each outlet, such as inventory status, progress sales / sales, cash status, etc. can be monitored and controlled so as to facilitate operations and business strategy, for example by transferring goods that are being sold in a particular outlet, or provide happy hours (discounts at certain hours) on a particular outlet at certain hours to drive sales, and so on.

Since Posterita no longer maintain in Adempiere in 2010, Adempiere not have enough qualified POS applications, the presence of which is expected to replace JavaPOS posterita, although quite tolerable and feasible for use, but still seems to be far from the expectations of the users of POS.

Some developers trying to integrate Adempiere with other applications such as Openbravo POS POS, as is done by Red1 in the following link, and SmartPOS who also is an instance of Openbravo POS which can be downloaded at the following link. Here are some reviews of the types of POS applications that can be used with Adempiere ERP:

1. Posterita
Posterita is a web-based POS applications where the use Posterita, Retail outlets simply take advantage of the web browser on the computer to be able to trade with an online connection to a central database and has good connectivity premises POS peripherals such as barcode scanner, cash drawer, etc.. Having abandoned Posterita as a developer, the development of practical applications in Adempiere POS Posterita be stalled because developers are not able to continue this project. Posterita itself from version 2.0 be paid by SAAS method, and is no longer open source, it is confirmed by Frederick Tsang (Posterita developer) to the author via email at the beginning of 2010.

2. Openbravo POS
Openbravo ERP has been known as a POS applications that are reliable, easy to use, and with an attractive design, besides openbravo also has features such as discount features, touch screen display as well as connection with a pole display, cash drawer, barcode scanner and others with performance are very good. Openbravo POS was originally designed to be integrated with Openbravo ERP. But for the current Adempiere users can integrate Adempiere with Openbravo POS, through a project initiated by RedHuan at the following link, and the application can be downloaded at the following link.

3. SmartPOS JSP
SmartPos is an instance of Openbravo POS is designed specifically to be integrated with Adempiere, which is an improved version of Openbravo POS in terms of integration with ERP Adempiere. For more information about this project can be viewed at the following link.

Implementasi ADempiere untuk bisnis Retail di Indonesia 

Oone of the companies that have already implemented Adempiere as Business Solutions Retail / POS is PT. Pembangunan Jaya Ancol meruapakan organizers largest amusement park in Indonesia. The use Adempiere for Retail POS solution specifically for the sale of merchandise goods in the Ancol tourist park.
Adempiere POS solution to this has been used in live since June 2011, meaning that up to this writing has been approximately one year using Adempiere as a solution for its retail business. One of the first reasons to use Adempiere is due to open source, where it is more affordable budget, the latter capable of integrating the entire process of sales outlets are spread across the number of tourist sites is quite a lot. Implementation process consulting is done alphamedia lasted from early 2011 until June th, 2011.

POS application used in Ancol is Posnet POS is an application which in develop in-house by Alphamedia for POS needs in Indonesia. Posnet can integrate with the POS peripherals such as POS printers, Barcode Scanner, Cash Drawer, Barcode Printer, Pole Display, etc.
 
Video Adempiere User di Ancol.
Some time ago, while searching on the internet, I accidentally found a video that a user uploaded from Thailand which records usage and application Adempiere POS PT. Pembangunan Jaya Ancol, Jakarta – Indonesia.

The video lasted 1 minute 28 seconds is uploaded on youtube by user MrThammathat of Thailand during his visit in Indonesia in August 2011. Implementation of POS with Adempiere ERP seems attract his attention.

Info / Spesifikasi implementasi :
- Perusahaan = PT. Pembangunan Jaya Ancol
- Versi ADempiere = 360LTS
- Database = PostgreSQL Versi 8.4
- Jumlah user = +/- 120 user
- Jumlah Outlet = +/- 40 outlet
- Server = IBM Blade M series / OS Linux Centos
- Periode implementasi = Januari 2011 – Juni 2011
- Consultant = Alphamedia (www.alphamedia.co.id)

Hopefully this article can give idea for Adempiere Users and encourage retail businesses in (especially in Indonesia) to further expand its business with a reliable and cheap solution.
Warm Regards !
Agung Budi Santosa
agung_bs@yahoo.com
Jakarta – Indonesia

Adempiere Server Performance too slow?

computer-getting-slower

After sometimes using ADempiere ERP, some users asking why their server performance is too slow. to answer this question accurately would need a more detailed check of the condition of Adempiere server , network , and so forth . Assuming the Adempiere server is in trouble and the network in good and fair condition , then there are a few things you need to do are to improve the access speed of your storage using RAID ( if not ) , when they are using RAID , you can evaluate and if possible use a method that is more efficient and faster according to your needs . Regarding RAID I have discussed in the following link : http://blog.alphamedia.co.id/2011/07/raid-system-untuk-adempiere-server.html

The second , well-known ERP applications with very greedy applications to resource , memory and storage . So you should regularly monitor the condition of Adempiere server , whether memory is sufficient , whether the storage is still insufficient and so on .To view the memory on Windows Server , you can see from the properties and the windows task manager , while for Centos Linux you can do as follows :
Check Total Memory in Linux
First check physical memory available on your computer in the following way:#dmesg |grep memory

To view the memory is still available in linux you can use the following command:#free -m

Or you can see the memory usage of each application as well as the memory was still available with the following command:
#top
If the memory in your computer is not enough , there are several things you can do , the first is to add your physical memory , and the second is to enlarge the swap file on your computer ( if the addition of physical memory can not be done )

Enlarge Swap File in Linux

What to do when you need to add a swap file on your Linux server ? there are 4 options you can do as follows :

1 . Creating a New File swap
2 . Creating a swap file on the existing logical volume
3 . Meng Extend existing swap file on your logical volume
4 . Creating a new swap partition

If you need a space larger swap file , create a new swap file is the fastest and easiest solution . Swap files on logical volumes in and extend the swap file on a logical volume is a more difficult step . While Constructing a new swap partition is the most difficult step , but it gives a solution that is more effective and permanent .

On this occasion I akang explain how to create a new swap file as the easiest and fastest way to enlarge your swap file space .

Creating a new file Swap

We need to specify the additional swap file space that we need. Let’s assume we need 512 Megabytes of swap space . To determine the number of blocks we need to multiply the size of the file to 1024 . So in our example is 512 x 1024 = 524288 . Then we need to run the following command :

dd if = / dev / zero of = / home / swapfile bs = 1024 count = 524 888

Position location of a file in / home / swapfile just as an example , you can put somewhere else for security reasons , and others . Then you can setup a swap file with the command

mkswap / home / swapfile

Swapfile that you created above will not enable the next time you boot the system . To make it enabled at boot time , you need to add to / etc / fstab / and the following lines into the file / etc / fstab:

/ home / swapfile swap swap defaults 0 0

Similarly, think about my review to foster problem Adempiere speed of your server , if all efforts have been made and the server is still slow , it could be it is time you buy a bigger server .

Hopefully this article can be useful for users Adempiere .

=======================
Warm RegardAgung Budi Santosa
agung_bs@yahoo.com
Jakarta – Indonesia
=======================

Adempiere for Manufacturing

ADempiere For Manufacturing

 

Batch Implementation in Production.

In manufacturing company usually need to provide identity to every product produced by applying the production batch number , it’s uses when a company receives a complaint from a customer of one of the products that have been sold , then the company can easily keep track of the products derived of production of when, where and the production line was done by anyone and even can be known who the suppliers of raw materials of the product. By knowing this information , it can do the repair / improvement of the production process in the future .
For this scenario Adempiere provide a Product Attributes feature , where attributes can be either Lot Control ( Control lot number / batch ) , Serial No. Control ( nomot serial control ) , Guarantee days ( longer warranty ) and others .
For example , by applying Lot control on the material receipt ( receipt of goods ) , we can identify any goods received from suppliers , and also wrote this information is recorded , for example when the goods are to be resold or to be used in the production process .
Furthermore, by applying the Serial No. Control we can identify every product that we sell come from any production , where the production line as well as the use of raw materials from which the supplier .
To be effective this method menggunakanan this process must also be accompanied by the tag / labeling for each product so that the product is not to be confused physically . And at the end of each product can be identified and can be at the track since the reception to the product on delivery to the customer .

In more complex cases, this process should also be combined with the Locator application, for example, for products that are “untagable” or can not be given a tag / label eg liquid products, flour, gas etc.. Where the labeling process can only be done at the time of packaging these products in the shipment.
In one of the authors in project implementation flour mill, raw material is stored in silos with a capacity of about 100 tons each, where each material that will be entered in a batch numbered for identification.
Each batch will occupy one locator at a time.
Every product that will be used in the production batch number will be included into the production, and will produce finished materials with the new batch number.

The batch number will be included on the packing of finished goods (Finish Goods), so it can easily be tracked in the event of a complaint or questions related to the product.

Hopefully this article can be useful for users Adempiere INDONESIA.

Regards,
Agung Budi Santosa
agung_bs@yahoo.com
Jakarta – Indonesia
================

Insert: my photos when Adempiere implementation in one Manufacture Company, 2011.