title: (Automated Action) Odoo Problem with write() and do for loop
body: <p>I'm trying to update the 'sequence' value in model 'product.supplierinfo' with an Automated Action, so that when the supplier's price are updated from a purchase order, that supplier is prioritized to calculate the replenishment cost. To achieve that, the new/updated record must get the lowest 'sequence' value for that product.</p>
  
  <p><a href="https://i.stack.imgur.com/Wx28o.png" rel="nofollow noreferrer">Automated Action Screenshoot</a></p>
  
  <p>Automated Action Settings:
  Model: product.supplierinfo
  Action: Execute Python code
  Condition: Create and update</p>
  
  <p>This part of the py resets the sequences starting from 2 successfully:</p>
  
  <pre><code>val = 1
  registers = model.search([('product_tmpl_id','=',record.product_tmpl_id.id)], order = "sequence asc")
  for reg in registers:
    val = val + 1
    reg['sequence'] = val
  </code></pre>
  
  <p>And this other one gives the updated/new line the sequence value 1 successfully:</p>
  
  <pre><code>record.write({'sequence': 1})
  </code></pre>
  
  <p>However, when put all together, all the lines get sequence 1:</p>
  
  <pre><code>val = 1
  registers = model.search([('product_tmpl_id','=',record.product_tmpl_id.id)], order = "sequence asc")
  for reg in registers:
    val = val + 1
    reg['sequence'] = val
  record.write({'sequence': 1})
  </code></pre>
  
  <p>As I'm pretty noob, I even assumed that maybe the loop wouldn't end with the indent and tried this other one to proof I'm missing something (first setting sequence 1 to the aimed record and then dropping that record from the search method). It still gets 1 on all the register's sequence value:</p>
  
  <pre><code>record.write({'sequence': 1})
  val = 1
  registers = model.search([('product_tmpl_id','=',record.product_tmpl_id.id),('id','!=', record.id)], order = "sequence asc")
  for reg in registers:
    val = val + 1
    reg['sequence'] = val
  </code></pre>
  
  <p>Any idea why it doesn't set the trigger record's sequence 1 and then the rest from 2 and on?</p>