CODEWITHSUNDEEP
odooodoo-9
Ghassen Rjab
Ghassen Rjab

Reputation: 713

Decimal precision in odoo

I have a problem in Odoo 9 Community Edition, I changed the decimal accuracy of the database fields to 3 as stated to below enter image description here And also the rounding in Accounting/Currencies. Everything works fine only in these two interfaces:

1: Sales orders interface

enter image description here

2: A sale order

enter image description here

The good thing is that in invoicing, everything is fine:

1: Client Invoices

enter image description here

2: An invoice

enter image description here

Is there any solution to this issue?

Upvotes: 3

Views: 7483

Answers (3)

Astyan
Astyan

Reputation: 324

Odoo 14 Answer: If you want to find the "Technical" menu mentioned above, you have to enable the "Developer mode" In order to enable it => Go in the Setting menu scroll at the end of the general settings screen. You'll find some links that will enable developer mode and then the Technical menu will appear.

Upvotes: 0

CKwok
CKwok

Reputation: 26

In Odoo 9, all the fields related to amount have changed the field type to "Monetary". Most of them are formatted using widget="monetary". In order for it to work according to the currency setting, "currency_id" field is required. Hence "currency_id" field must be included in the view. For example, in sale.order.form view

. . .
<tree string="Sales Order Lines" editable="bottom" decoration-info="invoice_status=='to invoice'">
    . . .
    <field name="price_subtotal" widget="monetary"/>
    <field name="currency_id" invisible="1"/>           <!-- Add this line -->
    . . .
</tree>

The subtotal will then be formatted according to the currency of the sales order.

Upvotes: 1

Thanh nguyen ngoc
Thanh nguyen ngoc

Reputation: 21

You go to Settings -> Technical -> Database Structure -> Decimal Accuracy then change what you want !

Upvotes: 1

Related Questions