This question has been flagged
2 Replies
15841 Views

I am using 4 digits decimal precision for the Product Price, because otherwise some prices don't add up properly under our purchase orders. However, it would be preferable if I could only show 2 digits behind the "," seperator for invoices and sale orders.

Is it possible to either:

  1. Use the Open Office Editor to change the way the Product Price field is displayed, and make it leave out the last two characters of the value in this field. Or filter out the last two digits behind the "," seperator.
  2. Split up the decimal precision in "Product Price Purchase" and "Product Price Sale". Under "Decimal Precision" there is no option to select values, and "Product Price" is just entered as plain text. I don't know if other values can be used here?

I found <para style="terp_default_Right_9">[[ formatLang(l.price_unit ) ]]</para> in the .rml file of print_invoice, under Account.

I also saw other fields such as: <para style="terp_default_Centre_9">[[ formatLang(l.discount, dp='Account') ]] </para>

I figure "dp='Account'" means it is dependant on the decimal precision under "Account". I formated price_unit as: <para style="terp_default_Centre_9">[[ formatLang(l.discount, dp='Account') ]] </para>

Next I updated my module list, and the Account module - but sadly it is not working, and still showing 4 digits behind the seperator. Under Decimal Precision --> Account I have 2 digits. I guess I need to make a change elsewhere as well.

Avatar
Discard
Best Answer

Leave accounting/global to 2 decimal and change product decimal to 4 according to this :

In the User Access rights, enable "Technical Features". Go to Settings > Technical > Database Structure > Decimal Accuracy > Product Price

A more detailed answer can be found here : help.openerp.com/question/1299/how-to-change-products-cost-decimal-precision/

Don't forget to restart the server for the change to take effect.

Thanks to help.openerp.com/question/6166/change-product-price-precision/ (had to remove link because of insufficient karma)

Avatar
Discard

I'm not sure about other versions of Odoo,but you don't have to restart if you have Odoo 9.0

Best Answer

Hi, i have a similar question => I am using 5 digits decimal precision for the Product Unit Price, because otherwise some prices don't add up properly under our purchase orders. However, it would be preferable if I could only show 2 digits behind the "," seperator for invoices and sale orders.

My Odoo version is 15

Avatar
Discard