v 6.0.2. The Warehouse/Reporting/Inventory Analysis is wrong when you have move lines with different UoM of the same UoM category. I think the factor conversion in the related postgres view is not correctly computed.
If the following 4 multiplications are changed by 4 divisions the inventory analysis works Ok:
Index: report/report_stock_move.py
===================================================================
--- report/report_stock_move.py (revisión: 146)
+++ report/report_stock_move.py (copia de trabajo)
@@ -1,4 +1,4 @@
-# -*- coding: utf-8 -*-
+# -*- coding: utf-8 -*-
##############################################################################
#
# OpenERP, Open Source Management Solution
@@ -176,8 +176,8 @@ m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type, m.company_id,
m.state as state, m.prodlot_id as prodlot_id,
- coalesce(sum(-m.product_qty * u.factor)::decimal, 0.0) as product_qty,
- coalesce(sum(-pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value
+ coalesce(sum(-m.product_qty / u.factor)::decimal, 0.0) as product_qty,
+ coalesce(sum(-pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
@@ -195,8 +195,8 @@ m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type, m.company_id,
m.state as state, m.prodlot_id as prodlot_id,
- coalesce(sum(m.product_qty*u.factor)::decimal, 0.0) as product_qty,
- coalesce(sum(pt.standard_price * m.product_qty * u.factor)::decimal, 0.0) as value
+ coalesce(sum(m.product_qty/u.factor)::decimal, 0.0) as product_qty,
+ coalesce(sum(pt.standard_price * m.product_qty / u.factor)::decimal, 0.0) as value
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
v 6.0.2. The Warehouse/ Reporting/ Inventory Analysis is wrong when you have move lines with different UoM of the same UoM category. I think the factor conversion in the related postgres view is not correctly computed.
If the following 4 multiplications are changed by 4 divisions the inventory analysis works Ok:
Index: report/ report_ stock_move. py ======= ======= ======= ======= ======= ======= ======= ======= ==== report_ stock_move. py (revisión: 146) report_ stock_move. py (copia de trabajo) ####### ####### ####### ####### ####### ####### ####### ####### ####### ####### ##
m.product_ id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,
m.company_ id, sum(-m. product_ qty * u.factor)::decimal, 0.0) as product_qty, sum(-pt. standard_ price * m.product_qty * u.factor)::decimal, 0.0) as value sum(-m. product_ qty / u.factor)::decimal, 0.0) as product_qty, sum(-pt. standard_ price * m.product_qty / u.factor)::decimal, 0.0) as value
m.product_ id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,
m.company_ id, sum(m.product_ qty*u.factor) ::decimal, 0.0) as product_qty, sum(pt. standard_ price * m.product_qty * u.factor)::decimal, 0.0) as value sum(m.product_ qty/u.factor) ::decimal, 0.0) as product_qty, sum(pt. standard_ price * m.product_qty / u.factor)::decimal, 0.0) as value
=======
--- report/
+++ report/
@@ -1,4 +1,4 @@
-# -*- coding: utf-8 -*-
+# -*- coding: utf-8 -*-
######
#
# OpenERP, Open Source Management Solution
@@ -176,8 +176,8 @@
m.state as state, m.prodlot_id as prodlot_id,
- coalesce(
- coalesce(
+ coalesce(
+ coalesce(
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
@@ -195,8 +195,8 @@
m.state as state, m.prodlot_id as prodlot_id,
- coalesce(
- coalesce(
+ coalesce(
+ coalesce(
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)