Merge lp:~openerp-dev/openobject-server/6.1-opw-581437-skh into lp:openobject-server/6.1

[Somesh Khare]

Hello Sir,

[FIX]ir_sequence : Next number not updated when selection field implementation set as standard

Steps:
1. change the selection field implementation as "standard" for any sequence. eg: Sales Order
2. set the next number fields as 1.
3. Create a new Sales Order and see the Sale Sequence, it will be SO001 now Open Sale Order sequence from menu "Settings/Configuration/Sequences & Identifiers/Sequences" and look at the next number field.
4. It is still as 1 where it should be according to the "increment number" field.

This branch fixes this issue.

Kindly review the branch and please share your views with us.

Thanks & Regards,
Somesh Khare

[Naresh(OpenERP) (nch-openerp)]

Hello,

This bug was qualified as Confirmed on Trunk (means still existing and reproducible). A Merge Proposal for trunk was created to fix it. Here is the link to follow the MP on Launchpad https://code.launchpad.net/~openerp-dev/openobject-server/trunk-opw-581437-port-kbh/+merge/138386 and be informed once it's been merged in trunk: ... If this Merge Proposal could not be merged in v6.1 at the release of v7.0, it will be closed.

Thanks,
Naresh Soni

Unmerged revisions

4297. By Somesh Khare on 2012-11-07

[FIX]ir_sequence : Next number not updated when selection field implementation set as standard (Case: Ref 581437)

=== modified file 'openerp/addons/base/ir/ir_sequence.py'
--- openerp/addons/base/ir/ir_sequence.py	2012-01-24 11:47:30 +0000
+++ openerp/addons/base/ir/ir_sequence.py	2012-11-07 10:07:19 +0000
@@ -200,6 +200,7 @@
         if seq['implementation'] == 'standard':
             cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
             seq['number_next'] = cr.fetchone()
+            cr.execute("UPDATE ir_sequence SET number_next=number_next+number_increment WHERE id=%s ", (seq['id'],))
         else:
             cr.execute("SELECT number_next FROM ir_sequence WHERE id=%s FOR UPDATE NOWAIT", (seq['id'],))
             cr.execute("UPDATE ir_sequence SET number_next=number_next+number_increment WHERE id=%s ", (seq['id'],))