Hello! I am looking for assistance with creating a BAQ that pulls the following:
The issue I’m finding is as soon as I add the GLJrnlDtl table for the GL account and apply date it totally brings the query to a crashing halt when I run it. Does anything have a good idea on how to pull this?
Thanks!
How are you linking the GLJrnlDtl ?
Oh gosh I’m going to assume I’m not linking enough fields so it’s looking at too much, but Company and ApInvcNum
I think you want to use TranGLC where RelatedToFile is “APInvHed” and you link on Company, and Key1 is your AP Invoice #.
