Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by 205

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

  • Verified answer
    Kempeth Profile Picture
    Kempeth 205 on at
    RE: Where's the data coming from in PurchaseOrderConfirmationRequest vs PurchaseOrderConfirmation?

    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.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Where's the data coming from in PurchaseOrderConfirmationRequest vs PurchaseOrderConfirmation?

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

    1) PurchPurchOrderJournalCreate

    2) PurchPurchOrderJournalPost

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans