Epicor 9.05.702 Tie GLAccount to AP invoice line

Yahoo Archive
1
Thank you! Sorry I didn't get back to you sooner but had other fires to fight. I'm sure this will get me a long way in writing this BAQ. Again thanks.
Terry
2
I'm trying to write a BAQ to tie a GLAccount to AP invoice line. I can't seem to find the tables put together to get me from an AP invoice line to a GLAcoount. So I can write a report of what items when into which GL Accounts for each period. Your help would be appreciated.
3
Â
Hi,
Link APInvDtl to APInvExp to TranGlc to get gl account information. Then link TranGlc to GLJrndtl to get period information.
Â
TranGlc.Company = APInvExp.Company and TranGlc.Key1 = APInvExp.VendorNum and
 TranGlc.Key2 = APInvExp.InvoiceNum and TranGlc.Key3 = APInvExp.InvoiceLine and TranGLc.Key4 = APInvExp.Seq. Criteria is TranGLc.RelatedTofile = 'APInvExp'.
Â
Regards,
Arul
Â
Â


________________________________
From: Terry <guanella2003@...>
To: vantage@yahoogroups.com
Sent: Thursday, 11 July 2013 6:58 AM
Subject: [Vantage] Epicor 9.05.702 Tie GLAccount to AP invoice line


Â

I'm trying to write a BAQ to tie a GLAccount to AP invoice line. I can't seem to find the tables put together to get me from an AP invoice line to a GLAcoount. So I can write a report of what items when into which GL Accounts for each period. Your help would be appreciated.




[Non-text portions of this message have been removed]