Problem With Decimal Accuracy?

reports noob

1 Odpovědět

8014 Zobrazení

Ideas constructivas del Noroeste S.A. de C.V.

I got a problem with the decimal accuracy in a quantity field, when i go to database/structure/decimal_accuracy and set the accuracy to '0' of the product unit of mesaure it doesn't work on the report, the module show me the field with the accuracy to for example 5 and the printed report 5.00. i think it's strange cause when a i set accuracy to 3 or x number of decimals the report show me the value 5.000 but it doesn't work with 0. Any ideas?

Ideas constructivas del Noroeste S.A. de C.V.

Autor Nejlepší odpověď

i get a solution add this python validation to the rml file in the qty field. it will be something like this: [[ ' % .f ' % product_qty]] this set the float as an integer, then will be show in the pdf file. the database/structure/decimal_accuracy only affects the field decimal accuracy showed in the UI.

Hope this will be useful to other of you. Regards.

Luke Branch

@Charlie,

Thanks for sharing that, it really helped me out with Aeroo reports and decimal accuracy on QTY fields.

I have another issue, Aeroo is only printing one decimal place (eg. 0.5) when the database is setup to two decimal places (eg. 0.50), and I need to print the correct decimal accuracy on my reports which is two decimal places. Do you have any suggestions on how to get correct decimal precision for something like this?:

get_price(product, pricelist)

Odoobot

i don't use aeroo reports but try to make a bracket in rml like this e.g. [[ formatLang(o.unit_price, digits=get_digits(dp='Account') ) ]]

2015-08-17 9:17 GMT-07:00 Luke Branch <luke-weairsoft-com@mail.odoo.com>:

@Charlie,

Thanks for sharing that, it really helped me out with Aeroo reports and decimal accuracy on QTY fields.

I have another issue, Aeroo is only printing one decimal place (eg. 0.5) when the database is setup to two decimal places (eg. 0.50), and I need to print the correct decimal accuracy on my reports which is two decimal places. Do you have any suggestions on how to get correct decimal precision for something like this?:

get_price(product, pricelist)
--
Luke Branch
Sent by Odoo S.A. using Odoo about Forum Post False

Carlos Fernando Mexia Valenzuela

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
Code for page number in Body of Pdf report reports	2 říj 25	4952
How to increase the width of a column on odoo quotation PDF? reports	1 říj 25	2661
Odoo Online (SaaS 18.4 Enterprise) – How to modify invoice report header without affecting other reports but keep default table content reports	1 srp 25	3282
Odoo .SH V17 how do I migrate a report from staging to production? reports	1 dub 25	3855
List of Sales in a Report reports	1 čvc 24	3779

This question has been flagged

Enjoying the discussion? Don't just read, join in!