Skip to Content
This question has been flagged
inventorysales.ordervaluationpurchase.order
1 Reply
1811 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
Inventory Valuation in Inventory in Odoo v12
inventory valuation
Avatar
Avatar
Avatar
2
Jun 24
3022
Error when doing Manual Value Revaluation
inventory valuation
Avatar
0
May 23
1042
Historical Inventory Valuation by Location
inventory valuation
Avatar
Avatar
Avatar
2
Apr 23
2451
Odoo 13EE - Negative Numbers on Inventory Valuation Solved
inventory valuation
Avatar
Avatar
2
Jan 21
3171
Inventory Valuation for delivering products in odoo 9?
inventory valuation
Avatar
0
May 16
2289