Meet Us at GITEX Stand #SRE-22, Sheikh Rashid Hall, India Pavilion

Schedule Meeting
      +91-79-2975-0867,+91-903-347-2982,+91-987-935-4457   contact@serpentcs.com

Change Currency at Global level in OpenERP 7

Hello Readers, By default OpenERP configures EUR as its default currency, if you are working other than EUR currency, below are the simple steps of configuration of changing currency at global level.

  • Give necessary access rights to your current user:
    • Multi Currencies
    • Sales Pricelists
    • Purchase Pricelist .
      Change currency at global level

  • Go to your current company “Settings → Companies → Companies”:
    • Select "your company" and go to third tab “Configuration” and assign your country's default currency. 
      Change currency at global level

 
  •   If company is dealing with multi currency, configure “Gain Exchange Rate Account” and “Loss Exchange Rate Account” for fluctuations of currency rate change gain and loss. 
    Change currency at global level

 
  • Go to Sales → Configuration → Pricelists → Pricelists(This step would only be needed only if Sales module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Select Public Pricelist and assign your country's default currency as highlated in below screen
     
Change currency at global level

  • Go to Sales → Configuration → Pricelists → Price Types:(This step would only needed only if Sales module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Go to Public Price and assign your country's default currency in currency field. 
      Change currency at global level

       
    • Go to Cost Price and assign your country's default currency in currency field. 
      Change currency at global level

 
  •   o to Purchase → Configuration → Pricelists:(This step would only needed only if Purchase module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Select Default Purchase Pricelist and assign your country's default currency in Currency field 
      Change currency at global level


By changing the above configuration at global level mainly objects(entities) affected which are Company(res.company), Pricelist(product.pricelist), Pricelist Type(product.pricelist.type)

Importance of all fields in Currency form: 
Change currency at global level

 

Currency : Code of currency. For e.g. for US currency global code is used USD. Current Rate : This field will display the current rate of currency compared with the base currency. Company : Currency and all its configuration defined for selected company. Price Accuracy Rounding Factor : The computed currency will be multiple of this value. Symbol : Currency sign, to be used when printing amount. Miscellaneous Base : If true, it will become the reference for the other currency. If this field checked the Current Rate should be 1.   Usually this field should be checked in default currency of company. Make sure only one currency has this set to be True! Active : If the active field is set to False, it will allow to hide the currency without removing it Rates :This is one2many list of rates, where by adding a new rate with date, the respected Rate will be applied everywhere at global level. When a company is working with multi currency, we have to keep system updated with latest currency rates. Now managing currency updation manually become very tedious task. Here we have a module which updates currency at FIXED interval basis. You can found that module at following branch:

bzr branch lp:account-financial-tools

Install module Currency Rate Update
Change currency at global level

By installing this module a new tab will be added in Company Form at following path: Settings -> Companies -> Companies -> Select "Your Company" from list of companies -> Go to forth tab "Currency auto update configuration". and do below configuration:
  • Automatic update of the currency this company : True
  • Currency update frequency : Day(s) or  Week(s) or Month(s)
  • Multi company currency : True 
    Change currency at global level

Now add by which webservice you want currencies get updated automatically: Here we have 4 webservices by which we can update currency, choose anyone of them:
  • Admin.Ch
  • European Central Bank
  • Yahoo Finance
  • Narodowy Bank Polsky
We have selected Yahoo Finance, and added number of currencies which we want to update by clicking on "ADD" button. 

Change currency at global level

All currency data will look like as below: 
Change currency at global level

  
We can manually update update currency by clicking on "Refresh currencies". All currency rates will be updated based on your default Company Currency and also automatically updates rates based on currency update frequency(here in our case it will update on daily basis). Hope this blog have helped you in multi currency as well as auto update currencies. Thanks and Regards! Serpent Consulting Services Pvt. Ltd