What table joins required to link PO Receipts to GL lines in Data Model?
Summary
Need to Extract GL lines with PO Receipt details, PO Number with Data ModelContent
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.
Tagged:
0