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

What table joins required to link PO Receipts to GL lines in Data Model?

edited Apr 12, 2018 9:20PM in Reporting and Analytics for ERP 2 comments

Summary

Need to Extract GL lines with PO Receipt details, PO Number with Data Model

Content

Hello,

We are trying to create a custom GL Report that will show subledger details for GL lines posted from either the AP or Procurement subledgers.  We have developed a query that returns the AP Invoice details for the GL lines posted from AP, however we have been unable to determine what tables and joins are required to link a GL line that came from a PO Receipt.  We would like to provide the PO number for that receipt as part of the GL report.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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