Odoo v10 display amount in company currency in purchase tree and form view

Question

I am using Odoo v10 .

As we know in purchase.order, there is a base (Monetary) field amount_total which contains value of total amount of a Purchase Order based on (self) currency_id .

Now, I create a new float field home_currency_amount_total in purchase.order .

home_currency_amount_total = fields.Float(string='Total Amount in company currency', store=True)

How can i have a value in this field based on company currency? i.e. I want to have a corresponding value in company base currency and can be used in my tree & form views.

I am new to Odoo and I wonder if there is a "shortcut" (e.g. a built-in compute method) instead of I have to write up related codes.

Answer 1

There is a built-in method for conversion of currency.

Eg.

  @api.model
  def _compute(self, from_currency, to_currency, from_amount, round=True):
     if (to_currency == from_currency):
        amount = to_currency.round(from_amount) if round else from_amount
     else:
        rate = self._get_conversion_rate(from_currency, to_currency)
        amount = to_currency.round(from_amount * rate) if round else from_amount * rate
     return amount

So, if you want to calculate the conversion you can use this method.

This method takes 3 arguments, first from currency, second to currency and amount which you want to convert as a third argument.

Eg.

self.env['res.currency']._compute(order.currency_id,order.company_id.currency_id,order.amount_total)

Update :

Create you field like this.

home_currency_amount_total = fields.Float(string='Total Amount in company currency', compute="_compute", store=True)

@api.depends('order_lines.price_subtotal','company_id','currency_id')
def _compute(self);
    for order in self:
        home_currency_amount_total =  self.env['res.currency']._compute(order.currency_id,order.company_id.currency_id,order.amount_total)

Answer 2

You can do it using following method.

class PurchaseOrder(models.Model):
    _inherit = "purchase.order"

    @api.multi
    @api.depends('amount_total')
    def get_amount_in_company_currency(self):
        for purchase_order in self:
            if purchase_order.currency_id.id!=purchase_order.company_id.currency_id.id:
                currency_id = purchase_order.currency_id.with_context(date=purchase_order.date_order)
                purchase_order.home_currency_amount_total = currency_id.compute(purchase_order.amount_total, purchase_order.company_id.currency_id)            
            else:
                purchase_order.home_currency_amount_total=purchase_order.amount_total
    home_currency_amount_total = fields.Float(string='Total Amount in company currency',compute="get_amount_in_company_currency",store=True)

In above code we have create one compute field store True, it means value will be store in the database.

When amount_total will change at that time system will calculate home currency amount.

In method we have checked if company currency & purchase order currency is different then system will compute currency amount.

In odoo base module on method is available for compute currency, in which you can pass date in the context.

purchase_order.currency_id.with_context(date=purchase_order.date_order)

Based on context date system will take currency rate, if you not pass any date then system will take current date rate.

This will help you.