Community mailing list archives
Re: SUM: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)by
Hello Ray, and thank you for our contribution.
I would love to test out your module for v8, can you supply a link?
On Wed, Mar 4, 2015 at 5:07 PM, Ray Carnes <firstname.lastname@example.org> wrote:
Thanks to everyone.I ended up writing a module and porting a module (for v8).
ursa_stock_sellable_qty - essentially what stock_available_immediately does (before I knew about this module).bom_stock - a port of the OCA/C2C module from v5PR done.
Subject: Re: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)
Date: Tue, 3 Mar 2015 07:57:48 +0000
To: email@example.comJoëlIt works in produciton since version 5.0 ! It probably needs some perf improvements if huge BoM are used. Our customer us it on a 30'000 product DB without trouble, but have only simple one level BoM.Hi there,We already have such a module here (still v7.0):
https://github.com/OCA/product-kitting/tree/8.0/__unported__In version 8.0, we can improve this perf a lot by using the quants in the computation.My2Cents,Regards,On Tue, Mar 3, 2015 at 7:47 AM, Nhomar Hernández <firstname.lastname@example.org> wrote:2015-03-02 22:37 GMT-04:30 Graeme Gellatly <email@example.com>:Sure the more complex bom's and kits the longer it takes. Simple cases are pretty much no time at all, not more than a few percent of total time. It is basically identical in performance to calculating the BoM requirements (in fact the OCA version only goes 1 level deep so even less) plus some basic arithmetic operations to determine the maximum qty. I've always found it fast enough to be used in real time even on a full list of products.It should be cool an analysis of the algorithm.We have a customer which this feature should help, but with 10000 SKU's with BoM of 2/3 levels, it should be a pain.May be with some triggers whcih record in the product itself such qantities it can be afford correctly.But good and useful feature!Thanks for share.
Ursa Information Systems, Ray Carnes