Microsoft Dynamics AX 2012 R3 RTM Warehouse Management: How to prevent the creation of two inventDim records considered identical in Dynamics AX 2012 R3 RTM

In Microsoft Dynamics AX 2012 R3 RTM we have released a new warehouse management system including concepts of license plate and inventory status implemented as inventory dimensions. In Dynamics AX 2012 R3 RTM an issue exists in the inventory dimension hashing that can lead to duplicated inventory dimensions. This issue has been fixed as part of Dynamics AX2012 R3 CU8.

In Dynamics AX 2012 R3 RTM the issue can occur if blanks trailing a value is used for inventory status or licenseplate. As an example licenseplate = ‘ABCD’ and license plate = ‘ABCD ’ will be hashed differently but the values stored in the licenseplate field in SQL Server will be identical. This means that two inventDim records considered identical will exist in SQL Server, which can lead to erroneous situations in downstream transaction processing. Such errors will potentially not manifest themselves until at a later point in time when the identical inventDim records are processed .

This issue has been fixed as part of Dynamics AX 2012 R3 CU8, such that it is not possible to create inventDim records which will be considered identical.

Customers using Warehouse Management in Microsoft Dynamics AX 2012 R3 RTM are recommended to either move to Dynamics AX 2012 R3 CU8 or implement the below small change in the inventDim.hashKey() method so values are trimmed for trailing blanks. See Dynamics AX 2012 R3 CU8 the inventDim.hashKey() method

Dynamics AX 2012 R3 CU8

In Dynamics AX 2012 R3 CU8 the inventDim.hashKey() method is trimmed for license plate and inventory status.