Decimal precision "Product Price": 4 digits --> use OOE to show only 2 digits for unit price
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:
- 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.
- 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.