iDempiere Functional Training 2017
Alphamedia Consulting

Category Archives:General Information

iDempiere Functional Training 2017

kagum_hotel

iDEMPIERE FUNCTIONAL TRAINING

JAKARTA 25 – 27 Juli  2017,

========================================

Tanggal : 25 – 27 Juli 2017 (3 Hari)

Waktu   : 09:00 – 16:00 WIB

             Jl. HR Rasuna Said Kav 62 Kuningan Jakarta – Indonesia
Biaya    : Rp. 5000.000,- (Lima Juta Rupiah),

=========================================

** Pendaftara di tutup 1 minggu sebelum pelaksanaan tranining**

========================================

Pelatihan ini ditujukan kepada siapa saja yang akan menangani dan mengoperasikan iDEMPIERE ERP. Anda akan belajar segala sesuatu yang dibutuhkan untuk membuat iDEMPIERE ERP siap untuk digunakan oleh user termasuk entry data, transaksi, konfigurasi, dan mengelola fungsional operasional iDEMPIERE.

 APA ITU iDEMPIERE ERP?

iDempiere ERP Merupakan aplikasi ERP (Enterprise Resource Planning) berbasis Opensource. Dengan Menerapkan aplikasi ERP, sebuah perusahaan akan mampu mengintegrasikan seluruh operasional perusahaan dalam satu sistem sehingga dapat melakukan kontrol untuk menekan Cost / biaya serendah mungkin, melakukan monitoring dan mendorong sales / penjualan semaksimal mungkin, serta melakukan efisiensi diseluruh kegiatan usaha sehingga secara keseluruhan akan mampu menaikkan pendapatan perusahaan secara signifikan.

Untuk menerapkan sistem ERP, banyak hal yang harus dipertimbangkan secara matang oleh sebuah perusahaan , diantaranya adalah:

1. Biaya implementasi sesuai dengan budget perusahaan

2. Bisnis proses sesuai dengan Bisnis proses perusahaan

3. Mudah dirawat/dimaintain dan mudah di upgrade

4. Berbasis teknologi terkini dan mampu di aplikasikan dimasa datang

5. Memiliki resiko kerugian terkecil (bila gagal)

Dan iDempiere memenuhi hampir semua tuntutan tersebut.

iDempiere ERP merupakan Fork dari Adempiere ERP, yang merupakan salah satu ERP Opensoure yang sukses diimplementasikan di berbagai perusahaan di dunia termasuk di Indonesia, baik untuk perusahaan Distribusi dan jasa, manufaktur, Automotive, Ritel, hingga perusahaan pertambangan (mining) dan Perkebunan. Minimnya sosialisasi serta pelatihan iDempiere membuat masih sedikitnya perusahaan yang mampu memanfaatkan iDempiere sebagai aplikasi ERP modern yang memiliki banyak kelebihan namun dapat digunakan dengan free license.

Seiring dengan mulai banyaknya implementasi iDempiere ERP sehingga memerlukan SDM yang mampu mengelola iDempiere ERP dengan baik, Alpha Media kembali mengadakan Training “iDempiere Functional Training” yang akan diselenggarakan sebagai berikut:

Tanggal     :  25 – 27 Juli 2017

Hari         : Selasa s/d Kamis

Waktu       : Jam 09:00 – 16:00

Tempat     : Setiabudi 2 Building, Lantai 2

                   Jl. HR Rasuna Said Kav 62, Kuningan

                   JAKARTA

Googlemaps : klik disini

UNTUK SIAPA PELATIHAN INI? 

Pelatihan ini ditujukan kepada siapa saja yang akan menangani dan mengoperasikan IDEMPIERE ERP. Anda akan belajar segala sesuatu yang dibutuhkan untuk membuat IDEMPIERE ERP siap untuk digunakan oleh user termasuk instalasi, konfigurasi, dan mengelola fungsional operasional IDEMPIERE.

Kompetensi

Setelah selesai mengikuti pelatihan, diharapkan peserta akan mampu untuk:

* Mengenal karakter, kemampuan dan keunggulan IDEMPIERE ERP.

*   Melakukan Implementasi dan konfigurasi dasar .

*   Merawat Business Partner, Product, dan Pricing.

* Merawat Purchase, Material Management, Sales, Receipt & Payment.

* Melakukan konfigurasi Akuntansi dan Financial Report.

* Melakukan konfigurasi Security

 Siapa yang harus ikut Pelatihan ini?

* User/Pengguna maupun Calon pengguna Sistem IDEMPIERE

* Calon Administrator IDEMPIERE

* Dosen/Pelajar/Mahasiswa yang ingin mempelajari IDEMPIERE.

* Praktisi IT, praktisi akuntansi, pekerja, pelaku bisnis, serta orang orang yang yang ingin mempelajari IDEMPIERE.

Prasyarat:

Dalam rangka peserta dapat mengikuti pelatihan dengan baik, peserta harus memenuhi syarat sebagai berikut:

* Dapat mengoperasikan komputer dalam lingkungan sistem operasi windows, Bisa mengetik, mengatur file dan folder, dan mengatur parameter sistem.

* Peserta yang mengetahui konsep dasar Sistem ERP (Enterprise Resource Training) akan sangat membantu proses belajar, meskipun ini bukanlah syarat mutlak.

MATERI PELATIHAN:

Day 1

————

• Introduction

• Basic Concept& Business Concept of idempiere

• Navigation

– Windows, tabs, menu & Toolbar

– Zoom Across, New Record, Value preference,

– User Preference, Info windows,

– Print & Export, Drill down across

– Chat, Attachment, archive

• Web UI

• Initial Setup

– Initial Client Setup

– Chart Of Account Setup

– Finalizing your Setup

– Setup Organization & Warehouse

• Master Data

– Business Partner

– Products

– Pricing

• Requisition to Invoice

– Requisition

– Purchase Order

– Material Receipt

– Purchase Invoice

– Matching PO-Receipt-Invoice

– Purchasing Reports

Day 2

————

• Material Management

– Material transaction

– Material Move

– Internal use Inventory

– Physical Inventory

– Replenishment

– MM Reports

• Quote to Invoice

– Quotation

– Sales Order

– Material Shipment

– Sales Invoice

– Sales reports

• Return

– Vendor Return

– Return to Vendor Vendor RMA

– Return to Vendor

– AP Credit Memo (Debit Memo)

– Customer Return

– Customer RMA

– Customer Return

– AR Credit Memo

Day 3

————

• Open Items

- AP Payment

- AR Receipt

- Prepayment

- Invoice Schedule

- Payment Allocation

- Payment Selection

- Cash Journal

- Bank Statement

- Payment Term

- Payment Print/Export

• Performance Analysis

- Accounting Setup

- Tax Setup

- GL Journal

- Financial Reporting

- Performance Measurement (SLA)

- Performance Measurement (Dashboard)

- Costing Setup

- Update Product Costs

• Security

– User and Role

• Overall Review and Practice

FASILITAS:

Peserta akan mendapatkan:

a. 2X Cofee & snack

b. 1X Lunch

c. Buku “Implementasi ERP langkah demi langkah dengan  IDEMPIERE”.

d. Sertifikat

Catatan: Peserta masing masing diharuskan membawa laptop dengan spesifikasi minimum Pentium 4 dengan memory minimal 512 MB.

Untuk Info lebih lanjut silahkan menghubungi:

1.   Bayu, Email: bayu@alphamedia.co.id, Tlp. HP: 0857 293 661 22

2. Agung, Email: agung@alphamedia.co.id atau agung_bs@yahoo.com HP: 0811 776230

 PENDAFTARAN :

1. Download dan Isi Formulir Pendaftaran di http://www.alphamedia.co.id/download/Formulir-IFT-2017.doc kemudian kirimkan ke training@alphamedia.co.id  atau sales@alphamedia.co.id

2. Biaya Training Rp. 5.000,000,- per peserta.

3. Transfer uang pendaftaran sebesar Rp. 5,000,000,- (Lima Juta Rupiah)** ke: Rekening BCA No : 326 126 9234 a/n Agung Budi Santosa.

Catatan: Bukti transfer harap dibawa ketika hari pertama training.

=======================

Pendaftaran ditutup 1 minggu sebelum Jadwal Pelatihan

===================

SI.08. Adempiere for Mining Industry

mining-icon

ADempiere ERP for Mining Company

 

Adempiere ERP for Mining Company
In the current version does not yet support Adempiere Process Manufacturing Likewise the mining companies, but this does not mean that Adempiere is not able to be implemented in the mining company, is evidenced by the successful implementation of Adempiere in one of the mining companies in Indonesia. In the manufacturing world known two kinds of production processes for accommodated by the ERP application, the first is the Discrete Manufacturing, and the second is the Manufacturing Process.

What is the difference Disctete manufacturing and Process Manufacturing?

Discrete Manufacturing is a production process that are conical, as an example we will review the BOM structure and the process of making a set of furniture for the garden. To make a wooden chair would have required a single board, 4 sticks, 2 pieces of wood and some nails finger.

 

And to create a set of garden furniture, it will take 4 pieces of wooden chairs plus a table and garden umbrellas. Components that make up part of the product is set within a BOM (Bill Of Materials). Where the core of this process is of some components will produce 1 piece of product / Finish goods.

 

As for Process manufacturing is in contrast to the discrete manufacturing, for example, we will review the process of oil production mining company. From the material of the basic ingredients, namely crude oil / crude oil can be processed into asphalt, kerosene, gasoline, diesel fuel, and so forth Aftur. Where the core of this process is the basis of the material / raw material can produce many products / Finisih goods.

 

Adempiere ERP including those that support the first type is Discrete Manufacturing .
It is shown from the production and management processes , supported BOM structure . In addition, if we enter into the menu Manufacturing Management, Production Management under Discrete Manufacturing only be encountered and to release at this time we have not encountered Manfucaturing Process . The question is :Is Adempiere ERP can be used for Process Manufacturing / Mining Company ?Adempiere Users can feel relieved , because although not yet fully support the Process Manufacturing ERP Adempiere but that does not mean can not be used in the mining company . Because in addition to the production process , all other functions are actually the same . Furthermore, the transaction process Adempiere they actually ” open ” and make Adempiere can be a little flexible ” in play play ” so that eventually it can accommodate the production process from mining companies.This has been proven by the successful implementation in one of the mining companies are ” BM ” mining are located in South Sulawesi . BM Mining which is a granite mining company , group one of the leading business group in Indonesia has been successful go-live with Adempiere ERP .
BM production process begins with the mining of granite mining exploration to be processed into a variety of stones and sand for a variety of purposes ranging from building materials to kontsturksi raw material for making cement . The production process can be described as shown below :
Blasting -> granite stone (raw) -> Crashing -> FG1, FG2, FG3, FG4, dllDengan the production process can be accommodated into Adempiere system, it can be said almost all of the requirements management process and accounting BM mining mining companies can be accommodated by Adempiere . So I am very confident for mining companies other fields such as coal mines, oil mines, copper mines, gold etc. can also be accommodated by Adempiere.So, we wait for the next mining company wants to try Adempiere greatness …..

Photo: My (3rd from right) together with 2 photos BM Mining & accounting staff member after another training session.

Hopefully this article can be useful for users Adempiere INDONESIA.

Regards,
Agung BS

Solutions Retail / POS with Adempiere

pos-PC2

Solutions Retail / POS with Adempiere

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 and others.

With such a requirement , the presence of ERP Applications course is needed . ERP applications can 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 forth .

Since abandoned by Posterita 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 .

For that 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 using 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 sudah sejak lama dikenal sebagai aplikasi POS yang handal, mudah digunakan, dan dengan desain yang menarik, selain itu openbravo juga memiliki fitur fitur seperti diskon, touch screen display serta koneksi dengan pole display, cash drawer, barcode scanner dan lain lain dengan performa yang sangat baik. Openbravo POS pada awalnya didesain untuk dapat berintegrasi dengan Openbravo ERP. Namun bagi pengguna ADempiere saat ini bisa mengintegrasikan Adempiere dengan Openbravo POS, melalui project yang dirintis oleh RedHuan di link berikut, serta aplikasinya bisa di download di link berikut ini.

3. SmartPOS JSP
SmartPos adalah turunan dari Openbravo POS yang didesain khusus untuk dapat terintegrasi dengan adempiere, dimana ini merupakan penyempurnaan dari Openbravo POS dalam hal integrasi dengan Adempiere ERP. Informasi lebih lengkap mengenai project ini dapat di lihat di link berikut ini.

Implementasi ADempiere untuk bisnis Retail di Indonesia 

Salah satu perusahaan yang sudah mengimplementasikan ADempiere sebagai Solusi bisnis Retail / POS adalah PT. Pembangunan Jaya Ancol yang meruapakan penyelenggara taman hiburan terbesar di indonesia. Penggunaan ADempiere untuk solusi Retail POS khususnya untuk penjualan barang barang merchandise di lingkungan taman wisata Ancol.
Solusi POS dengan ADempiere ini sudah digunakan secara live sejak Juni 2011, artinya hingga tulisan ini dibuat sudah kira kira satu tahun menggunakan  ADempiere sebagai solusi untuk bisnis Retailnya. Salah satu alasan menggunakan ADempiere yang pertama adalah karena opensource, dimana budget nya lebih terjangkau, yang kedua mampu mengintegrasikan seluruh proses penjualan di outlet outlet yang tersebar diseluruh lokasi wisata yang jumlah nya cukup banyak. Proses Implementasi dilakukan alphamedia consulting berlangsung dari awal 2011 hingga bulan Juni th 2011.

Aplikasi POS yang digunakan di Ancol adalah Posnet POS yang merupakan aplikasi yang di develop secara inhouse oleh Alphamedia untuk kebutuhan POS di Indonesia. Posnet dapat berintegrasi dengan peripheral POS seperti POS Printer, Barcode Scanner, Cash Drawer, Barcode Printer, Pole Display, dll
Video Adempiere User di Ancol.
Beberapa waktu yang lalu, ketika sedang searching di internet, tanpa sengaja saya menemukan video yang di unggah seorang user dari Thailand yang merekam penggunaan ADempiere dan aplikasi POS di PT. Pembangunan Jaya Ancol, Jakarta – Indonesia.

 

 http://www.youtube.com/watch?v=Nu1W-JnIm6g&feature=player_embedded#t=0

Video yang berdurasi 1 menit 28 detik ini di unggah di youtube oleh user  dari Thailand pada Agustus 2011. Implementasi POS dengan menggunakan Adempiere ini nampaknya menarik minat wisatawan asal Thailand tersebut.

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)

Semoga tulisan ini dapat memberikan masukan bagi Pengguna ADempiere Indonesia serta dapat menyemangati pebisnis retail di Indonesia untuk lebih mengembangkan usahanya dengan solusi yang handal dan murah.

Salam Hangat !
Agung Budi Santosa
agung_bs@yahoo.com
Jakarta – Indonesia
================

Multi Currency in ADempiere

logo-adempiere

MULTI CURRENCY in ADempiere

 

Adempiere ERP fully support the use of Multiple Currencies . Multi- Currency Capabilities include three aspects , namely : Multiple Currencies

• Multiple Transaction Currency ( currency other than the currency Accounting )
• Multiple currency Accounting in parallel ( eg UK company using GBP and EUR )
• Several reports of currency ( 1:1 conversion of a report )

Multi – Currency Conversion

You can define the type of multiple Conversion Rate . You may want to use the Corporate tariff rates or user-defined ( instead of using the Spot Rate ) for the purpose of planning . The default rate is the level of Spot Rate , which is in accordance with market rates .

To maintain the administration to a minimum conversion rate is to include a date ‘ Valid_From ‘ Which one is effective until a new record is inserted with a ‘ Valid From ‘ newer . The most recent date should always take precedence over a longer date .

Reciprocal tariff level is not automatically calculated , ie . USD : AUD exchange rate does not result in a conversion of CAD : USD . That is , a separate rate levels should be included .
( * USD = U.S. Dollar , USD = Indonesian Rupiah )

Multi Currency Transactions

Adempiere allows you to complete the transaction in any currency . You can maintain your invoice in EUR , your receipt in the GBP , your Bank Account in CHF and doing your accounting in USD .

The transaction currency is determined by the price list . Currency to a price List ( List Price ) is defined in the Price List window .

Multi Currency Accounting

The Multi – Currency Accounting transactions are the Advantages of Currency Exposure Its not realized ( Unrealized Gain currency ) eg between Invoice and Receipt . Another advantage is realized transactions ( Realize Gain )

Multi – Currency Process

Compiere is currently supporting Currency Converter . Currency conversions performed when a report requested in a different currency .

Thanks and Regards
Agung Budi Santosa

agung_bs@yahoo.com
Jakarta – Indonesia

 

“PRODUCT” in Adempiere

logo-adempiere

PRODUCT

In Adempiere ERP, Product is defined as something you sell and / or buy, or something you save and have a price.

By type, Produck divided into the following types:
• Items (goods)
• Services (services)
• Resources (resources)
• Expense Types (types of financing)

Items / goods are goods that physically you are selling. whereas
Service / service is something (non-physical) is not limited in relation to the availability of its resources. Expenses (Cost) is something that can be charged, for example, a consultant may make the fare on your bill to the customer.

Products can be described as’ a collection of assets with similar attributes.

An asset is something you buy or your own production. Likewise no products which you always have, you may or may not have a definite asset. Either use your own or by someone else, it’s just that the main characteristics of an asset is that you perform and maintain its tracking individually.
And optionally an asset can be sold. In short, the asset can be described as an individual entity of a product.

Product Setup Workflow
Product setup, workflow steps as illustrated in the following figure:

Product Attribute “Product” Attribute
- Same for the specific Product
- Set of Attributes and Values

“Instance” Attribute
- Different for the specific Product Instance (s)
- Set of Attributes and Values
- Predefined
- Lot (Batch)
- Serial No.
- Guarantee (Expiry) Date

Individual Product Attribute

Predefined Individual Attributes
- Lot / Batch, Serial No., Date Guarantee Create Instance Attributes (Serial No., …)
- Receiving
- Production
- Physical Inventory
- Shipment
Optionally specify / reference Instances
- Move Inventory
- Physical Inventory
- Production
- Order
- Invoice
- Shipment

Thanks and  Regards
agung_bs@yahoo.com
Jakarta-Indonesia

Jasper Report in Adempiere

logo-adempiere

Jasper Report in Adempiere, Part 1

JASPER REPORTS IN Adempiere

Adempiere already provides a fairly sophisticated reporting tools , but sometimes still not sufficient to meet the needs of users , especially for users who want to be able to easily create reports with a report that a complex calculation , which if done in Adempiere will be quite difficult for the user .

One of the advantages Adempiere is already tergintegrasinya Jasper reports in Adempiere , sehingg for users who are familiar with tools such as Jasper Reports reports , Crystal Report etc. , will be able to easily utilize Such facilities .

JasperReports has hundreds of features , but unfortunately does not provide a tool to visually design reports . Someone without a good ability with XML may not be able to use to the fullest library ( library ) JasperReports .
It required utilities ” Report Designer ” to facilitate the user in developing the design of the report . One of the ” Report Designer ” which is the most popular iReports ” . IReport works to help people like this besides of course the experts / developers .

iReports

iReport is a utility ( tool ) reporting , which was developed in the Java environment in order to help users and developers ( developers / programmers ) visually design reports . Through the interface is simple yet feature-rich , iReport provides the most important functions to create complex reports with ease , thus saving a lot of time .

iReport uses JasperReports library for creating reports . JasperReports , in this case is the core of iReport . JasperReports is an open source utility yamg reporting in the most popular Java technology , and iReport is a visual report designer for JasperReports .

IReport Features

iReport can connect to any database and obtain data from different data sources . Moreover, it can export reports to PDF , XHTML , OpenOffice , MS Word , MS Excel , XML , Text , and others .

IReport Interface

User Interface ( UI ) of iReport is very user friendly . This gives some easy steps to generate a report using the Report Wizard help .

 

Featured in iReport interface including:
Facilities Drag-and-drop (drag and drop) to Elments Report (element statements).
Palette window which consists of the Report Elements and Tools

Easy navigation of report objects via the Report Inspector

Properties window to set the properties of the report elements, as shown below:

Supports Undo and Redo editing window interface that can be collated and configuration.

You can design reports using the report designer smart (intelligent report designer). The following are some of the features of the designer:
Using the Report Wizard, the report can be built in a few easy steps in a very short time. After that, there are other editors that can be used to modify / add features further reports. It helps to quickly manufacture new reports, subreports, defines the group data, and create a group header and footer.

The built-in editor for hyperlinks, padding and border, number, and date pattern.
Using the mouse or keyboard to position, align, and resize objects.

The format of comprehensive tools.

 

Contextual menu to perform common operations quickly. Header, footer, summary, background, and so on, which can be adjusted ukurunannya well as with some of the details. Copying and pasting elements.

Complete including Pie Charts, Pie 3D, Bar, Bar 3D, YX Bar, Stacked Bar, Stacked Bar 3D, Line, XY Line, Area, YX Area, Scatter, Bubble, Time Series, High Low, Candlestick, Gantt, Meter, Thermometer , and Multi-Axis chart.

 

Regards

Agung BS
agung@alphamedia.co.id
Jakarta – Indonesia

 

About Us

logo-adempiere

Alphamedia Consulting is an IT company whose mission is to provide a Global IT solution services for you and your business. Our company works hand in hand with the clients to create solutions that enable businesses to maintain competitive edge. We are committed to our client’s success.