Odoo Dual Currency Invoice

Background

Odoo Accounting (15e in my case) can be used for managing Indian GST account. If you have customers paying in non INR currency, as per India's GST law your invoice needs to quote amount in both foreign currency and INR (equiv. RBI reference rate at that day).

Odoo invoices are highly configurable, but still by default you can't include invoice total in dual currencies. In Odoo this can be done by manipulating correct Views. Earlier I have used Zoho Books, where this can't be implemented, unless you are willing to render invoices using external program.

Let's see how would you accomplish this in Odoo 15e. I think this should work for other versions as well, but I haven't tested that.

Steps

Activate the developer mode

First you will need to activate the developer mode. Please follow this link for official guide on that.

Finding correct view

Now you will need to find the correct view to manipulate invoice PDF generation. Please follow these steps :-

• Go to Settings
  
  
  
  
  
• Open menu Technical > Views
  
  
  
  
  
• Find view named report_invoice_document. Open it.
  
  
  
  
  

Editing view (before Odoo 17)

Click on edit button at the top. Find line number 127 and paste code below after that.

1
2      <!--Amount in INR-->
3      <tr>
4        <td>
5          <strong>Total (INR)</strong>
6        </td>
7        <td class="text-right">
8          ₹ <span t-esc="o.amount_untaxed_signed" />
9        </td>
10      </tr>
11      

Editing view (Odoo 17 and beyond)

Click on edit button at the top. Find line number 183 and paste code below after that.

1
2        <!--Amount in INR-->
3        <tr>
4          <td>
5            <strong>Total (INR)</strong>
6          </td>
7          <td class="text-end">
8            ₹ <span t-esc="o.amount_untaxed_signed" />
9          </td>
10        </tr>
11        

After this, save this view. Now your invoice PDF report will include total amount in both INR and customer's currency.