major flaw in manufacturing procurement

[Kyle Waid]

Manufacturing orders generated do not take into account managed stock in locations.

Create 2 stockable products. A and B
Create 1 make to order / produce product C
Create a BOM for C using 1 of A and one of B

Create 2 locations LOC1, LOC2
Assign quantities of product A to lOC1
Assign quantities of product B to LOC2

Create a sale order for C, confirm order.
Manufacturing order is generated for C

Location is Stock......
Products are procured from stock. I have no quantity there. Stock is just a general stock it should not even allow product to come or go from this location it should be a view only. Almost any company manages stock in many locations, not a generic location called stock. It doesn't try to procure a product from individual locations, you cant configure it to do this, it just chooses stock.

Terrible design. I don't see how it is possible to manage stock effectively with such a setup.

[Steffi Frank (Bremskerl, DE) (steffi-frank)]

+1

agree, source location should be set A) in head of BoM or B) in component (BoM)

[Amit Parik (amit-parik)]

Hello Kyle,

I have completely traced your issue. Yes you are right, Currently it takes the stock as a source location which is the "location stock" of your warehouse also it didn't check the other location where product is already available.

I agreed with Steffi 's suggestion that we have to take the source location from the BoM, either on main BoM or on the component.
For that we need to put a location field on "Bill Of material".

But it's requires lot's of changes.
Currently Manufacturing order taken source location from the procurement order's location ( location_id field). Our procurement created for the Sale Order, So for procurement 's location are taken from the Shop see the sale.py' s line#716. procurement order's location's comes from the Shop->Warehouse->Location Stock. Here we can not takes the location from the "BoM" because sale doesn't depend on mrp.

So this suggestion needs a lots of improvement. As per my "opinion" this changes will be correctly do on sale_mrp module(which will the good option).

Currently as per the good suggestion I am considering this as a "Wishlist".

@Community: I request to you please share your views on this, which solution will be better for this.

Thank you!

[Marco Dieckhoff (dieck)]

Hi!
As of now, we helped ourselfes with a little module that contains my comment "# one of the dirtiest workarounds I ever made" :)

http://apps.openerp.com/?text_search=mrp_raw_material_location

It adds a field to the BoM to set the location, hijacks action_ship_create(), changes the lot_stock_id on the warehouse, processes the original action_ship_create() and resets the lot_stock_id...

I'd really appreciate a better solution within the OpenERP original code.

[Sid (siddiqmomin)]

Hello,

I agree to what Steffi has suggested and it should work in that manner.

But better way of doing it is..

It should check the Product Stock availability at each PHYSICAL Internal location and assign it to RM location which we can specify on MO.

@AmitParik :- We have to make this change or else Manufacturing will have big flaw which can not be worked in real time situation.
If a procurement can run for different physical locations then why can't MRP checks the stock availability at individual locations instead of STOCK location which is VIEW location in real time for all the companies.

Thanks,

Siddique