TranGLC

Epicor ERP 10
1

I am trying to design a BAQ that shows all the transactions from the TranGLC (by date range) and shows the user that did that transaction. However, I am having trouble pulling all the tables into one query to list the entry person or changed by person. My question is, what table could be connected to the TranGLC that the other tables could connect off of it. So far to get the user information I have identified the following tables that need to be included in the query.

APInvExp
APInvHead
CashDtl
CashHead
InvcDtl
InvcHead
InvcMisc
LaborDtl
PartTran

I can add one but have ran into problems when trying to add multiple tables.

Thanks.

2

I would join to each table separately in different Union All subqueries. For example, have a TopLevel subquery that contains TranGLC -> APInvExp, a Union All that contains TranGLC -> APInvHead, a Union All with TranGLC -> CashDtl, etc. That way you can filter according to the RelatedToFile in TranGLC and get all the rows you need.

2 Likes
3

Thanks Tyler. Your solution worked great!