Multi currency management in ADempiere


Problem Statement:

In today’s business environment, majority of the business runs in global environment,  i.e. business having partners ( be it a customer or vendor ) will be from different parts of the world. As partners are from different countries, most likely they operate with different currencies compared to the currency of the business. Whenever a business use an ERP, of course the business need a mechanism in the ERP to support multiple currencies and provide seamless conversion of money while doing transactions. 

ADempiere has very good currency management and it supports transactions in multiple currencies. In fact it has the ability to make any transaction in any currency other than the one supported by your accounting system. Also, it has very good support for configuring fast changing currency conversion rates.

Scope Of Article:

This article talks about how ADempiere supports transactions in different currency compared to the base currency of the Business.

Technology:

ADempiere 370

Details:

Let us take an example of software consulting company which is located in United states and it has customers in Europe and Asia Pacific. As company is located in US, its base currency is USD and it bills customers located in Euro zone who runs with EUR currency.

Step 1: Basic setup

  1. Login into ADempiere application with client adminLogin
  2. Now Open ‘Accounting Schema’ window at Performance Rules -> Accounting Rules.AccountingSchemaHere the currency filed indicates the base currency of the company i.e. on currency in which accounting runs.
  3. As ADempiere reference data contains most of the currencies, you dont always need to create any new currency. For example in case of Euro, you need to check whether Euro currency is there or not (in ‘Currency’ window)Currency
  4. Now define currency conversion rate between USD and EUR, in ‘Currency Rate’ window.CurrencyConversionHere we configured 1 USD = 0.8 EUR and it also means 1 EUR = 1.249 USD. There is a way to mention from date and to date as conversion rate changes very often. Select currency type as ‘Spot’. With this conversion rate is successfully configured.
  5. Now go to ‘Price List’ window and create a price list which operates in EUR currencyPricelist
  6. Now create a price Version for the above created price listPriceListversion
  7. Now create product with name ‘Pentaho Consulting 20 hours’ as serviceProduct
  8. Now go to ‘Price’ tab in same and create price for this service in ‘Consulting Price List Euro’ price list versionproductprice
  9. Now create a business partner with name ‘Green Energy’ who is using servicesBPPriceList
  10. Associate consulting price list this business partner. productpriceWith this basic setup is completed to start creating transactions of different currencies to the base currency of business

 

Step 2: Create Transactions

  1. Create customer invoice for ‘Green Energy’ and they expect invoice in EURO currency ( Make sure you create location for ‘Green Energy’ business partner )CreateInvoice
  2. Create invoice line for ‘Pentaho Consulting’ productCreateInvoicelIne
  3. Now complete invoice and see posting details.CompleteInvoice Invoice value is 1000 EUR but it is posted in accounts as 1249
  4. Now make  half of the payment for the invoice in EUR. When you select invoice automatically, the currency of the invoice will be defaultedFirstPayment
  5. Now complete payment and see posting. The Posting has happened in USD and conversion was done as per configurationPaymentCurrencyChange2
  6. Now make rest of the payment, create new payment and see the open invoice amount. it shows open amount 500 as half of the invoice is already paid, now select this invoiceRestPayment2RestPayment
  7. Choose base currency i.e. USD rather than invoice currency. Automatically Payment amount is changed as per conversion rate definedPaymentCurrencyChange
  8. Now complete payment and see the posting. Now posting does not have conversion as transaction is happend in base currencyCompletePayment
  9. Check whether invoice is ‘Paid Of’ or notInvoicePaid

Summary:

ADempiere supports multiple currencies and with simple configuration your business can operate very smoothly and effectively in global environment. We hope you enjoyed creating transactions in different currencies and your accounting continue working as per the defined standards.

Walking Tree promotes ADempiere and we support the users as well as the developers to ensure that the business is able to take complete advantage of ADempiere’s wonderful capability. In case you are looking for a professional assistance then do visit our website to get in touch with us.

Reference

Tagged with: ,
Posted in ADempiere
One comment on “Multi currency management in ADempiere
  1. K I says:

    Question please: Can I report in a different currency than the base currency in ADempiere?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out https://walkingtree.tech/index.php/blog for all latest blogs.

Sencha Select Partner Sencha Training Partner
Xamarin Authorized Partner
Recent Publication
%d bloggers like this: