Changes in Microsoft Dynamics AX InventTrans data Model

The purpose of this post was to give a overview about the changes been made in the Dynamics AX, data model related to Inventory transactions.

Before AX2012, the only table used for recording all the inventory transactions was InventTrans. In AX2009, a lot of data in InventTrans was either redundant or fields be used to represent a specific type of transaction Like sales, purchase, transfer etc.

In AX2012, the base was still the same i.e. every inventory still gets recorded in the  InventTrans  but The only difference are that the table have been more normalized now. A new table has been added called  inventtransorigin  which are actually now holding the relations Hip between the originating tables (transaction tables)  and InventTrans. The Inventtransid, Transtype and Transrefid has now been removed from the InventTrans and moved to the Inventtransorigin Table with names Inventtransid, Referencecategory and Referenceid respectively.

Every transaction have now its own inventtransorigin table. For example, with case of purchline the table named wasInventtransoriginpurchline which is actually referring to inventtransorigin through the Inventtransid field. Transaction tables like PurchLine, SalesLine, Prodline etc still contains a INVENTTRANSID field but it isn't recommended to Use/refer them. It's expected to being depreciated in the future.

Changes in Microsoft Dynamics AX InventTrans data Model