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…

InvcDtl & InvcMisc to TranGLC BAQ

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

You have to filter on the RelatedToFile

Topic		Replies	Views
Linking in the GL account from PO Tracker > Rel > Detail Epicor ERP 10 baq	1	533	October 20, 2023
Joining GLJrnDtl and GLJrnDtlMnl Epicor ERP 10 e10 , sql , baq , gl-journal	0	1107	March 16, 2023
Table links Epicor ERP 10 customization	9	525	October 24, 2023
Link Supplier to EntityGLC (Key Cheat Sheet) Epicor ERP 10	5	1745	June 30, 2017
Link GL control from TranGLC Epicor ERP 10 e10	4	1250	June 22, 2020