Skip to Content
Menu
This question has been flagged
2 Replies
4929 Rodiniai

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.

Portretas
Atmesti
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>

Portretas
Atmesti
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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
bal. 24
2243
0
spal. 21
5135
1
rugs. 21
6333
0
kov. 17
3294
2
bal. 23
8595