Product with Multi UOM
Alphamedia Consulting

Category Archives:Tutorial

Product with Multi UOM


Product with Multi UOM

In retail business we Often have a product with multiple UOM (Unit Of Measure), for example, we buy in units of cartons, but retail sell per piece, or vice versa, but we buy in units sold per carton with some quantity.

In the example below we will make an example, a product with a unit of the bottle and carton, where one carton contains 25 bottles (this is an example of a very common case particularly in the retail industry in Indonesia)

First we have to do is make the UOM in Bottles (BTL) and Carton (K25), then enter the UOM> Conversion.


Enter the name of the product to be converted, then enter muliply = 25 to state that the carton contains 25 bottles.

Next we tried to do material Receipt = 4 + 10 bottle cartons.
Select the desired qantity and UOM.

Total = 4 cartons and 10 bottles.

Then return to the Material Receipt tab and do “Complete”

Next we look at the status of the product information material.

In Adempiere, the stock will be recorded in the smallest UOM, so if we have a UOM cartons and bottles, then the stock will be recorded in the bottle.

Next we are going to sell these products

We will sell 4 cartons and bottles 5
Choose Quantity 4 and UOM = cartons

Create a new Line with the same product, select quantity 5 and UOM = Bottle

So that the total of the products we sell are 4 carton + 5 bottle = a total of 105 bottles

Do a “Complete”, the display order confirmation is as follows:


Agung Budi Santosa

Jakarta – Indonesia


Material Management in ADempiere




Aspects related to material management in Adempiere ERP are:
• Warehouse
• Shipments (receipts)
• Inventory Movements
• Physical Inventory
• Production
• Customer Shipment
• Replenishment (Demand)
• Available to Promise
• Valuation Costing

Materials Management
Warehouse is the physical location where the goods / materials are stored. You can make as many as you want warehouse. Furthermore Warehouse may have one or more locators (location of placement of goods). A locator has three dimensions as it is commonly known known:
• Aisle (Gang)
• Bin (tub / Container)
• Level (Level)


In a complex setup, you can create a warehouse for the receipt, a warehouse for storage and a warehouse for delivery:
Material MovementExternal-Receipt
- ShipmentInternal-Inventory Move
- Phisical Inventory (in Indonesia is often called “Taking Stock”)
- Production
- Inventory Movement (in Indonesia is often called “Mutation”) Inventory Valuation Report
- Based on Price List
- PO Price Lists
- Calculates Qty based on Valuation Date
- Export to XLS for more complex valuationHopefully this article can be useful for users Adempiere INDONESIA.
Agung Budi Santosa

Business Partner in ADempiere



Business Partner

In conventional ERP applications , generally they will have some master data such as : Vendor Master , Customer Master , and Employee Master .

In Adempiere ERP , the concept is slightly different , where Vendor , Customer , and Employee included in a business partner .

Business Partner is an entity ( entities / parties ) who do business with your company .
There are three different types of Business Partners :
- Vendor ( Supplier ) ,
- Customer ( Customer )
- And Employee ( Employee ) .

Adempiere ERP Business Partner concept is much more flexible than most applications , as a Business Partner can be a vendor , a customer , an Employee or a combination of all three.

This approach also makes it easy to control access fungionalitas ‘ self-service ‘ and allow regional analysis and optimization of delivery .

A business partner has one or more locations and one or more contacts , which can be optionally linked to a location . Contacts may have called Interest Area , which form the basis for Customer Relationship Management and allow sales people to organize email – lists ( mailing lists ) to yujuan marketing ( for example , newsletters etc. . ) .

Business Partners may also have relationships with other Business Partners . This allows a Sales Order to be sent to a business partner of the first , and the bills invoice to a business partner that both Dan Payments made by Business Partners are third .


Setup Business Partner
Setup Workflow Business Partner:

As depicted in the Workflow, Business Partner Setup steps are as follows:

1. Creating Business Partner Group
- Common Accounting
- For Reporting Purposes

2. Setup Greeting
- For Business Partners & Contact

3. Determining Payment Term
- For Sales Order and Purchase Order

4. Determining Invoice Schedule
- Summary Invoices for Shipments
- Locations
- Ship – Invoice
- Pay From – To remit

5. Determining Withholding,
- Quality, Tax (1099)

6. Determine Dunning

7. Determining Revenuee Recognition

8. Import Business Partner

9. Creating / Update Business Partner






Agung BS


SI.06. ADemSAWIT Adempiere for Oil Palm Plantations


ADemSAWIT Adempiere for Oil Palm Plantations

ADemSAWIT not forking Or derivative of Adempiere , ADemSawit also not a new ERP software . Adempiere AdemSawit is already in the configuration and modified so that it can meet the needs of the ERP in the oil palm plantation industry . The term itself appears ADemSAWIT inadvertently for the plantation which was very difficult to remember the word ” Adempiere ” , and once in plesetkan be AdemSawit turns them instantly remember . With ADemSAWIT , plantation companies may feel as though using ERP application which is specifically designed for oil palm plantations . What are the requirements for ERP in oil palm plantations ? and what are the things that can be met by Adempiere ? Here I will try to convey ” some ” general requirements necessary in coconut gardens in general sawit.Pada Basically , business processes in the oil palm plantation industry is the same as in other fields of business , especially for backoffice processes such as purchasing , sales , inventory , accounting , etc. . The difference is the need to support the operational needs of the garden where it is not available directly in Adempiere . For that special configuration is required as well as some modifications to the requirements are met .

Purchasing In Industrial estate, usually one office will handle multiple Estate (the name for an area of ​​plantations), where the need for the goods will be met by the head office / branch. In the conventional method or the manual method, from the Estate will publish SPP (Letter Request for Purchase) that once approved by the head of gardens, will be in the fax to the central office / branch Purchasing section, to do next in the process of purchasing goods. This process can be accommodated in Adempiere as the following diagram:

In Adempiere, garden party can directly enter the purchase requisition through the requisition, the purchase of which the next request will wait for approval from the central office, if it is approved it will be converted into PO, followed by receipt of material, invoicing and sales payment.Sales palm oil industry in general not too difficult, because the product sold is generally only 1 product CPO. That is to say almost no issue in the area of sales, because the procedure is quite standard. It must be noted that there is little to prepay the sales order (payment in advance). Seeding basically like-production process in the factory, here it’s just a longer production time is 1 (one) year with the cost components are included each month.
The process begins with the purchase of seedlings sprout, to be treated until ready for planting the age of 12 months, with each month of treatment as standard seed treatment procedure that could require a material / product, as well as the cost of expenses that must be recorded each month.
TBM & TMTBM Transactions on areas of TBM is a record of activities and materials that are used for treating TBM gardens, this could be labor, materials (fertilizers, pesticides, chemicals, etc.), resources (machines, vehicles), and others. Notes on writing activities in the Diary Foreman. In Adempiere, records the activities of the foreman’s Diary can be input so that the system can directly calculate, how much costs already incurred to treat an area of ​​the garden.

Transactions on area TM TM, basically similar to the TBM, it’s just that here there is an additional form of transaction harvest calculations. Calculation of the harvest in each company has different formulas that refer to different regulations and company policy.

Accounting exciting of use Adempiere in plantation industries is we can get accounting reports, without having to re-enter transactions into Accounting software as much done by the companies today. And indeed this is the excess of the ERP application. Conclusion The use of Adempiere in oil palm plantations can increase the efficiency of business processes plantations. Although the original Adempiere is not designed specifically for industrial estates, but with a little creativity and adjustments here and there Adempiere can be implemented properly. Which in this case also requires plantations to more flexible and willing to adapt to the facilities and features in Adempiere.

Agung Budi Santosa,

SI.07. Features on ADemSAWIT


ADemSAWIT Features – Part 1


Features Features ADemSawit actually are features that exist on Adempiere as well, just configured and adapted to the needs of the oil palm plantations . There are some features that are quite Critical to the needs of oil palm plantation industry , such as for the purchase of goods , garden maintenance , Running Account , premium calculation harvest and others . Here I will share about the process of buying goods on the estate , although the process of purchasing goods in each plantation company may differ due to differences in policy and others , but I will try to explain below can at least represent the needs of the needs that exist in oil palm plantations .PurchasingThe process of buying goods on the estate , there are generally two types of procedure of purchase of goods .
a. The first , the purchase of goods purchased locally ( the gardens are in place ) , for example, daily use goods , household items , office stationery , etc which are generally the price is not too expensive . And normally purchase locally is limited to a certain amount , in a sense for the value above should be in order through the central office . For this purpose we can limit the value of the purchase , for example, for local purchases is a maximum of 5 ( five ) million dollars which will be approved ( electronically via the system ) by the Manager of Gardens , the rest must go through the central office .
b . The second is the purchase of goods to be met by the head office / branch office which is usually a garden can serve multiple locations . In the conventional method or the manual method , from the Estate will publish SPP ( Letter Request for Purchase ) that once approved by the head of gardens , will be in the fax to the central office / branch Purchasing section , to do next in the process of purchasing goods .
In Adempiere , this need can be accommodated by using a requisition , which could directly enter the garden through a purchase requisition request , subsequent requests for this purchase will be waiting for approval from the central office , if it is approved it will be converted into PO , followed by receipt of material , invoicing and payment.Untuk facilitate the approval process , the notification process so that we can also create an authorized person ( who gave approval) when logging into the system to know that there are documents waiting approval from him .
In some plantation companies exist that implement the RFQ (Request For Quotation) to purchase certain goods, it can also be accommodated in Adempiere, because the availability of these features. For the item must be made in advance RFQ, inputting responses from each vendor, as well as the final publish selected PO to Vendor.In addition to the above, the rest is the usual general faced in the purchase process, such as a pricelist for the vendor, receipt of partial material, etc. in which this can be done in Adempiere.So overall for goods purchase / purchasing for plantation companies, almost entirely be accommodated by Adempiere.
Here are some snapshots of the process of purchasing goods from the goods until the purchase order request.Here are some snapshots Request Purchase:

Purchase request could not be processed further before getting Approval.


Purchase requests that have been approved can be purcahse the Order


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
Jakarta – Indonesia


Sales Order in ADempiere


SALES ORDER in ADempiere

Just like with any Purchase Order, Sales Order in ERP Adempiere is also optional, meaning that can be used or not, because you can still make an Invoice from Shipment you sent (without having to create a Sales Order). You can create a quote, modify or copy the copy to a sales order and then will generate Customer Shipment (Customer Shipment) or invoice from him without entering all the information again.

Adempiere ERP allows you to handle different payment situations. You can switch between the following payment rules:
• On Credit (with credit) – Payment is included as an Open Item (Item Open)
• Cash (Cash) – Input your generated in Cashbook
• credir Card (Credit Card) – Process Payments
• Chek Or ACH – Payment Process Sales Order through documents for shipment and invoice control, and optionally Receipt. Real state determined by Target Document Type and Document Type used.


Types Document types SALES ORDER .

There are six types of documents that have been defined by Adempiere on Sales Order Process . You can also define your own document types or change existing ones . Document Type determines document sequence and name that can be translated if you use documents with multiple languages ​​. In addition, the types of documents also explain to you the documents which the document will be in touch .

You might want to distinguish between different types of documents , for example
Wholesale and Export , POS and others so that you can create specific types of documents for a particular situation . You can obtain the GL category of types of documents . Thus, Reporting can also be done from that perspective .

The following document types are already defined by the system . They can be renamed according to your needs .

• Proposal : Non – binding offer ( offer is not binding ) , which can be converted manually to another sales document type .
• Quotation : Binding Offer ( Offer Binding ) , which will automatically back up your inventory and can be converted to another sales document type .
• Standard Order : Order Standard , which will automatically back up your stock of goods . Shipment and Invoice can be generated manually .
• Warehouse Order : Items taken with a note Delivery ( Delivery Note ) .
The following types are automatically generates a Shipment or delivery Note . You can create invoices manually .
• On Credit Order : Items were taken with an invoice . This type automatically generate a Shipment and an Invoice . When the goods are paid you can Enter payments manually .
• POS Order : This document type is more flexible . Goods taken with an invoice and payment optional . Payment terms can also be installments . This type automatically generate a Shipment ( Delivery ) , and Invoice and Peyment based on payment terms .
Sale of the above types of document types generally can accommodate various types of sales in the company ( in Indonesian ) , so that the transaction can go as desired .
Generate Sales Order Shipment For Shipping , delivery rules can be described in the following Level Customer ( Customer tab window Business Partner ) :

• Availability / availability ( which is the default ) , means that the Shipment is only generated when there is a stock of goods available in the system .

• Complete Line or Complete Order , meaning Shipment will only be generated when a complete line of Order ( or Order Complete ) may be sent . This option does not allow partial Shipment .

• After receipt , meaning Shipment will be generated when the payment is received .

Note : Items are automatically laid out as a back – order when the Availability option is set and the stocks are not adequate . It can automatically push mengararah into various delivery .
Shipment is produced in a batch process is not automatically generated based on the rules for a particular type of document .
Generate Invoice
To / Due Invoice , Invoice the following rules can be described at Level Customer ( Customer tab window Business Partner )

• After Delivery ( which is the default ) , meaning that the invoice is generated only when the goods have been shipped .

• Customer Schedule after Delivery or Complete Order ( Customer Schedule after Delivery or Complete Order ) , means that the invoice will be generated according to the specified schedule Customer Invoice ( once a month , every week etc. . ) . This option is useful if there are a lot of shipping and you only submit one invoice per schedule .

• Immediate ( Immediate ) , meaning that the invoice will be generated immediately , even if the goods have not been received by the customer .
You generate your invoice ( where ) by the batch ( with multiple choice criteria ) or you choose manually .


Thanks and Regards


“PURCHASING” in Adempiere



Adempiere ERP supports some purchasing functions which are included in the procurement procedures .

You can generate a Purchase Order from a Sales Order and Invoice making ( bill ) or receipt ( receipt ) without having to re-enter all the information needed .

To support this functionality, Adempiere provides ‘Create from ‘ features .

It should be noted that the Purchase Order is optional ( can be used or not be used ) , considering you can make without creating an invoice or Purchase Order Shipment . Matching ( matching ) to the Purchase Order is also optional . Matching is necessary between Shipment and Invoice Matching . If you use the ‘Create from ‘ , Matching will be done automatically. If not me ‘match ‘ it , some will not do accounting transactions such as the transfer amount invoiced value of the un – invoiced receipts to receipts .

Purchase Order is a control document in terms of Receipts and Invoices . Purchase Order is not always necessary to perform Receipts . Depending on the policy of your company , manufacture of Purchase Orders may be is a must ( mandatory ) , but in Compiere is optional . Her important aspect is possible to enter your receipt ( if you have a Purchase Order or not ) and continued business . Please note that only Products that can be done Receipt .

You can create a Vendor Invoice from Receipt that you created ( Please note that the invoice price is based on the list price of the Business Partner )

It is also possible to do the reverse way in which the invoice is inserted first ( if you take it with Shipment ) and make receipt of the invoice . When processing the Receipt Inventory will be updated as appropriate.


Thanks and Regards
Jakarta – Indonesia

Setup Paper Size in Adempiere


Format Paper Size Print Setup in Adempiere

By default Adempiere will make a report in A4 format. Although the size of an A4 paper size the most by Adempiere users in Indonesia, but if you want to format another paper size eg A5, A3, F4 and others, you can configure in the Application Dictionary. To perform the configuration please follow these steps:

1. Login with the System Administrator role
2. Log window to the System Admin> General Rule> Printing> Print Paper.


3. Create a new record. Enter a name and description (if desired).

4. Checkbox Landscape paper orientation will determine: whether the Landscape or Portrait.

5. Then enter the parameter validation code which will determine the size of the paper that you created (for full list please see below)

6. Dimension unit, Size X and Size Y simply ignored.

7. Left, Right, Top, Bottom Margin specified in units of 1/72 inch. Please enter the value you want.

8. Save

9. Done!

Setting the paper size in the Print Format

Further to wear Print Paper you just created:
1. Open the Print Format window.


2. Create a new Format or Print, Print Format Choose one that you want to modify.

3. On Paper Print column, select the new size you define.

4. Done .

Good luck!!

List Validation Code :
• iso – a0
• iso – a1
• iso – a2
• iso – a3
• iso – a4
• iso – a5
• iso – a6
• iso – a7
• iso – a8
• iso – a9
• iso – a10
• iso – b0
• iso – b1
• iso – b2
• iso – b3
• iso – b4
• iso – b5
• iso – b6
• iso – b7
• iso – b8
• iso – b9
• iso – b10
• iso – designated – long
• italian – envelope
• monarch – envelope
• personal – envelope
• na – number – 9 – envelope
• na – number – 10 – envelope
• na – number – 11 – envelope
• na – number – 12 – envelope
• na – number – 14 – envelope
• na – 6×9 – envelope
• na – 7×9 – envelope
• na – 9×11 – envelope
• na – 9×12 – envelope
• na – 10×13 – envelope
• na – 10×14 – envelope
• na – 10×15 – envelope
• na – 5×7
• na – 8×10 • jis – b0
• jis – b1
• jis – b2
• jis – b3
• jis – b4
• jis – b5
• jis – b6
• jis – b7
• jis – b8
• jis – b9
• jis – b10
• iso – c0
• iso – c1
• iso – c2
• iso – c3
• iso – c4
• iso – c5
• iso – c6
• na – letter
• na – legal
• executive
• ledger
• tabloids
• invoice
• folio
• quarto
• japanese – postcard
• oufuko – postcard
• a
• b
• c
• d
• e




Agung BS

Jakarta – Indonesia


Custom Report in Adempiere



The one that makes the process easier reporting in Adempiere is the facility to Customize reports in accordance with what we want. Adempiere allows you to customize your report and customize it to your needs. With this facility you can make the appropriate report forms that are typically seen by the user, such as the Indonesian-style report format.
In the report, you can change the following elements:
• Display Order
• Sort Order
• Format Item

- Field, Image, Text, Print Format
- Alignment% Width / Height
- Calculate Sum – Average – Count
- Group by (requires Order by sorting)






Print format

Open the Print Format window to customize your report by clicking on the General Rules, or alternatively click on the Print button on the toolbar Customize Report on the Report.
Note : When you open the Print format using the menu option you have to close and reopen your report to see the changes that have been made ​​. If you open the Print Format Report reports using the Customize button you will be shown again with the changes that you have made when you close the Print Format .You see the Report Name , That in accordance with the table where the field is located .Reports indicate the field of view is the view that is used to produce this report .

Remove checkbox option on the Form to print a columnar List Report ( Register columnar report ) . Tick ​​was to print a form . Customizing The format will be discussed in the next section , Customizing Format . A format having individual elements with spatial information ( eg, invoices , checks ) . A columnar list report having individual columns ( example : a list or inventory invoice lines) .

Print Table Format determines the Fonts , Colors of the table are in print .

Check the Standard Header / Footer checkbox to show the standard of the Header and Footer are used . If you do not want to use the standard header , must be explicitly defined .

Print Paper Size illustrate , Orientation and Margins ( edge lines ) about the document .

Print Fonts Fonts are used to print . Print Color is the color to use for printing .

Button Copy / Create allows you to copy a print format or create a new Print Format of a Table .

Display Order
Change to the tab order to change the display order of the elements in the report and tailored to your needs:
To add an element into the report, click on the various options available list and move them to the list order by clicking the arrow on the right side.To change the order of an element by using the selection arrows up / down. To remove an element from select Reports and click on the arrow to the left. Save your changes. The changes will take effect immediately on your next statement.Move to the Sort Order tab to change the order of the order and adjust it to your needs:
In addition you can also set the format of the report, adding logo / Text, set the location of the fields and others, who will try to be discussed later.
Jasper Reports
If the facility is in a custom report that Adempiere is still not enough, you can use custom reports using Jasper Reports. By using Jasper Reports reports you can create more complex designs, such as for accounting and taxation Indonesia. To help design the report would normally use another utility assistance, for example iReports.
Hopefully next time I’ll try to write about creating reports using Jasper Reports and iReport.
Agung Budi Santosa
Jakarta – Indonesia