Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
2479 Vistas

i want to generate a new Sale Order No. (Sequence) when a user press Confirm button on the Quotation screen. 


which field will be updated and what value updated when user Confirm it so i can use it in Automated Action - On Update to generate the sequence for this confirmed order.

please also help to write Python Code to execute to generate new Sequence No.

regards


Avatar
Descartar
Autor

i have done as below, please advise:

1) created a custom field = x_confirm_sale_order_seq in sale.order

2) created a sequence (copied sale.order sequence & modified as required)

3) created an Automated Action (Trigger: On Update - Trigger Field: state)

Python Code:

if record.state == 'sale':

  if not record.x_confirm_sale_order_seq:

    seq = env['ir.sequence'].next_by_code('sale.order.confirm.seq')

    record.write({'x_confirm_sale_order_seq': seq})

when trying to Confirm in Quotations it is showing error:

ValueError: class 'ValueError': "invalid literal for int() with base 10: 'S000026'"

the sequence i have created as below:

Name: Sales Order Confirm Seq

Sequence Code: sale.order.confirm.seq

Sequence Size: 6

Steps: 1

Prefix: S

Next Number: 25

regards


Mejor respuesta

Hi,

You can change the sequence of the Sale Order functionally from the options Sequences under the Technical Menu in General Settings.

To change the sequence functionally you can refer this blog:

https://www.cybrosys.com/odoo/odoo-books/odoo-16-accounting-book/ch7/sequence-number-modification-operations/

If you want to change the sequence through technically when creating a new record in the sale order or in any model, you can refer this blog:

https://www.cybrosys.com/blog/how-to-create-sequence-numbers-in-odoo-16


Hope it helps

Avatar
Descartar
Autor

thank you @Cybrosys but please see my Answer to this query, i already have done but don't know why it is throwing error.

regards

Please mention the type of "x_confirm_sale_order_seq" because the error message means that perhaps you are writing string value into integer field.

Publicaciones relacionadas Respuestas Vistas Actividad
0
oct 24
2461
0
ago 23
1752
1
mar 23
2846
0
ene 24
1226
1
may 25
2429