Problem Statement :
There are various Sales Team namely (East, West, North, Hyderabad, Chennai, Bangalore, Gujarat) and each has a special opportunity numbering system as follows :
- East : 24E00001 where 24 is the year, E means East
- West: 24W00001 where 24 is the year, W means West
- North: 24N00001 where 24 is the year, N means North
- Hyderabad : 24H00001 where 24 is the year, H means Hyderabad
- Chennai: 24C00001 where 24 is the year, C means Chennai
- Bangalore: 24B00001 where 24 is the year, B means Bangalore
- Gujarat: 24G00001 where 24 is the year, G means Gujarat
- 00001 is the serial number which needs to be updated automatically whenever a new opportunity is created respective to each sales team.
How to automate this process using Odoo Studio
Maybe this example can help you: https://odootricks.tips/set-sequence-numbers-for-sales-orders/