Procurement orders blocked for Phantom BOMs sales

Drizzit · **Posted:** Thu Sep 15, 2011 4:50 pm

Hi,

I'm using the version 6.0.3 of OpenERP.

When I'm confirming a sale order for a product that is top-level Phantom BOM, a delivery order is generated with the detailed BOM components but also a procurement order for the Phantom BOM.

The problem is, even when I confirmed the delivery order and entered the generated invoice paiement, the sale order is never marked as Terminated, because there is the procurement order for the Phantom BOM that is blocked in Confirmed state.

I tried to manually run the Procurement planners but it didn't generate any production order.
The procurement order also blocks the planner for the minimum stock rules, as it doesn't generate purchase order anymore to fill the stock...

Here is my BOM configuration:
- Product1 - BOM Type : Sets/Phantom
- Product2 - BOM Type : Normal - Quantity : 1
- Product3 - BOM Type : Normal - Quantity : 2

As I've set the top-level BOM with type Sets/Phantom, I thought the sale order will only generate a delivery order and invoice, without procurement order or production order.
This is how I need OpenERP to work, if possible.

Kevin McMenamin · **Posted:** Thu Sep 15, 2011 10:41 pm

What are the attributes on your product/sales order - look at product type/procurement method/supply method.

Drizzit · **Posted:** Fri Sep 16, 2011 10:18 am

Hi, and thanks for your reply,

Product type : Stockable Product
Procurement method : Make to order
Supply method : Produce

I've set "Make to order" and "Produce" for the product because the product is never in stock. It is produced with the required components for each command.

I also tried to set Procurement method to Make to Stock and/or Supply Method to Produce but then the product BOM is not detailed in delivery orders.

Kevin McMenamin · **Posted:** Sun Sep 18, 2011 10:54 pm

with that set up you should get a manufacturing order created not a purchase quote. I am using 6.0.2 and the MO creation works fine (I have mrp_jit installed as well).

I did find some issues with multi-layer BOMS and explosion - have a look at bug 850357 - results depend on how you set up the BOM.

Drizzit · **Posted:** Tue Sep 20, 2011 2:33 pm

I've looked at this bug, but this is not quite the same issue I face.
The BOM is correctly exploded in delivery orders but not in sales orders, but I don't really want it to be.

Maybe I didn't use OpenERP properly and my BOM settings are not correct.
What I would like is to have a product that is a set (never stored or produced) composed of other products that I buy and which are stored in stock.

In fact, I never want to deliver to the client the BOM himself, which doesn't really exist, but only its separate components. So I don't want any procurement or manufacturing orders for the Set.

What would be the correct configuration to do it ?

Thanks for your help !

Kevin McMenamin · **Posted:** Tue Sep 20, 2011 10:41 pm

If you want to have the BOM exploded in sales, have a look at nan_product_pack

Drizzit · **Posted:** Wed Sep 21, 2011 6:26 pm

Thanks for the solution, I tried it and it seems to be working well, just what I needed !

I've just a little problem, but that is not really blocking for the orders : when I confirm an sales order with a product that is a Pack (Consumable, Make to Stock, Produce), I always get a warning message "Procurement 'ProductPack' is in exception: No minimum orderpoint rule defined.".

This message is not correct because the stock of the ProductPack is calculated with the stock of the components. The ProductPack is never in stock so there is no need for a minimum stock rule, it will never be bought or manufactured.

Is there a way to make this message disappear ?

Kevin McMenamin · **Posted:** Wed Sep 21, 2011 10:48 pm

You could try adding a re-order point rule and see if that works.

Drizzit · **Posted:** Thu Sep 22, 2011 10:31 am

It must surely be a bug of OpenERP : I tried to add a minimum stock rule for the ProductPack but it appears to be possible only for Stockable Product.

My ProductPack is a Consumable, so OpenERP should not ask for a stock rule...

Kevin McMenamin · **Posted:** Thu Sep 22, 2011 10:20 pm

sounds like a bug..log it and see what they say

Drizzit · **Posted:** Wed Sep 28, 2011 3:40 pm

In fact, there seems to be no log for this warning, only real errors and crash are actually logged.

But that's not really a problem for me, because it still works correctly after that little bug.

Thanks for all your help !

Drizzit · **Posted:** Thu Sep 29, 2011 11:05 am

Ok, I thought I was done with it, but there is still another really annoying bug with the nan_product_pack:

I checked the option "Pack has fixed price" for the product that is a pack, to make the price of the product the sum of the component's prices. So in the product form, the sale price is 0.

The problem is, when I want to make a sales order with this product, at the time I select the product in Order line creation, I get an error "Float division by zero" and so the form is not completely filled, I have to do it manually.

This comes from my sales pricelist, that applies to all products to calculate discount from the sale price.
So it wants to calculate discount for the Pack product, and that leads to a division by zero !

Is there a way to avoid that ? Or Python module must be manually modified not to take account prices equal to 0 in price lists ?

Here is the error log:

Code:

[2011-09-29 10:50:17,248][testRealDatas] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/product_visible_discount/product_visible_discount.py", line 96, in product_id_change
    discount = (new_list_price - price) / new_list_price * 100
ZeroDivisionError: float division by zero
[2011-09-29 10:50:18,330][testRealDatas] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/openerp-server/addons/product_visible_discount/product_visible_discount.py", line 96, in product_id_change
    discount = (new_list_price - price) / new_list_price * 100
ZeroDivisionError: float division by zero