Invoice data from a Journal for a report

Epicor ERP 10
, , ,
1

Hi,

Is there a cross-reference database table that would be best to use so I can quickly write a BAQ to pull related AP Invoice from a corresponding journal?

The delivered GL report shows an Account, Description, Journal, Seq and Line. But I need to tie that to AP invoice data.

Appreciate your help in advance!!

Thanks
Pete

2

TranGLC. Table Criteria on:

  • RelatedToFile IN APInvDtl, APInvExp, APInvHed, APInvMsc
    (maybe other APInv___ tables - if you use them)
  • JournalCode, JournalNum, and JournalLine

Key1 will be VendorNum, Key2 is InvcNum

3

Thank you Calvin