Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / what is the difference...
Finance forum
Answered

what is the difference between Invent Trans and InventTransOrigin?

Posted on by 5,901

Dear all,

Can you please let me know what is the difference between Invent Trans and InventTransOrigin?

What is the use of InventTransOrigin?

Please give me more she'd on this

Thanks!

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Thanks Sukrut

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Hi Arpan ,

    you should go through following whitepaper , if you want to know more about it and how it is implemented

    download.microsoft.com/.../Implementing_InventTrans_refactoring_for_Microsoft_Dynamics_AX_Applications_AX2012.pdf

    Here is content from above white paper .

    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

    And yes if you need data from both tables you can get it by joining these tables.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Thanks all,

    I saw the above link shared by Sukrut, and understand that to do the Normalization InventTransOrigin table will create.. Means large table isolate in to smaller table and define relation between them.

    Invent Trans is Large table and InventTransOrigin is smaller table.

    If required to fetch data from both Tables then need to write query for  both tables to get data.

    Is it correct?

    Thanks!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Hi,

    You can check the difference yourself.

    Just make use of the sys table browser feature and enter the inventtrans and inventtransorigin tables in the blue highlighted string.

    Then you can compare the different elements the tables hold yourself.

    7870.trans.png

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,353 Super User 2024 Season 2 on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Hi Arpan,

    A similar data model has been created for accounting entries. There you have the tables GeneralJournalEntry and GeneralJournalAccount entry. The purpose is to have no redundant data in the system which would consume database space.

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Inventtransorigin is normalized table . You can easily see relationship in AOT. You can find more information in below link to see what changes have been made in 2012 .

    www.axpulse.com/.../changes-in-microsoft-dynamics-ax-2012-inventtrans-data-model

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans