What's new in Customer Journeys?

Connect and learn more! ×
How to Link Purchase Order Invoices back to Project Costs? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Link Purchase Order Invoices back to Project Costs?

Received Response
edited Sep 6, 2018 11:42AM in Reporting and Analytics for ERP 1 comment


Hi All 

We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to bring back Payables invoices pretty easily as they are joined via the original header/distribution/line IDs. However, we are finding it extremely difficult to bring back invoices relating to Purchase Receipts (Oracle Fusion Cost Management). I uncovered the Parent Distribution ID from Projects (pjc_exp_items_all.parent_dist_id) which does seem to link to POs but we are getting varied results (I have tried linking to the po_distribution_id from ap_invoice_distributions_all through a left outer join peia.parent_dist_id = aida.po_distribution_id (+).

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!