Implementing Inventtrans Refactoring for Microsoft Dynamics Ax 2012 Applications

Only available on StudyMode
  • Download(s) : 108
  • Published : September 12, 2012
Open Document
Text Preview
Microsoft Dynamics AX 2012
®

Implementing InventTrans Refactoring for Microsoft Dynamics AX 2012 Applications White Paper This document discusses the refactoring of the InventTrans table and common design patterns. It also discusses how to implement these changes when developing new features or updating existing features. http://microsoft.com/dynamics/ax Date: January, 2011 Author: Kim Moerup, Senior Developer, Inventory Management Send suggestions and comments about this document to adocs@microsoft.com. Please include the title with your feedback.

Table of Contents
Overview..................................................................................................... 3 Audience ..................................................................................................... 3 Document purpose ...................................................................................... 3 Data model changes .................................................................................... 4 Fields deleted from the InventTrans table ................................................................................ 5 Developing new features ........................................................................................................ 6 Upgrading existing features .................................................................................................... 6

Design patterns........................................................................................... 6 Relationships between inventory transaction originating tables and the InventTrans table .............. 6 Modifying custom code ....................................................................................................... 7 The Direction field ................................................................................................................. 7 The TransType and TransRefId fields ....................................................................................... 7 The ItemRouteId and ItemBomId fields ................................................................................... 7

Conclusion .................................................................................................. 8

2 IMPLEMENTING INVENTTRANS REFACTORING FOR MICROSOFT DYNAMICS AX 2012 APPLICATIONS

Overview
One of the largest tables in Microsoft Dynamics® AX has always been the InventTrans table. Over time, this table has kept growing because of too much redundant data. Microsoft Dynamics AX 2012 begins to change this trend by starting the process of refactoring parts of the table. The refactoring has the following purposes:   To reduce the amount of data stored (disk space) To refactor parts of the table to avoid redundant data and the inherent risk of inconsistent data

In previous versions of Microsoft Dynamics AX, fields named InventTransId were used to identify sets of inventory transactions in the InventTrans table and to identify the origin of inventory transactions in originating tables, such as the SalesLine, PurchLine, ProdTable, or InventJournalTrans table. Despite its name, InventTransId was not the ID for inventory transactions. The best way to describe the field is that it identified the set of inventory transactions related to a given inventory transaction originating record. In Microsoft Dynamics AX 2012, we introduce a new table named InventTransOrigin for which RecId is the primary key, but for which InventTransId is the alternate or natural key. The new table stores data that is common to all the transactions related to the same inventory transaction originating record.

Audience
This document is intended for developers building new applications for Microsoft Dynamics AX 2012, as well as for developers updating their existing application code and data.

Document purpose
This document highlights the new design pattern used to implement relationships between the InventTrans table and inventory...
tracking img