Odoo货币换算

Question

这些是我的import_payment.py中的字段

transaction_date = fields.Date(string="Transaction Date",
                               required=True)
facts_id = fields.Char(string="Student ID",
                       required=True)
paid_in_lei = fields.Float(string="Amount Paid in LEI")
paid_in_euro = fields.Float(string="Amount Paid in EURO")
amount = fields.Float(string="Amount")
error_msg = fields.Char(string="Error Msg")
invoice_number = fields.Char(string="Invoice No")
invoice_id = fields.Many2one(string="Invoice",
                             comodel_name="account.move")
payment_id = fields.Many2one(string="Payment",
                             comodel_name="account.payment")
company_id = fields.Many2one('res.company', default=lambda self: self.env.company.id)
currency_id = fields.Many2one('res.currency', related='company_id.currency_id', readonly=True, store=True)

谁能帮我把"paid_in_euro“字段转换成基于"transaction_date”的"exchange “字段，并将其插入到”RON(基本货币)“中的” based “字段中。

对不起，我是新来的奥多。任何帮助都是非常感谢的。

Answer 1

您可以使用odoo的货币换算功能

from_currency._convert(from_amount, to_currency, company, date)

Answer 2

首先，将amount字段转换为compute字段，并使其依赖于paid_in_euro

amount = fields.Float(string="Amount", compute='_amount_in_base')

@api.depends('paid_in_euro')
def _amount_in_base(self):
    if self.paid_in_euro:
        amount_convert = company_currency.with_context(date=self.date).compute(self.paid_in_euro, convert_currency)