BAQ - Default GL Control Codes for Vendors (Not Working!)

Epicor ERP 10
1

Hello all,

I would like to create a query that shows default GL control codes (as set up in Vendor Maintenance) per vendor. I am attempting to link the EntityGL table to Vendor table to acheive this but I’m getting bad results. For example, the following shows control type and code for a specific vendor in Vendor Maintenance:

screen1
screen1.png730×253 5.62 KB

However, when I specify this vendor in my query, I get altogether different results (that appear in yellow for a reason unknown to me):

screen3
screen3.png450×509 9.52 KB

Here is my BAQ design. Any thoughts? Maybe my linkage is problematic? Key 1 is indeed vendor number so I assumed I could JOIN on that.

screen2
screen2.png1097×889 30.5 KB

Thanks,

Alice

2

Hi Alice, Try something like this:

image
image.png837×867 40.5 KB

I’ve also uploaded BAQ you can try:
GLCONQuery.baq (21.6 KB)

1 Like
3

Thank you so much. Query is great. Well on my way…

1 Like
4

Can I somehow link Vendor table in here? I really would like to retrieve one line per vendor and what default GL account number they report to.