Posted in Accounting, Configuration, OpenERP, Sale

How to change currency globally in OpenERP 7.0


Here we are discussing about a common currency problem which we are facing many times.

We are installing OpenERP, creating database and install modules as per your requirement. During this process we have to select currency which will be used in all our database calculations but let say if we forgot to select right one then it may affects in our daily calculations. By default, OpenERP configure ‘EUR’ currency for database and your company has different currency at that time this solution will work.

1_OpenERP_Currency

Let’s check into our database what is by default stored in OpenERP table.

2_company_currency_database

Currency ID is stored in Pricelist Table.

3_database_before_currency_change

In case if we want to change currency, we have to open company form and change it.

4_currency_after_change

5_currency_val_db

Once we save above form, we can execute query on pricelist table and we can see that there is no change.

We have developed a module to overcome from this problem.

6_module

After installing module, we can see there is an option into company form to change currency globally.

7_currnecy_menu

There are 2 values in option field: (1) Selected Company (2) All Companies

8_currency_change_form

After executing this process, we can check that changes have been affected in our database also.

9_db_val_after_change

With the help of this solution, we can update currency in our database.

Download Link: https://github.com/acespritech/change_currency

Advertisements

Author:

Specialised in OpenERP/CRM Solutions, software development, Web development, E commerce solutions & other open source solutions.

6 thoughts on “How to change currency globally in OpenERP 7.0

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