To change the sequence number format for sales orders in Odoo, follow these steps:
1. Navigate to the Sequence Settings:
Go to the Settings module in Odoo.
Under the “Technical” section, select Sequences & Identifiers > Sequences. (Note: If the “Technical” menu is not visible, ensure the “Developer Mode” is enabled. You can enable it from the “About Odoo” section in Settings.)
2. Locate the Sales Order Sequence:
Search for the sequence named Sales Order (or SO depending on your Odoo localization).
Click on the sequence to open its settings.
3. Edit the Sequence Format:
The sequence format is defined in the “Prefix” and “Sequence Number” fields.
Examples:
SO/{year}/{month}/ will generate sales orders like SO/2024/12/001.
SO- will generate sales orders like SO-00001.
Adjust Key Fields:
Prefix: Defines the prefix for the sequence. You can include placeholders like:
{year}: Current year.
{month}: Current month.
{day}: Current day.
Padding: Defines the number of digits in the sequence number (e.g., 5 means 00001).
Next Number: Defines the next number that will be generated.
4. Save the Changes:
Once you modify the sequence settings, save your changes.
Future sales orders will use the updated sequence format.
Optional: Apply the New Sequence to Existing Orders
If you want to update existing sales orders with the new sequence format, it will require a database update through an Odoo script or manual edits via the backend. Let me know if you need help with this!