Most of the time after you change the PK of a table you will get this error.

This is an invalid type of primary key for the autosplitkey facility. It should be Integer/BigInteger/Decimal/GUID.

This is why, If you use the property of Autosplitkey as Yes, It is necessary to end your primary key with integer.As a example,if you use bellow combination and set Yes in Autosplitkey, you will get above error. My example I have primary key like this Document No.,Line No.,Date .This is not ending with Integer Type .So if you create like this (Document No.,Date,Line No.) you never get this error.

Lesson learned :: If you really want to use Autoslitkey property , You should have Integer type filed at the end of the Primary Key . 

NOTE ::: DO NOT CHANGE PRIMARY KEY IN DYNAMICS NAV BASE TABLE.


 

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *
Website

*

Add User 2013R2

Workflow Dynamics NAV 2016