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

I have the same question (0)
  • Sohaib Cheema Profile Picture
    49,147 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

  • Verified answer
    Kempeth Profile Picture
    211 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.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Aayyon Das Profile Picture

Aayyon Das 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans