c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Friday 01 April 2011, you wrote:
> Public bug reported:
> When fixing this bug, pay attention to this rule: an inventory should
> NEVER create a stock move for a (Product,Location,ProdLot) that is not
> present in the inventory


This will always remind me of the fire extinguisher I bought for my car. The 
shop used an top-selling commercial ERP (Greek) system. 

They had to charge me for a /polishing kit/, because the fire extinguisher, 
which they sold me, was not properly 'in stock' at their ERP[1]. They could 
only amend that by chosing to move one closely-priced item. #FAIL

Strict rules don't always contribute to database integrity. Sometimes it can 
bring exactly the opposite results.

Said that, I agree that at the end of the day there must be a way to verify 
that all database sums up to reality (a post validation, say).

[1] It may have been that some typo in their invoice prevented them from 
registering the delivery of extinguishers at that day (pending form).

-- 
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/747379

Title:
  [6.0] inventory : wrong stocks moves generated when using production
  lot

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  For each inventory line with a production lot, the generated stock move must be based on the stock level for that (Product,Location,ProdLot) and not (Product,Location)
  For example I create an initial inventory:
  Location, Product, Qty, Lot#
  Stock, FAN, 10, 0000001
  Stock, FAN, 10, 0000002
  Then, 2 stock moves are generated from Inventory Loss to Stock. That's correct.

  I create new inventory:

  Location, Product, Qty, Lot#
  Stock, FAN, 2, 0000003
  Then, 1 stock move is created from Stock to Inventory Loss with qty 13 and Lot# 0000003. This is WRONG.

  When fixing this bug, pay attention to this rule: an inventory should
  NEVER create a stock move for a (Product,Location,ProdLot) that is not
  present in the inventory

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