BAQ link APInvDtl to TranGLC

[rirish (Ryan Irish)]

Hello,

I’ve been tasked with creating an AP report that displays the GL code associated with AP invoices.

The way Epicor handles the transglc table is something of a nightmare, but I think I have the correct relationships in terms of key1, 2, and 3.

I know I’m supposed to filter on ‘RelatedToFile’, (does anyone know the filter value for APInvDtl?) but I don’t think that matters yet as I’m getting an error when I test.

There are plenty of questions and complaints here related to TranGLC, but I haven’t found anything that helps yet.

[MLamkin (Marjorie Lamkin)]

and

Those linked up automatically when I put TranGLC first, then added APInvDtl, then I just moved it up in the Table List.

[Chad_Smith]

Here’s a at least a good starting place on TranGLC.

KB0028094: Adding GL Account to a BAQ

[Hally (Simon Hall)]

This might be use to stick in your toolbox as well

Efficient Joining Between the TranGLC and PartTran Tables

KB0039633

[rirish (Ryan Irish)]

Thanks for the help.

I figured out that I needed to add the APInvExp table and link TranGLC to that, and then also change the variable type in my table join.

I’m closer now, but I’m still getting two rows returned for each invoice line…one record type ‘A’ and one record type ‘R’. Once I figure out which one to get rid of I might have this solved.

[Hally (Simon Hall)]

A = Account Type
R = Reference Type.

You can normally find this sort of information in either the field help or the data dictionary.