Inventory Valuation at a Specific Location

account inventory odoo18 Valuation

2 回复

1171 查看

RGonzalez

Hello everyone, I hope you are well.

I would like to ask a question about how to configure inventory routes so that it only generates an inventory valuation when arriving at a specific location.

We currently have 2 warehouses, the company's one and another in the USA, but because this country has hyperinflation, the valuation of a product on date A in the USA is not the same on date X that it arrives at the company's warehouse due to the exchange rate. This generates differences in accounting that must be declared by law, but differences in our currency, because at the $ level the product continues to be worth the same.

I had read that if I configure a transit location, I could send the products to this location and not generate a valuation, but despite configuring any type of location, excluding the view type, it generates a valuation entry.

If anyone recommends a method to manage this feedback correctly in a specific location, using automated feedback, I would appreciate it.

Zehntech Technologies Inc.

Hello,

In standard Odoo behavior, when using automated inventory valuation, every stock move between internal locations generates a valuation entry, regardless of whether it's a transit location or not.

So, configuring a transit location alone will not prevent valuation postings if both source and destination locations are of type internal.

To achieve your requirement (valuation only at a specific location), you can consider these approaches:

Use a transit location with different valuation behavior (e.g., treating it as a non-valuated step via route design), but this has limitations in standard Odoo
Leverage inter-warehouse transfers with careful route configuration, possibly involving virtual/vendor-type locations to delay valuation
For full control, a small customization is typically required to restrict valuation entries only when products reach the final warehouse

This is a common scenario in multi-country flows with currency fluctuations, and often requires aligning stock and accounting logic together.

Hope this works for you! Feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

Cybrosys Techno Solutions Pvt.Ltd

Hi,

As long as BOTH warehouses are internal locations of the same company, every move between them generates TWO valuation entries — one outgoing from the USA warehouse and one incoming to the company warehouse — regardless of any transit location in between.

Workarounds:

1. Set up the USA warehouse as a separate company in Odoo. Enable inter-company rules between the two. When goods are transferred, Odoo generates a Sale Order in the USA company and a Purchase Order in the main company. The main company only creates its inventory valuation entry when it RECEIVES the goods — valued at the exchange rate of that receipt date. The USA company handles its own valuation independently.

2. If setting up a second company is too complex for your current setup, a pragmatic workaround is to change the USA warehouse's location type from Internal to Supplier (vendor location). This makes Odoo treat all incoming transfers from the USA warehouse exactly like receipts from a vendor — generating only ONE valuation entry, at the moment of arrival at your main warehouse, using the current exchange rate.

The downside is that the USA warehouse inventory is no longer tracked in your accounting books — it is treated as a supplier's stock, not your own. This is acceptable if the USA warehouse is not part of your legal entity's balance sheet.

3. If you must keep both warehouses as internal locations of the same company, accept that two SVL entries will always be created. Then use Landed Costs (Inventory → Operations → Landed Costs) to record the exchange rate difference as an additional cost applied to the incoming shipment at arrival. This adjusts the inventory valuation at the destination to the correct local-currency value and creates a proper accounting entry for the difference — which you are legally required to declare.

Set landed cost as: (arrival exchange rate − shipment exchange rate) × quantity × USD unit cost.

This is more manual but keeps your full inventory accounting intact in a single-company setup.

Hope it helps

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
How can i setup the inventory module inventory odoo18	2 1月 25	2476
Customizing the Balance Sheet accounting report account odoo18 balancesheet	2 6月 26	227
Odoo 18 Multi Level Package Usecase inventory package odoo18	0 12月 25	1060
physical inventory update & accounting issue stock account inventory	0 3月 15	6246
Inconsistent Display of Renamed Accounts in Chart of Accounts accounting account chartofaccounts odoo18	1 6月 25	2258

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！