Good afternoon… Let me preface this question by pointing out: I am a software engineer, NOT an accountant. Boss comes to me and says: I want a HTML view into the GL. Backstory here: I have built out a very comprehensive web interface for various BI aspects of our Epicor system. The idea behind…

I believe GLJrnHed only exists for manual journal entries created and posted by a user. By and large, the “automatic” journal entries (AP Invoices, Payments, AR Invoices, Cash Receipts, Bank Adjustments, Inventory/WIP transactions, etc…) will only have GLJrnDtl records for those movements. Those GLJ…

Soooo…, I need to join - not only on JournalNum - but also FiscalYear AND JournalCode? Talking about joining DTL and HED tables here… Also… I see the TranGLC table. What would the join criteria be to link this with GLJrnDtl? I am assuming: JournalNum, JournalLine and FiscalYear?

This thread and others referencing transglc go over the joins. [image] Inventory Posting Epicor ERP 10 If you must make a query: [image] Also, check out this:

Understanding the GL Account Table

Epicor ERP 10

gpayne (Greg Payne) February 14, 2023, 9:36pm 4

This thread and others referencing transglc go over the joins.

Topic		Replies	Views
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
GLJrnDtl, TranGLC - who created the record? Epicor ERP 10 gl , gl-transaction	19	3266	June 28, 2023
How to Link TranGLC to GlJrnDtlMnl Epicor ERP 10	7	5485	July 10, 2019
Journal Listing Query Epicor ERP 9	4	5020	April 10, 2018

Understanding the GL Account Table

Related topics