Multiple UOM not handled by Inventory Analysis
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) |
Fix Released
|
Low
|
OpenERP R&D Addons Team 2 |
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/
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 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
Related branches
- Rucha (Open ERP) (community): Approve
- qdp (OpenERP): Pending requested
-
Diff: 55 lines (+14/-6)1 file modifiedstock/report/report_stock_move.py (+14/-6)
- OpenERP Core Team: Pending requested
-
Diff: 57 lines (+16/-6)1 file modifiedstock/report/report_stock_move.py (+16/-6)
summary: |
- Multiple UOM not handled by Inventory Analysis + [6.0.1] Multiple UOM not handled by Inventory Analysis |
Changed in openobject-addons: | |
status: | Confirmed → In Progress |
Changed in openobject-addons: | |
status: | Fix Committed → Fix Released |
tags: | added: maintenance |
Thanks for Reporting...