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
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
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.
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
0
okt. 24
|
3987 | ||
|
|
0
aug. 23
|
3482 | ||
|
How to generate sequence value
Opgelost
|
|
1
mrt. 23
|
4842 | |
|
|
0
jan. 24
|
2678 | ||
|
5
sep. 25
|
29572 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
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