We have 3 Vendor account groups:
Now all these account groups have internal NR, i.e. Domestic account (10001-19999), Import (20001-29999), Others (30001-39999)
Now my Client wants when ever we save Vendor master record, System has to generate Number range starting with 1 alphanumeric letter followed by 5 numeric digits. Alphabet should be the first letter of the Vendors Name mentioned.
i.e. For Domestic vendor : Name: Raj, NR: R10001.
For Domestic vendor : Name: Rajeshwar, NR: R10002
For Domestic vendor : Name: Sameer , NR: S10001
How to do it.