Skip to Content
Menu
This question has been flagged

Hi,

I'm looking for more information on how to set up my company's routes, whilst covering all bases. Our goal is to have minimal stock at all times, ordering as and when we receive requirements from our customers.


I need the following situations to always occur, depending on the variable criteria:

All Components are configured with the below settings:

Can be Purchased

Can be Sold

Replenish on Order

No Tracking

Min/Max quantity (0) - this will be changed at a later date


When demand is created from Sales Orders, or Manufacturing Order transfers Odoo is ordering the total requirements (if higher than available stock) I want this to order the balance between the two 

Example of preferred behaviour: 85 in stock, sales order added for 300. We need the system to order the balance of 215, currently it's ordering 300. 


When Scrap orders are created, the scrapped components are added to an RFQ, regardless of current stock levels. I want this to pick from available stock first, then place any additional quantities on an RFQ for our purchasing team. This is also not creating a transfer for Pick Components straight away, then when they are created, there are no source documents against the record. 

Example of preferred behaviour: MO requiring 100 of a component is confirmed, transfer is complete for all 100, adding 100 to the Pre-Production location. 20 break during production, 20 are scrapped (replenish quantities is ticked), one of the following occurs - 

  • 20 are available from stock, Pick Components operation is created, with the MO and Scrap Order as the source document
  • None are available from stock, added to RFQ from preferred vendor 
  • 10 are available from stock, 10 need to be ordered, follow both steps above for the required quantities

We have two warehouses, I would like to set one warehouse to 'request stock' from our head quarters, if there is no stock available in their locations. If possible, I would like this to show as a separate operation, to separate the 'local' and 'transfer required' stock.

Example of preferred behaviour: MO requiring 2 components is confirmed, one is stored in 'Warehouse 1', the other in 'Warehouse 2'. Create standard Pick Components operation for Warehouse 2 item. Create 'Warehouse Transfer' operation for item that needs to move between warehouses. I would also like this to follow the other points above, where stock is taken into account before RFQs are raised.


Hope this all makes sense, apologies for the wall of text.

Thanks in advance.

Avatar
Discard
Best Answer

I would answer you first part regarding reordering rules:

Remove : 'Replenish on Order' route from the products.  I don't directly recognize it, but the name indicate that it is MTO route (Make to Order). If i am right, the RFQ will always be the same as the requirement.

Reorder rules:  Be aware of the field QTY multiple.  Should be = 1 in your flow.  This should create RFQ as you require. 

Also decide Auto or manual.  It can be best to start with Manual, to see result of the reordering rules.  With Manual as trigger you find the requiremen in Inventory->Operation-> Replenishment form whre you can create RFQ. With Auto the dayli (by default) scheduling job will automatic create new RFQ.

Picking qty is not created according to what you have in stock.  It is created from what qty is in the requirement.  If you have a sales order for 100, and only have 85 in stock, the picking is still created for 100. The picking (or to be more specific - the transfer) is the requirement.  In this case (with the reodering rule set as describe) an RFQ for 15 will be created.

I have run the opreation like this for several years. It works.

Picking from second warehouse: In the routes you define Rules. There is a sequence for the rules: If stock is not avail according to the first rule, Odoo check the second rule.  (I am a little uncertain here, so please test and double check).



Avatar
Discard
Related Posts Replies Views Activity
2
Nov 22
2356
2
Jan 25
486
1
May 23
2599
1
Jun 21
3675
1
Apr 25
371