Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
3465 Weergaven

Hi i am using odoo 14 ce , in purchase order qweb report under subtotal the price comes for inr  ₹ 317,566.00 i want to change this to  ₹ 3,17566.00 how can i do this using python or xml code is it possible


Avatar
Annuleer
Beste antwoord

Hi @jo 

Please find code in comment.

And also attache Image link. 

https://drive.google.com/file/d/1HESl2CevyxtbjMvBychmUH2RTrLE-lbw/view?usp=share_link


I Hope this will help you. 

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

Avatar
Annuleer

For changing the seperators you will need to do the following:

Activate the developer mode from Setings.
Go to Settings > Translations > Languages
Go to Form view of your current language

In the `Separator Format` field, set [5,0]
- Here the format is to specify seperator placment counting from decimal seperator:
eg: if the value is 550000.00 it will display 5,50000.00
- For more control over seperator placement keep adding place ie: [5,3,0]
eg: if the value is 5127000040.00 it will display 51,270,00040.00

Odoo will add sperator placement from right to left so 5,3,0 -> from decimal places leave 5 digits -> add seperator -> leave 3 digits -> add seperator, then keep repearing every 3 digits.

The last value 0 is to repeat the last sequence so keep repearing every 3 digits id [2,3,0].
- ie: if the value is 123456879.00 > 1,234,568,79.00
change 0 to -1 to avoid repeating [2,3,-1]
- ie: if the value is 123456879.00 > 1234,568,79.00

Gerelateerde posts Antwoorden Weergaven Activiteit
2
okt. 23
2935
2
jun. 22
3487
0
mei 22
233
2
apr. 22
3646
1
mrt. 22
5765