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
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
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
I would use "Find references" on ReqPO.insert method to find where ReqPO is created.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156