Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
124 Vistas

Good evening,

While testing multi-currency transactions, I discovered what appears to be a significant valuation issue. I found that when vendor bills are posted in a foreign currency, Odoo 19 is miscalculating the conversion rate. This leads to inflated stock valuations and inaccurate entries in the variation account, which has a direct and serious impact on Cost of Goods Sold, profit margins, and the overall accuracy of the balance sheet.

For example:

Consider a company with a base currency of USD. The exchange rate is set at 1 USD = 1500 IQD. A product, let's say "Product 1001," is purchased for 1500 IQD.

*The expected behavior is that Odoo should value the product at its equivalent cost in the base currency, which is $1 (1500 IQD / 1500).

*However, after the vendor bill is validated, the system incorrectly records the cost of "Product 1001" as $1500 USD instead of the correct $1.

This bug compromises the accuracy of your financial statements, as the inflated stock valuation directly affects the Cost of Goods Sold (COGS) and subsequently, your profit margins. This demonstrates a serious flaw in the integrity of Odoo's real-time costing method and has significant implications for businesses operating with foreign currencies.

Avatar
Descartar

Please report feedback via odoo.com/help so our Support Team can verify and work with our Developers to resolve any incorrect postings.

Mejor respuesta

Hello Abdullah,



  It sounds like you've encountered a serious issue with multi-currency valuation in Odoo 19. Let's troubleshoot this systematically. Here’s a breakdown of potential causes and solutions:

  Currency Rate Configuration: Double-check that your currency rates are correctly set up and automatically updating in Odoo. Go to Accounting > Configuration > Currencies, and ensure that the IQD to USD rate is indeed 1500. Also, verify the 'Automatic Currency Exchange Rate' configuration.

  Journal Configuration: Verify that the journal used for the vendor bill has the correct currency set. If the journal is set to USD instead of allowing multi-currency, it could be forcing the base currency.

  Product Category Configuration: Examine the costing method and valuation settings in the product category of "Product 1001". Ensure that the costing method is appropriate (e.g., FIFO, Average Cost) and that the valuation is set to 'Real Time (Automated)'.

  Reconciliation: Validate that the exchange rate differences are being correctly handled during the reconciliation process. Odoo should automatically create journal entries to account for any discrepancies.

  Odoo Version and Modules: Confirm you are on the latest version of Odoo 19 and that all accounting and inventory modules are up to date. Sometimes, bugs are fixed in newer releases.

  Debugging: If the issue persists, enable debug mode and review the journal entries created during the vendor bill validation. This will help identify where the incorrect valuation is originating.


For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html

Avatar
Descartar
Mejor respuesta

Hello Abdullah, I understand you're encountering currency conversion issues in Odoo 19 when posting vendor bills in foreign currencies.



  First, double-check your currency settings in Odoo. Navigate to Accounting > Configuration > Currencies and ensure that the exchange rate between USD and IQD is correctly set to 1 USD = 1500 IQD.

  Next, verify the journal configuration used for the vendor bill. Go to Accounting > Configuration > Journals, select the relevant journal, and confirm that the currency is correctly set and that there are no settings overriding the default currency conversion behavior.

  Check the product configuration. Ensure that the product "Product 1001" doesn't have a fixed cost defined in USD that might be overriding the converted cost from IQD.

  If the issue persists, manually reconcile the invoice and payment, ensuring the correct exchange rate is applied during reconciliation.

  If none of the above steps resolve the issue, it may be necessary to review Odoo's automated currency gain/loss handling to ensure it is configured correctly to avoid unintended valuation adjustments.


For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
feb 23
5512
1
ago 25
2941
1
oct 24
2367
0
abr 24
1418
2
dic 24
40046