web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Add a field to InventJ...
Microsoft Dynamics AX (Archived)

Add a field to InventJournalTrans, propagate to InventTrans

(0) ShareShare
ReportReport
Posted on by Vignesh Thirunavukk... 277

Hi i just added a string field in InventJournalTrans and InventTrans table and i need to propagate value from InventJournalTrans to InventTrans, so i have created a new method in Invent movement class and its working fine. InventJournalTrans value is getting inserted in InventTrans.

 inventmovement.PNG

now when i change the value of my field in InventJournalTrans and on saving it its not getting updated in Invent Trans. if i'm changing the value for counted or qty then its getting updated in Invent Trans.

i need to update my field value too is there any solution for this?

*This post is locked for comments

I have the same question (0)
  • Azam Profile Picture
    Azam 385 on at

    Hi Vegnesh 

    add your field in InventUpd_Estimated class 

  • Vignesh Thirunavukkarasu Profile Picture
    Vignesh Thirunavukk... 277 on at

    Hi Azam,

    could you tell me the right place were i can write my code on that class.

  • Azam Profile Picture
    Azam 385 on at

    I don't know what is your actual scenario , I let you know estimated place you can try.

    InventUpd_Estimated class method updateFieldsChange line No 91

  • Suggested answer
    Joris dG Profile Picture
    Joris dG 17,780 on at

    Please be careful with adding fields to InventTrans. It is a high-volume, highly transacted table. Adding fields there can have a pretty negative performance impact.

    Consider:

    Since InventTrans has a relation to the original journal, do you really need to copy the field over?

    Could you put the value on InventTransOrigin instead?

    Can you put it in a new table with a 1:1 relation to inventtrans?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans