c2c-oerpscenario team mailing list archive

["Kyle Waid - http://www.midwestsupplies.com" <707287@xxxxxxxxxxxxxxxxxx>]

Hi, This problem is with the current trunk. I can explain in more
detail. Say I have a few products. Natively, the UOM is PCE. So say I
add 500 quantity for each of these products. But later I change the UOM
to FT. When I try to do a manufacturing order later it cant because
there is a past stock move for the product in PCE even though the
current value of the product is in FT. I believe what happens is before
the scheduler creates the manufacturing order it scans the stock_move
table and if it finds non-matching entries it will return the error. The
program should read only the current unit of measure not what is in past
stock moves as it is not possible to change or remove a stock move.

I noticed that the error is triggered especially when using the magento
connector.

There is also another piece to this. Say again I have a few products
that are all in FT. I can create a BOM for each component in PCE. I can
successfully produce a manufacturing order this way even though the
components are not configured correctly. I believe all of these things
combined adds corruption to the database.

So in the future even if the product is configured correctly, with the
correct uom, it cant create a manufacturing order because there is a
past stock move with an incompatible UOM. It took me many hours to
diagnose the problem, and if you can reproduce it, I would say it is a
critical bug because its like a plague,

you cant process the schuduler it will stop and not bypass it, halting
the entire procurement and manufacturing process. The only solution is
to put the product as consumable which is no solution at all.

-- 
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):
  Incomplete

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.