How to show value from currency in account_invoice?

Question

I try to put the value from currency "rate" to my account_invoice rows.
my field looks like this:

show_rate = fields.Char(related="res_currency.rate", store=True)

this gives me everytime an error with res_currency.
I want to see the "rate" field in my account_invoice rows. How can I manage that?

thank you

Janeesh · Accepted Answer

It's not fair to use related field here. Related field will write back the value to the currency table.
If you only need to see the value, you could use a functional field.
@api.one
@api.depends('currency_id', 'currency_id.rate')
def _compute_amount(self):
self.currency_rate = self.currency_id.rate
currency_rate = fields.Float('Currency Rate', compute='_currency_rate', store=True)

Post Terkait	Replies	Tampilan
Recalculate invoice totals after past currency rate has changed accounting invoice currency rates	1 Nov 20	3780
Convert Existing Odoo Data from USD to PKR (Primary Currency Change) accounting currency	0 Jul 25	732
Unselect the Show in Invoices Footer option Diselesaikan accounting invoice	3 Feb 25	2985
invoice number prefix Diselesaikan accounting invoice	1 Nov 24	2765
configure Invoice due date as 30 days from the date of creating the Invoice accounting invoice	1 Des 23	2611

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!