Community mailing list archives

community@mail.odoo.com

SUM: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)

by
Ursa Information Systems, Ray Carnes
- 03/04/2015 17:05:04
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

PR done.

Ray.


Subject: Re: Calculating "QTY available to MAKE" - Products with a BoM ?? (v7 or 8)
From: joel.grandguillaume@camptocamp.com
Date: Tue, 3 Mar 2015 07:57:48 +0000
To: community@mail.odoo.com

Hi there,


We already have such a module here (still v7.0):

https://github.com/OCA/product-kitting/tree/8.0/__unported__

It 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.

In version 8.0, we can improve this perf a lot by using the quants in the computation.

My2Cents,


Regards,

Joël



On Tue, Mar 3, 2015 at 7:47 AM, Nhomar Hernández <nhomar@gmail.com> wrote:

2015-03-02 22:37 GMT-04:30 Graeme Gellatly <gdgellatly@gmail.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.


--
--------------------
Saludos Cordiales
 
--
Nhomar Hernandez
 
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS

Joël Grand-Guillaume
Division Manager
Business Solutions

+41 21 619 10 28


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe