Odoo Addons (MOVED TO GITHUB)

Merge lp:~openerp-dev/openobject-addons/6.1-opw-590457-pna into lp:openobject-addons/6.1

  1. 6.1-opw-590457-pna
  2. Merge into 6.1
Proposed by Pinakin Nayi (OpenERP)
Status: Merged
Approved by: Chris Biersbach (OpenERP)
Approved revision: no longer in the source branch.
Merged at revision: 7199
Proposed branch: lp:~openerp-dev/openobject-addons/6.1-opw-590457-pna
Merge into: lp:openobject-addons/6.1
Diff against target: 19 lines (+2/-0)
1 file modified
stock/report/report_stock_move.py (+2/-0)
To merge this branch: bzr merge lp:~openerp-dev/openobject-addons/6.1-opw-590457-pna
Reviewer Review Type Date Requested Status
Naresh(OpenERP) Pending
Review via email: mp+157103@code.launchpad.net

Description of the change

Hello Sir,

I fixed problem in stock inventory analysis.

To Reproduce :
- Create product, request for procurement
- Now cancel created procurement
Now, go to warehouse > Reporting > Inventory Analysis it displayed cancelled procurement product qty also.

Expected :
Normally its not display move qty which is cancelled.

To post a comment you must log in.
Revision history for this message
Chris Biersbach (OpenERP) (cbi-openerp) wrote :

Works fine. I'll also merge it in 7.0.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'stock/report/report_stock_move.py'
2--- stock/report/report_stock_move.py 2011-12-19 16:54:40 +0000
3+++ stock/report/report_stock_move.py 2013-04-04 13:02:23 +0000
4@@ -189,6 +189,7 @@
5 LEFT JOIN product_uom pu2 ON (m.product_uom=pu2.id)
6 LEFT JOIN product_uom u ON (m.product_uom=u.id)
7 LEFT JOIN stock_location l ON (m.location_id=l.id)
8+ WHERE m.state != 'cancel'
9 GROUP BY
10 m.id, m.product_id, m.product_uom, pt.categ_id, m.address_id, m.location_id, m.location_dest_id,
11 m.prodlot_id, m.date, m.state, l.usage, m.company_id, pt.uom_id
12@@ -210,6 +211,7 @@
13 LEFT JOIN product_uom pu2 ON (m.product_uom=pu2.id)
14 LEFT JOIN product_uom u ON (m.product_uom=u.id)
15 LEFT JOIN stock_location l ON (m.location_dest_id=l.id)
16+ WHERE m.state != 'cancel'
17 GROUP BY
18 m.id, m.product_id, m.product_uom, pt.categ_id, m.address_id, m.location_id, m.location_dest_id,
19 m.prodlot_id, m.date, m.state, l.usage, m.company_id, pt.uom_id