Finance forum

what is the difference between Invent Trans and InventTransOrigin?

(0) Share

Report

Posted on by @rp@n

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!

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

Sukrut Parab 71,741 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 306,697 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sukrut

Was this reply helpful? Yes No