Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
2496 Zobrazení

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
Zrušit
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


Nejlepší odpověď

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
Zrušit
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.

Related Posts Odpovědi Zobrazení Aktivita
0
říj 24
2474
0
srp 23
1775
1
bře 23
2864
0
led 24
1232
1
kvě 25
2448