c2c-oerpscenario team mailing list archive

["Devishree Brahmbhatt \(OpenERP\)" <741457@xxxxxxxxxxxxxxxxxx>]

Thanks for Reporting...

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 2 (openerp-dev-addons2)

** Summary changed:

- [6.0.1] Multiple UOM not handled by Inventory Analysis
+ Multiple UOM not handled by Inventory Analysis

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

Title:
  Multiple UOM not handled by Inventory Analysis

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  version: 6.0.1 stable
  rev: 4467 (addons)
  platform: Ubuntu 10.04

  
  1. Create a UOMs as follows:
      "PCE" of category "unit" with ratio = 1
      "CT (12)" of category "unit" with ratio = 12

  2. Create a product:
      name="Orval Beer"
      cost=12.00
      default Unit of Measure="CT (12)"
      default Purchase Unit of Measure="CT (12)"
      Assign a Supplier for later Purchase Order test

  3. Add starting stock:
      On product form, click "Update" button and add stock quantity of 10.00 to "Stock" location.

  4. Perform Inventory Analysis.
      Run: Warehouse/Reporting/Inventory Analysis

      Search for "Orval" to locate the product

      Issue#1 "Quantity" is NOT expressed in the products "default UOM" (should be 10.00 not 120.00)
      Issue#2 "Total Value" is INCORRECT at 1440.00 (should be 120.00)

  5. Perform a Procurement/Purchase/Reception
      Purchase and receive 10.00 with a UOM of "CT (12)"

     Examining the Product Form all looks okay, now 20.00 CT (12) in
  Real and Virtual Stock.

  6. Perform Inventory Analysis
      Notice that now "Quantity" is 240.00 and "Total Value" is 2880.00 (at least consistent) 

  Looking behind the scene a little, the "report_stock_move" view in postgres is storing:
      a. "product_qty" column as 10.00 being a UOM of "CT (12)"
      b. "product_qty_in" as 120.00 being a UOM of "PCE"

  This looks like trouble mixing representations of QUANTITY/UOM.

  report_stock_move table/view records the "product_uom" as being "CT
  (12)" and yet "product_qty_in" is recorded as a UOM of "PCE"

  ----------------------------------------------
  My summary of situation:

  1. Invoice Analysis should express to user the "Quantity" as the product's default UOM
  2. generation of report_stock_move records should be consistent when representing a quantity in the record.

  ps: wish we had a preview function before posting, hope layout is okay