I’m trying to connect both InvcDtl & InvcMisc to TranGLC. If I do this in a single top level query, I get duplicate lines whenever an invoice has both detail lines & misc. charges. So I figure the best way to get this done is to have a top level query and an Inner Sub Query. But I don’t know how to…

Not sure if I can help, but can you show the link you are using with TranGLC? In general linking the GL tables is a giant headache to be avoided if possible. What do you need the TranGLC table for?

You have to filter on the RelatedToFile [image] TranGLC Key Map ERP 10 For the record, here is also the E9 Version from DotNetIT. Still some relevance. Thanks for Excel Molly! ^

InvcDtl & InvcMisc to TranGLC BAQ

Epicor ERP 10

hkeric.wci (Haso Keric) March 14, 2019, 11:51pm 3

You have to filter on the RelatedToFile

Topic		Replies	Views
TranGLC Epicor ERP 10 baq	2	1802	July 31, 2019
BAQ Table Links Epicor ERP 9	6	3083	May 24, 2018
BAQ (simple?) Linking GLJrnDtl to InvoiceDtl Epicor ERP 10	4	4320	October 8, 2019
BAQ Help with TranGLC & RCVDTL Table Epicor ERP 10 baq , tranglc	6	2160	December 9, 2022
How to Link TranGLC to GlJrnDtlMnl Epicor ERP 10	7	5485	July 10, 2019

InvcDtl & InvcMisc to TranGLC BAQ

Related topics