{"id":43606,"date":"2010-11-07T14:09:00","date_gmt":"2010-11-07T14:09:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/dynamicsaxscm\/2010\/11\/07\/the-inventtrans-table-explore-various-field-usages\/"},"modified":"2023-05-31T15:39:03","modified_gmt":"2023-05-31T22:39:03","slug":"the-inventtrans-table-explore-various-field-usages","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2010\/11\/07\/the-inventtrans-table-explore-various-field-usages\/","title":{"rendered":"The InventTrans table. Explore various field usages."},"content":{"rendered":"

Introduction <\/h4>\n

No doubt, the InventTrans table is one of the most important tables in the inventory engine within Microsoft Dynamics AX 2009. It stores inventory transactions, which include a lot of the business data that is crucial to the functionality like reservations, on-hand quantities, inventory value calculations, and so forth.<\/p>\n

There are number of different fields in InventTrans that contain information about:<\/p>\n

    \n
  1. \n
    Original source documents like purchase order or sales order lines – their states, items, quantities, document numbers, and so forth.<\/div>\n<\/li>\n
  2. \n
    Time and place differences when business events such as physical or financial update have occurred.<\/div>\n<\/li>\n
  3. \n
    Reference data which is important to different modules like Fixed Assets, Project Accounting.<\/div>\n<\/li>\n
  4. \n
    And much more \u2026<\/div>\n<\/li>\n<\/ol>\n

    Today we want to focus on group #3 and explore how the certain fields on InventTrans are used, and what are their primary purposes. Let\u2019s take a look at:<\/p>\n