Skip to Content
This question has been flagged
inventorysales.ordervaluationpurchase.order
1 Respondre
2867 Vistes
Avatar
David

Hi there.


I need to make a modification, where the Inventory Variation report has additional information in it, for each transaction line:


- The Purchase Order Number, if applicable (related to a stock increase)


- The Sales Order Number, if applicable (related to a stock decrease).


How can I find the related Purchase Order or Sales Order Number, accurately?


Our users aren't able to even do this manually in Odoo - (eg - if yo have two different purchase orders, and two different inventory changes related to those).

And the Odoo source code for Valuation Reports is very complicated, so I'm struggling with this. I can find a lot of document numbers in items of the Valuation Reports (for things like stock movements), but don't know how to get from there to the original Sales Order or Purchase Order numbers.

Avatar
Descartar
Avatar
Kamrul Hasan
Best Answer

Step 1: You can inherit model inventory valuation 'stock.valuation.layer' and add two fields like 'type' and 'reference' 

Step 2: Write function/update those fields in model 'stock.picking' when Sales and purchase.

Step 3:  xpath and added those field using xml in model ''stock.valuation.layer''.



Avatar
Descartar
Related Posts Respostes Vistes Activitat
Inventory Valuation in Inventory in Odoo v12
inventory valuation
Avatar
Avatar
Avatar
2
de juny 24
4945
Error when doing Manual Value Revaluation
inventory valuation
Avatar
0
de maig 23
2934
Historical Inventory Valuation by Location
inventory valuation
Avatar
Avatar
Avatar
2
d’oct. 25
4191
Odoo 13EE - Negative Numbers on Inventory Valuation Solved
inventory valuation
Avatar
Avatar
2
de gen. 21
5269
Inventory Valuation for delivering products in odoo 9?
inventory valuation
Avatar
0
de maig 16
3579