Hello,

Being new to OpenERP, I am struggling with changing the decimal accuracy of Cost Price when defining a product. We typically need 5 decimal places for some of the smaller components and I am unable to modify the default 2.

Version 6.0.1.

I modified the standard_price in table product_template to numeric(16,5), but the webclient is locked at 2 decimal places. When I enter more decimal places the webclient rounds to 2 decimal places.

Any help would be appreciated.

Thanks,
Radek

Change the price_accuracy option on your server command line or in your server configuration file.

http://doc.openerp.com/v6.0/developer/1 ... _line.html

After you've changed it, restart the server and either create a new database or migrate your existing database (File: Databases: Migrate Databases).

I tried that. There is no option (in V6) for that particular command line option.

Has anyone been able to do this in V6?

Thanks,
Radek

Sorry, I didn't know that had changed in v6. After a bit of digging, I found the following:

1. Make sure you have the extended user interface. The setting is on your user screen.
2. From the Administration menu, choose Customization: Database Structure: Decimal Accuracy.
3. There are several different settings for different fields in the system. You asked about the cost price of a product, and that one is set by the "Account" setting. Obvious, right? I had to check the source code to figure that out.
4. Open the entry you want to change, type the new value for the digits field, and save it. Don't change the Usage field, or it will stop working.
5. Close the product screen and reopen it. The cost price field should now have the number of digits you asked for.

I'll add some documentation on the price accuracy configuration to this page:
http://doc.openerp.com/v6.0/book/6/6_16 ... icing.html

Feel free to suggest other places in the documentation where it might fit better.

Don

Worked perfectly. Yes, the Account setting was not obvious.

Thanks for the help.
Radek

OK, the documentation is updated, and I reported a bug saying that the cost field should use the Purchase Price setting instead of the Account setting. The bug got confirmed and assigned, so it will probably get fixed.

How can I change accuracy in Bill of Material view and pdf report?
It is not possible to change it through Decimal Accuracy module.

I assume you want to change the precision of the mrp_bom.product_qty field. That isn't configurable, you would have to edit the source code in the addons/mrp/mrp.py file. The mrp_bom._columns dict defines 'product_qty' as a float and leaves the digits unspecified. If you add the parameter digits=(16, 5), for example, you would get 5 digits of precision.

I'm not sure if that setting will carry through to the report, but it should change the view and the database.

Oh, and the bug I reported for this thread has been fixed.

there is a module for that mrp_bom_decimalprecision

Hope it helps you.