Skip to Content
Menu
This question has been flagged

If we transfer goods from 1 Warehouse to another Warehouse ,Is there any any way odoo can report the value of those goods transferred.Basically we want to see the value per internal trasnfer of inventory.

Avatar
Discard

I have same inquiry we need to know the value of internal transfer

Best Answer

Yes, Odoo can report the value of goods transferred between warehouses. This can be done through the use of the Inventory Valuation Report, which is available in the Odoo Inventory Management module. This report provides an overview of the value of the inventory for each warehouse, including information about the cost of goods sold, the value of goods on hand, and the value of goods in transit between warehouses.

When transferring goods from one warehouse to another, Odoo automatically updates the inventory levels and values for both warehouses, taking into account the cost price of the transferred goods. The Inventory Valuation Report can then be used to view the impact of the transfer on the overall value of the inventory. This helps to provide visibility into the financial impact of internal transfer operations and to track the value of goods in transit between warehouses.

If you need custom module to manage this or any changes you can have free consultation with https://silentinfotech.com/

Avatar
Discard

Hi!
What you describie is very much what I would like to achieve with the inventory valuation report, but as far as I can tell,it is not an option in standard (Odoo v17).
Is this a feature that has been removed as far as you know?

The problems I want to solve
1. I want to be able to se the valuation of each warehouse separately (By grouping and/or filtering)
2. When an Internal transfer is created, I want to be able to se this updated in the inventory valuation report

Solutions
1. Group by warehouse
I think that i ave a workaround for the first problem.
There is a field "warehouse_id" in the sock.valuaton.layer, but it cannot be grouped by since it is not stored.
By adding a related field to the "warehouse_id" and making that stored, I can then add it as a field to be grouped by. This is however not enough without a solution to problem 2

2. Internal transfers
For some reason, internal transfers does not show up on the stock valuation report.
Example:
I receive 1000 units to one warehouse, and the transfer 600 units to another warehouse.
I can then see in the stock and location reports that the units have been moved.
In the stock valuation report, all 1000 units are still in the first warehouse, ignoring my internal move.
Is there a workaround for this second problem, or am I missing something obvious?

I also created a new post for visibility:
https://www.odoo.com/forum/help-1/multi-warehouse-stock-valuation-with-internal-transfers-odoo17-253557

Best Answer

the easiest way is to use the valuation button, this will be visible when validating the transfer and in developer mode you can also see the button, if you add to the model "stock.valuation.layer" the group and/or the user that should check

I hope it helps you 

Avatar
Discard
Related Posts Replies Views Activity
1
Jul 19
8940
0
Dec 24
1233
2
Jul 24
1848
1
Aug 23
2212
1
Jul 23
2469