Indeed, when we use price lists in the Sales application, the price stored in the database (the one defined in the product form) gets updated. However, this price does not reflect the modifications made within the quotation template itself. That said, Odoo allows you to bring the exchange rate into the quotation template by following these steps:

1. First, we need to have the basic configurations set up for the currencies we will use in our database: [link]:
   
   
2. 
   
   
3. Prepare the price lists to enable currency conversion in our quotation: [link]:
   
   
4. 
   
5. When the settings are done, we need to open the quotation template and use the next formula in the Odoo sheets file:
   
   
6. 
   
7. 
8. 
   
9. 
   
10. This is the formula we will use:     
11. 
    
12. The formula is written in the cell below the exchange rate, and the currencies are expressed using the currency ID according to the currency model. The date can be adjusted as needed.
13. 
    
14. 
    Now, if we use conditional Excel formulas, we can conditionally apply currency conversion when necessary.
15. 
    
16. 
    Con esto podemos usar la calculadora de cotización de una forma mas practica; hasta tener el siguiente resultado:

17. 
    

    
    

    💡

    REMEMBER TO SYNCHRONIZE THE "CURRENCY PRICE" FIELD WITH THE "UNIT PRICE" FIELD SO THAT THE INFORMATION IS UPDATED WHEN SAVING THE QUOTATION.

    
    

    

    
    

     

18. 
    
19. Quote on MXN currency:
20. 
    
    
    
    
    
21. 
    
22. 
    USD Calculation:
23. 
    
24. 
25. 
    
26. 
27. 
    
28.