Hi, Is there any module / configuration which give the possibility to check the stock when the procurement method is "make to order"?
Details: REAL Current process of my customer working with make to order (what they do in real life): 1) Record customer order. 2) Check the stock in case there is some stock. 3) Make a purchase order with the required quantity (sales order quantity - available stock quantity).
"Make to order" means that only sales order will launch purchase order. However, customer can have some stock due to different reasons (MOQ. return products, canceled customer order). For all these reasons, the purchasers need to double check the stock before issuing the purchase order.
OPENERP Process: Make to order: do not check the stock at all. Make to stock: some configuration could be done with stock orderpoint = 0... However, it's not make to order and so you loose the important info related to the sales order (source document). Moreover, it's not intuitive for customer because they are working on make to order.
Another process should be a 3rd solution: make to order with stock checking. 1) Record a sales order. 2) Check the stock for related product. 3) Make a draft purchase order with the quantity = sales order quantity - stock available quantity. 4) Get a message on the purchase order that one part of the order come from the stock (customized view with order level).
Is anyone who worked / developed module / configuration for such a process?
We have this function developed for openerp7 (ecommerce operation) by Trobz. We did not control the source code so you should contact http://trobz.com/ for the code. Basically we alter the mrp_scheduler to check for existing stock before rasing purchase order of Make to order product type.
I believe I have figured out how the workflow is set up to solve this issue without having to make a customization. When you have a product that you stock, but you dropship it when your stock levels run out, do the following.
Product Set Up: Stockable product Make to stock Supply method: buy
- Enter and confirm the sales order.
- Click Check Availability on the delivery order.
- Run the scheduler At this point if it was a MtO product a PO quote would be created. Since this is a MtS product, there will be a procurement exception created indicating: "Not enough stock and no minimum orderpoint rule defined"
- Within the procurement exception, click the retry button.
- Click edit, and change the procurement method to Make to Order.
- Save the procurement exception and click Run Procurement again
At this point the OpenERP workflow processes this backorder as a MtO product and a purchase order quote will automatically be generated and tied to this sales order.
I do believe that another product type such as "Make to Stock First, Make to Order Second" would be better and I hope that OpenERP adds this functionality so that this is done automatically. But in the meantime, this is how it can be done without making major changes to your installation.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/2/13, 6:48 PM|
|Seen: 11270 times|
|Last updated: 5/9/16, 6:56 AM|