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

Community site session details

Session Id :
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

(0) ShareShare
ReportReport
Posted on by Sangram Shinde 2,114

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

Categories:
Development / Customization / SDK
I have the same question (0)
  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator 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.

  • Sangram Shinde Profile Picture
    Sangram Shinde 2,114 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

  • Muhammad Ahmed Pervaiz Profile Picture
    Muhammad Ahmed Pervaiz 30 on at
    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 

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans