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!
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!
Thanks Sukrut
Hi Arpan ,
you should go through following whitepaper , if you want to know more about it and how it is implemented
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.
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!
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.
Best regards,
Ludwig
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,353 Super User 2024 Season 2
Martin Dráb 228,251 Most Valuable Professional
nmaenpaa 101,148