← Back to team overview

openerp-community-reviewer team mailing list archive

[Bug 915568] Re: Wrong dates used when confirming stock inventory

 

Here are bits of documentation that I humbly propose for v8 when this
lands into trunk, based upon this discussion.

"""
Near-real-time requirements
OpenERP expects you to manage your inventory in near-real-time.
For this reason, it will not let you enter stock moves and indicate a date in the past, because it would for example introduce errors in the price averages, and make inventory adjustments wrong.
Of course you do not have to enter stock moves in real-time - this typically require sophisticated inventory support hardware like RFID tags.
You must however enter every stock move in the same order as they really happened.
"""

"""
Inventory adjustments
Good practices and accounting rules dictate frequent inventories of important goods, and at least one global inventory control per fiscal year.
It is obvious that in the real world, not a single stock move should be made while the goods are being counted in the warehouse.
To help you with this, OpenERP will let you indicate which location is being controlled, and will forbid all stock move entry while the inventory is marked "in progress" in OpenERP.
When the inventory is done, OpenERP will adjust the stock levels at the date when the inventory was started.
This way, you can easily have a consistent inventory at a predictable date, which is crucial for end-of-year accounting operations.
Even though it may introduce stock moves in the past, this is consistent with the near-real-time requirement stated above.
"""

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