Somesh Khare has proposed merging
lp:~openerp-dev/openobject-addons/6.0-opw-51246-skh into
lp:openobject-addons/6.0.
Requested reviews:
Naresh(OpenERP) (nch-openerp)
For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-51246-skh/+merge/86942
Hello,
There is the issue in Inventory Analysis Report. It shows wrong qty when
different UOM,
Scenario:
1. Create a stockable product named PF2 and set an initial stock at 100 Kg
2. Create a PO for 51000 g, Receive the product.
3. Now Go-to Warehouse/Reporting/Inventory Analysis and search for
Product: PF2
4. You see that in the view Inventory analysis the column 'Qty' mixes up
Kg and G. Where everything should be based on default UoM (instead od purchase
UoM)
[Fix]: The branch fixes the issue into the stable 6.0.
Thanks,
Somesh Khare
--
https://code.launchpad.net/~openerp-dev/openobject-addons/6.0-opw-51246-skh/+merge/86942
Your team OpenERP R&D Team is subscribed to branch
lp:~openerp-dev/openobject-addons/6.0-opw-51246-skh.
=== modified file 'stock/report/report_stock_move.py'
--- stock/report/report_stock_move.py 2011-05-03 09:57:42 +0000
+++ stock/report/report_stock_move.py 2011-12-27 11:07:01 +0000
@@ -176,12 +176,12 @@
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(-pt.standard_price * m.product_qty)::decimal, 0.0) as value,
+ coalesce(sum(-pt.standard_price * m.product_qty * pu.factor / u.factor)::decimal, 0.0) as value,
CASE when pt.uom_id = m.product_uom
THEN
coalesce(sum(-m.product_qty)::decimal, 0.0)
ELSE
- coalesce(sum(-m.product_qty * pu.factor)::decimal, 0.0) END as product_qty
+ coalesce(sum(-m.product_qty * pu.factor / u.factor )::decimal, 0.0) END as product_qty
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
@@ -200,12 +200,12 @@
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(pt.standard_price * m.product_qty )::decimal, 0.0) as value,
+ coalesce(sum(pt.standard_price * m.product_qty * pu.factor / u.factor )::decimal, 0.0) as value,
CASE when pt.uom_id = m.product_uom
THEN
coalesce(sum(m.product_qty)::decimal, 0.0)
ELSE
- coalesce(sum(m.product_qty * pu.factor)::decimal, 0.0) END as product_qty
+ coalesce(sum(m.product_qty * pu.factor / u.factor)::decimal, 0.0) END as product_qty
FROM
stock_move m
LEFT JOIN stock_picking p ON (m.picking_id=p.id)
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
