← Back to team overview

openerp-india team mailing list archive

[Bug 804353] Re: Changing UOM can corrupt database

 

I close this bug as we put the constraints on the UoM changes.

** Changed in: openobject-addons
       Status: Triaged => Fix Released

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/804353

Title:
  Changing UOM can corrupt database

Status in OpenERP Addons (modules):
  Fix Released

Bug description:
  I have a product. Its uom by default is PCE. I sell this product but
  didnt know about UOM. Later I configure them correctly as a Ft, or
  length measurement. I also create a BOM for the product. OpenERP
  cannot compute properly the value of the stock, nor compute a
  manufacturing order because in the history of the stock_move table
  there is entries of uncompatible conversion factors. This is due to
  the field of stock value being a function field. It calculates the
  value of stock based on all past purchases and sales, but it cant
  because there exists entries that are not compatible.

  OpenERP freely allows anyone to change the UoM in the program with
  ease, with no warning of any kind that doing so could potentially
  corrupt the database, break the scheduler entirely, and prevent that
  product from ever being able to use a BOM. This bug references the
  problem in detail.

  https://bugs.launchpad.net/openobject-addons/+bug/707287

  Propose,
  You should if a person changes the UoM from a compatible to incompatible factor alter all of the previous records UoM in the database to match so the conversion is compatible,

  rewrite the function field and manufacturing methods,

  not allow the person to change the measure due to integrity violations

  or place a warning when the attempt to change it telling them they
  could corrupt their database.

  This is a serious problem and should not be ignored

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/804353/+subscriptions