跳至內容
選單
此問題已被標幟
1 回覆
9334 瀏覽次數

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?

頭像
捨棄
作者 最佳答案

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
頭像
捨棄

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

is this still not possible in Odoo 15?

相關帖文 回覆 瀏覽次數 活動
1
12月 18
2827
1
1月 18
5853
0
7月 17
4703
0
5月 17
2571
3
6月 23
10498