Archives
Contributors
Re: Stock valuation by location drilldown
I guess I understand but: as I described in my initial post I need to be able to make the sum of stock.quant values recursively. Let's say a single location represents a warehouse or store room (first level location), with racks (second level location) and shelfs (third level location). Now I need to be able to see value of that top level location which should incorporate value of all of its children and their children... Hope I am making myself clear. Best regards Radovan On streda 19. mája 2021 13:56:49 CEST Richard deMeester wrote: > 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 ** * > * E: * None [1] richard.demeester@willdooit.com > * 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 <radovan@skolnik.info> > *Sent:* Wednesday, 19 May 2021 9:47 PM > *To:* Contributors <contributors@odoo-community.org> > *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: https://odoo-community.org/groups/contributors-15 [1] > > Post to: mailto:contributors@odoo-community.org > > Unsubscribe: https://odoo-community.org/groups?unsubscribe [2] > > > > > > > > [1] https://odoo-community.org/groups/contributors-15 > > [2] https://odoo-community.org/groups?unsubscribe > > _______________________________________________ > Mailing-List: > https://odoo-community.org/groups/contributors-15 [2] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: > https://odoo-community.org/groups?unsubscribe [3] > > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [4] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [5] > > > > [1] mailto:geoff.szentesi@willdooit.com > [2] https://odoo-community.org/groups/contributors-15 > [3] https://odoo-community.org/groups?unsubscribe > [4] https://odoo-community.org/groups/contributors-15 > [5] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 02:05 - 19 May 2021
Reference
-
Stock valuation by location drilldown
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
by Radovan Skolnik - 11:51 - 19 May 2021