Contributors mailing list archives

Browse archives


Re: Stock valuation by location drilldown

by "Richard deMeester" <> - 19/05/2021 13:50:45

If your context has a warehouse, or a location_id, then all the figures that are computed on product will be contextually constrained based on that context.  Exactly what compute figures are available on product.product varies from version to version, but the context should already be enough to achieve what you need.

Richard deMeester

Senior Development Analyst

WilldooIT Pty Ltd


M: +61 403 76 76 76

P: +61 3 9135 1900

A: 10/435 Williamstown Road, Port Melbourne, Vic 3207



Making growth through technology easy



DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

From: Radovan Skolnik <>
Sent: Wednesday, 19 May 2021 9:47 PM
To: Contributors <>
Subject: Re: Stock valuation by location drilldown
This idea came to mind (please comment on its viability): in stock_account 
there is computed field value of stock.quant that calculates the value. 
stock.location has quant_ids. So it should be easily possible to create a 
computed field for stock.location that would make sum of its stock.quants as 
well as its child stock.locations. I guess there could be some magic that 
would allow to prevent recursive call to sum of stock.location children. Any 
pointers on how to do that? 

Thank you. Best regards

	Radovan Skolnik

On streda 19. mája 2021 11:51:45 CEST Radovan Skolnik wrote:

> Hello,

> I might be stupid not to see how todo that but let me ask. We have locations

> design in a hierarchical way (as I guess is designed). So for example we

> have Goods / RowNo / ShelfNo hierarchy, similarly Spare Parts / RowNo /

> ShelfNo. Now the stock resides at the leaf nodes in this hierarchy

> (shelfs). Is there a simple way to do stock valuation by some sort of

> drilldown? Or at least to get stock value of top location including all its

> children recursively? The need stems from the requirement to compare this

> calculation to other Inventory software which is to be replaced by Odoo.

> But first we have to be sure the calculations match. Thank you. Best

> regards

> Radovan Skolnik



> _______________________________________________

> Mailing-List: [1]

> Post to:

> Unsubscribe: [2]




> [1]

> [2]

Post to: