Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
3560 Vistas

Hi everyone,


I'm beginner on Odoo12 and I'm trying to update a data in the database using custom module, but it's not working.

Thanks for your help.


class IrSequence(models.Model):
_inherit = "ir.sequence"

@api.model
def _update_sequence(self):
cr = self._cr
cr.execute("SELECT id FROM ir_sequence WHERE name = 'BILL Sequence' LIMIT 1")
sequence_data = cr.fetchone()

if sequence_data:
cr.execute(
"UPDATE ir_sequence SET name='INV Sequence', implementation='standard', prefix='INV/%(range_year)s/', use_data_range=0 WHERE id = %s",
(sequence_data[0]))
return True
Avatar
Descartar
Mejor respuesta

It looks like you're trying to update the sequence numbering. You can do that through a configuration settings rather than writing a custom module.

It's under the Settings -> Technical -> Sequences & Identifiers -> Sequences menu. Typing in Sequences on the search bar on the home page should bring it up.

Also note that it is usually easier, and safer, to update data through the API instead of directly through the SQL database. 

Avatar
Descartar
Autor Mejor respuesta

Thank for your answer. So It's more difficult and dangerous to do it through a custom.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
2
jun 22
5372
1
mar 19
5799
3
sept 17
22631
2
sept 21
3728
5
dic 19
5246