Skip to Content
Menu
This question has been flagged
1 Reply
9080 Views

Hi All,
Anybody know how to set multi currency in same report like,  I want to display product price in "INR" and also in "USD" in same report. 

Any idea how to achieve this?

Avatar
Discard
Author Best Answer

Hi All,

I have found solution for multi currency in same report,

in xml,

      <span t-esc="doc.convert(doc.from_currency_name,
      doc.to_currency_name, doc.amount_total)" />

you have to send from and to currency name from the report xml file,

and in py,

      URL =
'http://finance.yahoo.com/d/quotes.csv?e=.csv&f=sl1d1t1&s={from_curr}{to_curr}=X'
      YAHOO_CURRENCY_CONVERTER =
      'http://finance.yahoo.com/connection/currency-converter-cache?date='
def convert(from_curr='', to_curr='', amount=0, date=None):
    if from_curr.lower() == to_curr.lower():             return amount
    if not date:
        data = _get_data(URL.format(from_curr=from_curr, to_curr=to_curr))         if data:             exchange = data.split(',')             try:                 converted_amount = u'{0:.3f}'.format(round(float(exchange[1]) * amount, 3))                             return float(converted_amount)
            except (IndexError, ValueError):                 pass
        return 0
Avatar
Discard

Could you post the full source code of these two files with your modifications?

is this still not possible in Odoo 15?

Related Posts Replies Views Activity
1
Dec 18
2592
1
Jan 18
5567
0
Jul 17
4442
0
May 17
2401
3
Jun 23
10242