Community mailing list archives
RE: SUM: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)by
From: Grayson Doherty
Sent: 3/4/2015 6:47 PM
Subject: Re: SUM: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)
130 RioCan Ave #3
K2J 5G4, Canada
Thu to Fri....: 10am to 9pm
Sat...........: 10am to 6pm
Sun...........: 10am to 5pm
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 v5
Subject: Re: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)
Date: Tue, 3 Mar 2015 07:57:48 +0000
Joë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):
In version 8.0, we can improve this perf a lot by using the quants in the computation.
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.
Post to: mailto:firstname.lastname@example.org
initOS GmbH, Torsten Francke