Community mailing list archives

community@mail.odoo.com

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

by
Graeme Gellatly
- 03/02/2015 22:05:21
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.

On Tue, Mar 3, 2015 at 1:42 PM, OpenERP Master <openerpmaster@gmail.com> wrote:
This feature sounds like it would be very expensive from a performance standpoint

On Mon, Mar 2, 2015 at 6:12 PM, Graeme Gellatly <gdgellatly@gmail.com> wrote:
https://github.com/OCA/stock-logistics-warehouse has just merged this for v7 and working on v8.  All the stock_available modules

On Tue, Mar 3, 2015 at 1:03 PM, Caudal Eric <caudaleric@gmail.com> wrote:
We did something similar with product_kitting (display the theoretical stock of the kits based on the quantity on stock of the different parts).
It is probably not clean but it is definitively working.

2015-03-03 7:55 GMT+08:00 Ray Carnes <raycarnes@hotmail.com>:

We have been asked to calculate a new column for manufactured products “QTY available to MAKE”

 

Product

BoM

Chair

4 Legs

1 Seat

1 Back

 

Product

QTY IN STOCK

Chair

5

Legs

40

Back

5

Seats

10

 

User wants to see, in the treeview for the Chair product, a new column “QTY available to MAKE”.

 

In this case it would be 5, because there are only enough chair backs to make 5 chairs, even though there are more than enough legs and seats.

 

PRODUCT

CODE

QTY AVAILABLE

QTY AVAILABLE TO MAKE

CHAIR

CH

5

5

 

Has anyone worked on anything for v8?  (or V7 that could be ported)?

 

Regards,


Ray Carnes.

 

 

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




--
Eric CAUDAL
+86 186 21 36 16 70

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


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


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