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 link.
One more post here
1 Like
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 report can be used to see the details of a specific PPP lines.
E10 requires linking to the TranGLC table to match PPP GL entries, to actual transactions (Part, Invoice, etc…)
1 Like
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 the columns called Key1 through Key6
If I remember correctly for RelatedToFile InvoiceDtl, Key1 is Invoice Num and Key2 is InvoiceLine.
Hope this helps!
2 Likes