openerp-community-reviewer team mailing list archive

[Lionel Sausin - Numérigraphe <915568@xxxxxxxxxxxxxxxxxx>]

Thanks Quentin for this honest explanation.
We should not introduce features in v7 that we won't be able to port to v8 so we'll have to live with it for now.

So here's what I propose for the core v8:
- if there are conflicting stock moves (ie. move.date > inventory.date), refuse to confirm the inventory.
- if there are no conflicting moves, compute the stock difference at inventory.date and insert the stock moves at the same date.
The error message MUST give users the list of locations/products/lots with conflicts. Then they can re-count the goods, change the date of the inventory and confirm.
This is probably acceptable by most SME with no-too-complex warehouse structures.

Now, for those with more complex warehouses like ourselves, we have developed additional features to secure the inventory :
- indicate the impacted locations BEFORE we open the inventory
- forbid all stock moves on the impacted locations during an inventory
Our has been in production on v6 for ~1 year and we've just finished porting it to v7: Loïc will be making a merge proposal to OCA's WMS project soon, possibly this afternoon.

So in the end, users get the choice to either allow moves during
inventory and let the manager clean up the mess, or enforce data
integrity from the get go.

Either way, we have to accept that all stock moves must be entered in
the correct sequence, and as close to real-time as possible.

-- 
You received this bug notification because you are a member of Stock and
Logistic Core Editors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/915568

Title:
  Wrong dates used when confirming stock inventory

Status in OpenERP Community Backports (Addons):
  Confirmed
Status in New OpenERP WMS:
  Won't Fix
Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  [ Problem ]
  action_confirm method is not taking in account "date" from stock.inventory object, and update qtys in the moment of confirmation.
  The inventory date is taken into account when querying the stock to compute the inventory difference but the stock moves are created at the wrong date, making the stock and virtual stock wrong at the date of the inventory.

  Users expect that the inventory date should say _when_ the inventory
  was taken - in this way the amount to correct should effective before
  this date.

  Attached videos gives better explanation, and document with kardex
  expected.

  [ Impact ] the available quantity and virtual stock are wrong near the
  date of the inventory.

  [ Possible fixes ]
  - The preferred fix would be to write the stock moves at the date of the inventory.
  - A less-than-ideal fix would be to not take the inventory date is taken into account when querying the stock to compute the inventory difference. For the moment is the way v8 is being developed.

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