How to Link TranGLC to GlJrnDtlMnl?
I linked key1-6 to GroupID, BookID, FiscalYear, JournalCode, JournalNum and JournalLine, and related file to GlJrnDtlMnl, but returns no results.
How should I modify the joins.
Thanks
I would also like to know the answer to this question. In general, it doesn’t seem like linking tables to TranGLC is as straight forward as it should be.
What is the difference between GLJrnDtl and GLJrnDtlMnl?
Have you run TranGLC without a join for Keys1-6 to see what’s in those fields?
I’m fairly certain it’s not GroupID, BookID, FiscalYear, JournalCode, JournalNum and JournalLine.
I know for certain that BookID, FiscalYear, JournalCode, JournalNum and JournalLine all have their own fields that are not the keys. Try joining to those.
I don’t believe we have any common records between those two tables to link. Not to say you don’t, but I think only our general journal entries go through GLJrnDtlMnl and transactions go through TranGLC. Both end up in GLJrnDtl.
If you are trying to join TranGLC to GLJrnDtl instead, then you wouldn’t join on the key1-5 fields, those generally are used to join to the related table that the transaction originated from. For example, when you filter TranGLC for just the Inventory Journal, one of those keys is the TranNum from PartTran. The same field is a different key for a different table when the context of the entry is different.
As for linking TranGLC to GLJrnDtl, I think all you need is the following:
Company
JournalCode
FiscalYear
JournalNum
JournalLine
You have to be really careful with what you are using the BAQ for though since it is not a 1 to 1 relationship and Epicor with aggregate multiple rows from TranGLC when they post to GLJrnDtl. So if you write your BAQ in a way that duplicates records on GLJrnDtl for every record on TranGLC but use the amount from GLJrnDtl it won’t tie to your GL…
Keys 1 to 6 are to link to tables APInvExp, APInvHed, APInvTax, APTran, CashDtl, CashHead, CheckHed, InvcDtl, InvcHead, InvcMisc, InvcTax, LaborDtl, PartTran, PORel, TaxDtl etc, use the other fields in TranGLC to link to GLJrnDtl, ie as Mike has stated.
What is the difference between GLJrnDtl and GLJrnDtlMnl???
I have never used GLJrnDtlMnl before, why do you think you need to?
For us we have 8.5million records in GLJrnDtl and 30k in GLJrnDtlMnl.
Very late answer (because I was looking for a different issue), but GLJrnDtl is journals that come from the System (Posting of PartTran, APTran, etc). GLJrnDtlMnl are Manual Journal Entries.
1 Like