Item Number generation based on Main Category and Sub Category

Summary:

Hi Team,

Item Number need to be generated automatically after selecting the Main Category and Sub Category.

User wants to select the Main category and Sub category while creating the Item. The Item Number need to be generated automatically.

For Example:

1. For "Stationery.Books" the item name sequence need to be generated as "12.02.01"
2. For "Stationery.Publications" the item name sequence need to be generated as "12.03.01"

From the above points

Sequence number for Main Category

" Stationery" --> 12

Sequence number for Sub Categories:

"Books" ---> 02.01

"Publications" ----> 03.01

Our expectation is to generate the Item number automatically based on Main and Sub Category.