I am attempting to create an on-time delivery BAQ for our suppliers that would also help with the budget aspects by showing our spend per month. I see on the PO that the GL Account number is present on the PO Release tab but every time I attempt to add it to my BAQ, I get dozens of lines that are not that number. It seems to return every GL account number and create a separate line on my BAQ. Has anyone been able to successful add that field to their BAQs?
Steve
So I assume you have brought in the TransGLC Table. This is a tricky one to link, but in this case, you would look for the following in the link:
RelatedToFile “PORel”
Key1 PO Number
Key2 PO Line Number
Key3 PO Release Number
Then you should see your segment values and GL Account for that release.
Jim
Jim, i’m looking for a BAQ to list all transactions in a given set of GL accounts. any clues on how to?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.