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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
