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

(0) Share

Report

Posted on by Kempeth

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:

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

All responses (2)

Answers (1)

Verified answer

Kempeth 205 on at

Like (0)

Report

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 46,610 User Group Leader on at

Like (0)

Report

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