I wanted to generate number as per region and division like..
I have four regions: Africa, America, Asia, Oceania and divisions are Electrical MEP HVAC Plumbing also, it should consider financial year as per one date filed named as 'Enquiry received date' e.g. If the inquiry received date is 1st April 2019, and region is America, the division is MEP then Numbers should be AM-19-20-ME-001 (AM-America, 19-20 - enq received year, ME-MEP, 001 and so on) & If the enquiry received date is 1st April 2019, and region is Asia, division is Electrical then Numbers should be AS-19-20-EL-001