Forum Message

Generate Auto ID Question

Hi There

I hjave 2 questions relating to Auto ID generation:

  1. Our Invoices and PO numbers use a ABC0000 001 type structure where just the 001 would increment. I cannot seem to put in the ABC0000 part of this as string. Is there a way of doing this or getting close to doing this?

  2. Another part of our business uses a Date wildcard for PO's. So they are PO0611-001 for June, PO0711-001 for July etc. Is there a way to add a date wildcard into the auto ID's.

Any help is appreciated. I know these are probably very bespoke requests so don't be worried to say its not possible, we save enough time using this product anyway.

DaveK


Posted by Dave on Jun 22, 2011 12:24 PM BST

Hi Dave,

If you want to ensure that some part of the format is not changed, just enclose it in single quotes. So in your case set the Format column to:
'ABC00000 '000

This will produce the sequence ABC0000 001, ABC0000 002, ABC0000 003, etc.

Unfortunately there is no way to include the date automatically in the default ID. You will need to change the default format each month.

Regards,


Posted by Mark McLaren (Solar Accounts) on Jun 22, 2011 1:47 PM BST