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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Where's the data coming from in PurchaseOrderConfirmationRequest vs PurchaseOrderConfirmation?

(0) ShareShare
ReportReport
Posted on by 211

I need to change the report shown when the user creates a Purchase inquiry (Procurement and sourcing > Purchase orders > "Purchase" tab > "Generate" group)

From what I've been able to piece together it's the same report as for a Purchase order confirmation, just with a lot less information:

PurchaseConf-vs-PurchaseConfReq.png

The report pulls it's data from four "tables" in the PurchPurchaseOrderDP class but I can't figure how the data gets there and why there is so much less data in one case vs the other. I've used and created Data Provider based reports before. But this one invokes some FormLetter magic. I've stepped to pretty much the whole code and couldn't find anything that looks like a select statement or query run...

*This post is locked for comments

  • Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 2 on at

    data is coming to these tables via two classes named as following

    1) PurchPurchOrderJournalCreate

    2) PurchPurchOrderJournalPost

  • Verified answer
    Kempeth Profile Picture
    211 on at

    I've eventually figured out that the difference in data comes from the fact that the VendPurchOrderJour table had an event handler attached to the insert() and initFromPurchTable() methods which filled in all these customized fields. The PurchConfirmationRequestJour table did not and so the fields remained empty.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Prashant Singh Profile Picture

Prashant Singh 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans