openerp-expert-production team mailing list archive

[Numérigraphe <588154@xxxxxxxxxxxxxxxxxx>]

Two solutions can be implemented for this problem :
1/ we can refuse to change the state to "done" for all the stock moves dated before an inventory of the same product and location.
2/ we can make the function field "qty_available" (and others) use the latest inventory as a starting point to compute the current quantity, and only add the stock moves dated after the inventory.

Solution 2/ might be a performance booster, but it's pretty subtle because a product can be in many inventories at many dates in many locations.
So we're currently implementing solution 1/ and we hope to push a branch tomorrow.
Lionel Sausin

-- 
You received this bug notification because you are a member of OpenERP
Manufacturing Experts, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/588154

Title:
  Inventory: movement input with date prior to physical inventory are
  reflected in stocks

Status in OpenERP Community Backports (Addons):
  New
Status in OpenERP Addons (modules):
  In Progress
Status in OpenERP Addons 5.0 series:
  Confirmed
Status in OpenERP Addons trunk series:
  Won't Fix

Bug description:
  I setup a physical inventory with date 2010/05/19. Stock is 5 for product x
  When I have an internal move  for 1 piece of product x with date 2010/05/01, the current calculated stock at 2010/06/01 is 4 which seems to me incorrect as the current stock should reflect the physical inventory on 2010/05/19 and be 5.

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