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

SQL Link between AP and Projects ?

Accepted answer
715
Views
3
Comments

Summary:

Report which shows project transaction that have flown through to AP

Content (required):

Hi


Does anyone know the links/joins between AP and Projects, we are trying to build a report however not all transactions are coming through?


Your assistance is appreciated


Thanks

I already reviewed the note

How To Link Projects Transactions To Subledger Accounting (SLA) (Doc ID 1274575.1)

I think the expenditures are mapped to AP invoice distributions and not the header or lines tables. Hence to join between these tables, you may use this sequence:

AP_INVOICES_ALL.invoice_id = AP_INVOICE_DISTRIBUTIONS_ALL.invoice_id

AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id = PJC_EXP_ITEMS_ALL.original_dist_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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