Hello

• We’d like to get an automatic generation of our quotation number

Our existing number system is as follow:

AA-BBB-YY00-000

Where A is the Department (S-Sales, P-Projects, CS-Construction and Service)

BBB is either the first letters of the company name or the first three letters of the company name e.g. Eg: Barbados Agricultural Management Company = BAMC, or Guysuco = GUY)

YY = Year

00 = running count of quotes for the customer

000 = Runnin count of all quotes

Therefore a quote number S-BAMC-1405-235 tells me that the Sales Department generated 5 quotes for Barbados Agricultural Management Company in 2014, and it was the 235^th quote for the year.

Can this be achieved?