Unique Account Reference

[Parker1090]

Continuing the discussion from How do I create an automatic account reference:

@Glenn

Are you referring to purchase reference? Account references are assigned to clients rather than invoices? The answer either way unfortunately will be no. Purchase references are issued by clients so shouldn’t be automatically generated, account references for new clients aren’t generated automatically, they are a non-mandatory field.

I know you’ve mentioned that client account reference is a non-mandatory field, but is it possible to force them to be unique at all?

[Glenn]

The problem with forcing them to be unique now is there will be duplicates already there on many accounts. If we do this we’d need to switch it on as a constraint at the account level rather than make it a global change, this involves a bit more work, it’s certainly possible but for now all I can do is note it down and come back to it.

[Glenn]

We’ve added an additional check to the client entry screen so that the account reference will be checked for uniqueness when you tab out of the box. We couldn’t go all out and enforce uniqueness as there are already many accounts with duplicate account references and there may be some use cases where it’s actually required. Hopefully this is the next best thing!

[Parker1090]

@Glenn, as always - you and you’re team are brilliant

Thank you - it’ll save a few headaches!