← Back to team overview

openerp-community-reviewer team mailing list archive

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

 

This behaviour is contrary to GAAP and should be fixed sooner rather
than later.

A simple example of stock being counted on the last day of the financial
year, but entered the next day, leads to the stock adjustments and
associated journals being posted in the wrong year, which would need an
extra reversing journal to be calculated and entered to make the stock
value correct in that period.

Other examples where there are stock movements between stock count and
stock entry (some as outlined above), all suffer the worse problem of
introducing stock quantity errors.  This therefore limits the use to
preventing an entries between stock take and data entry, which in many
businesses is not possible.  This one feature would prevent this
software being considered by most companies.

Correct treatment would be to calculate the OpenERP stock quantity at
the "Creation Date" of the Physical Inventory, and make any adjustment
stock movements the difference between the actual count and the
calculated quantities, also with the date of the "Creation Date".  This
will enter the correct stock values in the correct dates and periods.

-- 
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 New OpenERP WMS:
  Won't Fix
Status in OpenERP Addons (modules):
  Fix Committed

Bug description:
  Hello.

  When we confirm a stock. inventory.

  action_confirm method is not taking in account "date" from
  sotck.inventory object, and update qtys in the moment of confirmation.

  IMHO this is wrong, i expect that date say _when_ the inventory was
  taken in this way amount to correct shuld be in this before this date.

  Regards:

  PS: attach videos with better explanation, and document with kardex
  expected.

  The problem is twofold:
  - the inventory date is not taken into account when querying the stock to compute the inventory difference
  - the stock moves are created at the wrong date, making the stock and virtual stock wrong at the date of the inventory

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-trunk-wms/+bug/915568/+subscriptions