コンテンツへスキップ
メニュー
この質問にフラグが付けられました
1 返信
9368 ビュー

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
2876
1
1月 18
5900
0
7月 17
4725
0
5月 17
2597
3
6月 23
10507