User can set multiple currency in website Admin setting.
User can change website currency from here.
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.
Let’s check into our database what is by default stored in OpenERP table.
Currency ID is stored in Pricelist Table.
In case if we want to change currency, we have to open company form and change it.
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.
After installing module, we can see there is an option into company form to change currency globally.
There are 2 values in option field: (1) Selected Company (2) All Companies
After executing this process, we can check that changes have been affected in our database also.
With the help of this solution, we can update currency in our database.
Download Link: https://github.com/acespritech/change_currency
Sometimes it may requires that you don’t want to see number with decimal into OpenERP. OpenERP is using “Float” datatype everywhere and it is not feasible and possible to change datatype. For example, in multi currency environment, you may require to remove decimal numbers in some of the currency. To overcome from this problem, we have come with generic solution which makes your work very easy.
Let’s see some OpenERP form where you can see numbers with decimal before using this feature.
We have added new field for configuration into language.
This is “List View” with float type fields and also with sum of those values.
This form contains numbers with decimal into “List View” and also display with currency in Total.
This is form view with some float type fields.
Now, we are going to make unchecked “View Decimal” field from Language form. And reload OpenERP interface.
Now, it is very easy for end users to disable “decimal points” from OpenERP.