Hello, We use Sage50 accounting software and want to give our customers an account number. I tried using the record IDs for contacts and companies, but as Sage has an 8-digit character limit, these have become a problem for us. It would be great if there was a way, either via workflow or some way else we can create an account reference/number field. I would ideally like to dictate it, so it might start with a 2-letter prefix like HU and then a 6-digit unique number that is constantly updating as each new company is created (or contact becomes a customer). Please can you look at doing this?
...read more