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.




Comments (3)

  1. Joe Ellidge says:

    hey! I think this website is great! its, good because it gives general knowledge and it=s just generally interesting to read. I was wondering if you would be so kind as to visit my blog and comment in some way on my posts, just to boost my blog, because
    I've just started, here is the link...
    http://technoglobe25.blogspot.co.uk/ Thank you!

  2. Anonymous says:

    We are pleased to announce the availability of KB 3030212 “Duplicate InventDim records are created

  3. Anonymous says:

    We are pleased to announce the availability of KB 3030212 “Duplicate InventDim records are created

Skip to main content