openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #14084
[Bug 1029634] [NEW] mrp confirm creates consumed products lines twice
Public bug reported:
fresh install of mrp module
using [CPU_GEN] Regular processor config
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+-------+---------------------+---------------+------------+-------------+------------------
101 | 18 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
100 | 18 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
99 | 15 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
98 | 15 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
97 | 8 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
96 | 8 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
95 | 10 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
94 | 10 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
93 | 17 | 6.000 | done | 2012-07-26 20:07:38 | 8 | | 7 | 11
(9 rows)
Confirm
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+---------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
109 | 18 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
107 | 15 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
105 | 8 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
103 | 10 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | waiting | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
after Force availablility it looks like - please not the resources with
picking which are already done
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+----------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
109 | 18 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
107 | 15 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
105 | 8 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
103 | 10 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | waiting | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
after cancel of a MO we have canceled and done stock moves which is wrong
I think the associated picking has to be canceled too.
due to the fact that from and to location of the done is identical (ma be only in this example) the compution of stock qty is not affected - the qustion remains - what is the purpose of theses stock moves ?
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+--------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
109 | 18 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
107 | 15 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
105 | 8 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
103 | 10 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | cancel | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1029634
Title:
mrp confirm creates consumed products lines twice
Status in OpenERP Addons (modules):
New
Bug description:
fresh install of mrp module
using [CPU_GEN] Regular processor config
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+-------+---------------------+---------------+------------+-------------+------------------
101 | 18 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
100 | 18 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
99 | 15 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
98 | 15 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
97 | 8 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
96 | 8 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
95 | 10 | 6.000 | done | 2012-07-26 20:07:16 | | 15 | 11 | 11
94 | 10 | 6.000 | done | 2012-07-26 20:07:38 | | | 11 | 7
93 | 17 | 6.000 | done | 2012-07-26 20:07:38 | 8 | | 7 | 11
(9 rows)
Confirm
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+---------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
109 | 18 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
107 | 15 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
105 | 8 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | waiting | 2012-07-26 20:13:47 | | 16 | 19 | 19
103 | 10 | 5.000 | waiting | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | waiting | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
after Force availablility it looks like - please not the resources
with picking which are already done
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+----------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
109 | 18 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
107 | 15 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
105 | 8 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
103 | 10 | 5.000 | assigned | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | waiting | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
after cancel of a MO we have canceled and done stock moves which is wrong
I think the associated picking has to be canceled too.
due to the fact that from and to location of the done is identical (ma be only in this example) the compution of stock qty is not affected - the qustion remains - what is the purpose of theses stock moves ?
test_mrp=# select id,product_id,product_qty,state,date,production_id,picking_id,location_id,location_dest_id from stock_move order by id desc limit 9;
id | product_id | product_qty | state | date | production_id | picking_id | location_id | location_dest_id
-----+------------+-------------+--------+---------------------+---------------+------------+-------------+------------------
110 | 18 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
109 | 18 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
108 | 15 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
107 | 15 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
106 | 8 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
105 | 8 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
104 | 10 | 5.000 | done | 2012-07-26 20:15:45 | | 16 | 19 | 19
103 | 10 | 5.000 | cancel | 2012-07-26 20:13:47 | | | 19 | 7
102 | 17 | 5.000 | cancel | 2012-07-26 20:13:47 | 9 | | 7 | 18
(9 rows)
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1029634/+subscriptions
Follow ups
References
