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 / Finance | Project Operations, Human Resources, ... / [D365 F&O] Pegging...
Finance | Project Operations, Human Resources, ...
Suggested Answer

[D365 F&O] Pegging at Planned Order

(0) ShareShare
ReportReport
Posted on by Galio 145

Dear experts,

I need to customize a new function as customer's requirement. It's related to Pegging tab at Planned Order screen.

Now, I would like to write the SQL statement for getting all pegging order from the specific planned order number.

Example: As my screenshot, based on PPrd0041245, I want to select all Planned Order Number on Pegging tab.

6758.Pegging.png

I used 2 tables including: ReqTrans and ReqPO for selecting. However, I don't know how to get data as my expectation.

Please helps me writting this SQL.

Thank you in advance.

I have the same question (0)
  • Blue Wang Profile Picture
    Blue Wang on at

    Hi Galio,

    ReqTrans and ReqPO tables have a certain relationship, you can query through them.

    59.PNG

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    when you review pegging, one could could see all planned orders

    where exactly is the gap and what are you trying to achieve with the customization

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 659 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 533 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans