Skip to main content

Notifications

Announcements

No record found.

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

what is the difference between Invent Trans and InventTransOrigin?

(0) ShareShare
ReportReport
Posted on by

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 on at
    RE: what is the difference between Invent Trans and InventTransOrigin?

    Thanks Sukrut

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,671 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 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... 291,642 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,671 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans