How do the GLJrnDtl and GLJrnHed tables link to the invoice and the order? I’m trying to create a BAQ and wondering how the tables are linked.

This isn’t exactly what you’re looking for, but I created a finance report for the first time recently and this forum post helped me get on the right path. If I get a chance later though, I’ll try to look more into how to utilize invoices/order and not the part transactions like they focus on in my …

One more post here [image] BAQ (simple?) Linking GLJrnDtl to InvoiceDtl ERP 10 Problem: I need all the detail information for everything that has been invoiced. Example: I need all of the Part Numbers & Descriptions that ha…

I wasn’t aware there was a separate Epicor forum? Who has access to this forum and is it still running?

I’m not sure actually, Google just lead me to this particular post from the forum. It looks like the most recent posts are from last year though, so I’m assuming it isn’t used much at all anymore.

One thing that took me a while to fully grasp, was that Epicor doesn’t create GLDetails for each transaction. When you run the Capture COS process, it summarizes all the transactions, and posts the summary. That is what “Periodic Posting Process” (PPP) lines are in GL reports. The WIP Recon repor…

TranGLC should be the way you go. There is a field called RelatedToFile and depending on this is what information will be pulled from the table. i.e. ParTran will have inventory transactions, LaborDtl will have labor detail, and InvoiceDtl will have Invoice details. The other part to figure out are …

BAQ Table Links

Epicor ERP 9

danbedwards (Dan Edwards) May 24, 2018, 3:14pm 3

One more post here

Topic		Replies	Views
BAQ (simple?) Linking GLJrnDtl to InvoiceDtl Epicor ERP 10	4	4299	October 8, 2019
G/L Tables for BAQ Epicor ERP 10	0	1808	November 30, 2017
Gl baq Epicor ERP 10 e10	18	7499	March 2, 2023
Understanding the GL Account Table Epicor ERP 10 gl-journal	3	3686	February 14, 2023
How to Link TranGLC to GlJrnDtlMnl Epicor ERP 10	7	5445	July 10, 2019

BAQ Table Links

Related topics