Hello guys, the good news is I HAVE A PATCH FOR THIS!
So: that bug occurs when you enter bad data in OpenERP: when the default purchase UOM, at the bottom of the product form doesn't belongs to a different UOM category than the procurement UOM (probably because you sold in a bad unit). You can detect all the procurements that have such an issue with the following SQL query: select procurement_order.id, procurement_order.state, product_uom, product_uom.category_id as product_uom_categ_id, product_template.uom_po_id, t.category_id as proc_uom_categ_id from procurement_order join product_template on product_id=product_template.id join product_uom on product_template.uom_po_id=product_uom.id join product_uom as t on procurement_order.product_uom=t.id where t.category_id != product_uom.category_id; That might help you to spot the problem and fix your data. Now, I think OpenERP should apply my attached patch: it will test the UOM category right at the before trying to run the procurement and if there is some UOM miss match, then it will let the procurement in an "exception" state with a specific message: "Procurement UOM and product purchase UOM categories mismatch!" so you can find those errors and fix them. It's exactly the same error management as when the product has no supplier for instance so I believe this is correct. We have been working for Kyle (bug reporter) lately and I can assure this patch fixes the bug at their installation. ** Patch added: "procurement_uom.patch" https://bugs.launchpad.net/openobject-addons/+bug/707287/+attachment/2149511/+files/procurement_uom.patch ** Changed in: openobject-addons Status: Triaged => Confirmed -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/707287 Title: Manufacturing orders broken UOM Status in OpenERP Modules (addons): Confirmed Bug description: We have around 5,000 products. We have custom UOM like ft, OZ and Pound. On certain products we cannot make manufacturing orders with this error Conversion from Product UoM m to Default UoM PCE is not possible as they both belong to different Category!. It is extremely frustrating because it doesnt make sense. We do not have a single product with UoM 'm'. The error only happens with certain products, not in any specific instance except that mabe the category UoM but not every item in that category. If we created new products then we dont have the issue. I discovered many of the products were having problems base on an inventory we did with the stock_move table. Deleting entries fixed many of the issues but we still have this problem and it makes no sense to us. _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
