Create an Identity column in AX

It so happens that from time to time you get the request in AX to create a column that will increment it's value by one with each record you create (basically the Identity column property in SQL).

Well, for those of you who did not know or use this property up until now, on an Integer type column you have in AX the IdentityField property. When you will set this, the definition of the column that will be created in SQL will have the Identity specification set to Yes and it's value will increment with 1 at saving time.


  1. It is very useful, thank you very much!

  2. To what version of AX does this apply? We are on AX 2012, and I don't see this option.

  3. I am using this frequently on R3, might have been introduced with R2? But I am not sure ...