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

Notifications

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,775 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans