** Branch linked: lp:~openerp-dev/openobject-addons/trunk-bug-741457-ron
--
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):
Fix Committed
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
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
