Menu

Допомога

0

How to change total amount in purchase qweb report ' , ' in odoo for different currency

Avatar
jo

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


Аватар
Відмінити
1Відповідь
1
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

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

1Коментар
Аватар
Відмінити
Avatar
Jainesh Shah(Aktiv Software)
-

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