Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odgovori
4916 Prikazi

Hello,


I am working on a report that contains a table with a 'Total Quantity' cell (A total of all the line quantities). I'd like to show this non-monetary value in 'Words'.



Any help is appreciated, thanks.

Avatar
Opusti
Best Answer
 In Py
      
  def conv(self, consultation_fee):
        converted_fee=float(consultation_fee)
        convert=self.env.user.company_id.currency_id.amount_to_text(converted_fee)
        return convert

In XML

 <td>
    <span> Amount In Words </span>&#160;:&#160;<span t-esc="doc.conv(doc.consultation_fee)"/>
 </td>

Avatar
Opusti
Best Answer

Hi,

Try below code

#in .py

from num2words import num2words

#define a function in python to convert

def qty_to_text(self, total):
qty_txt = num2words(total)
return qty_txt

#In .xml

<span t-esc="docs.qty_to_text(docs.total_quantity)"/>

Regards

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
apr. 24
2239
0
okt. 21
5127
1
sep. 21
6323
0
mar. 17
3278
2
apr. 23
8580