Microsoft Dynamics 365 Blog

Avoid index length issues with InventDim 

1 min read

In Microsoft Dynamics AX we use indexes to ensure uniqueness. An example of this is the DimIdx index in InventDim, where all dimension fields are included to ensure that only a single record exists for a given set of dimensions. However, the SQL Server has a limitation of 16 fields in an index. With the…Read more