Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / How to update field in...
Finance forum

How to update field in 'ReqPO' table based upon 'ReqTrans' once master planning run is completed

Posted on by 2,015

Hi Techies,

I am working on customization where I have created one custom field on planned orders(Master planning) form. I need to update this value with the 'Number' field in 'Pegging' tab once the master planning run is completed.

Tables involved are 'ReqPO'(Planned orders), ReqTrans+ReqTransCov(Pegging). I tried joining ReqPo and ReqTrans based on relations but I am getting multiple records in query.

I am debugging class 'ReqCalcScheduleItemTable', but facing difficulty to trace the exact code where I can pick and update the value.

Can anyone guide me here.

Any response is appreciated.

Thanks,

Sangram Shinde

  • RE: How to update field in 'ReqPO' table based upon 'ReqTrans' once master planning run is completed

    Hi Sangram, 

    Can you please share the piece of code which you used to update ReqPO based on ReqTrans. I am working on a similar requirement and getting the same problem as you did i.e. multiple records returning when using the relation. It'd be very helpful if you share the code snippet here. 

    Regards,

    Muhammad Ahmed 

  • Reliable Profile Picture
    Reliable 2,015 on at
    RE: How to update field in 'ReqPO' table based upon 'ReqTrans' once master planning run is completed

    Thanks for the reply Nikolaos.

    I wanted the ReqPO to be updated once the record is inserted in ReqTransCov, which got to know after digging in more. whereas code worked fine written on 'OnInserted' and 'OnUpdated' event of 'ReqTransCov' table.

    Thanks,

    Sangram

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: How to update field in 'ReqPO' table based upon 'ReqTrans' once master planning run is completed

    I would use "Find references" on ReqPO.insert method to find where ReqPO is created.

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... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans