credativ team mailing list archive

[Evert Dausy <810934@xxxxxxxxxxxxxxxxxx>]

** Description changed:

  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
+  ##############################################################################
+  #
+  #    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,
+          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)
+      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,
+          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)
+      FROM
+          stock_move m
+              LEFT JOIN stock_picking p ON (m.picking_id=p.id)

-- 
You received this bug notification because you are a member of OpenERP
Framework Experts, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/810934

Title:
  [6.0.2] Wrong Warehouse/Reporting/Inventory Analysis when you have
  move lines with different UoM

Status in OpenERP Addons (modules):
  Fix Released

Bug description:
  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/810934/+subscriptions