Query to retrieve PO receipt information with GL account

Epicor ERP 10
1

Hi,

I am trying to build a SQL query to retrieve the PO receipt information with GL account it hit. The “Inventory/WIP Reconciliation” report has most of what I need but it lacks the vendor number, PO number and line description and some filtering options. So I am looking for the SQL tables that are behind this report. I can get the PO detail information (POHeader, PODetail & PORel) and the GL information (GLJrnDtl) but cannot make the link between the 2.

Thank you,

Daniel

2

Hi Daniel
Did you have any luck with getting this link?

1 Like
3

You will need the TranGLC table. Use keys 1-3 to link the PO tables.

image

1 Like
4

So crazy, I was just searching the forum for the same thing yesterday!