Version 9 BAQ GL Control, Part Class and Product group

Randy,



Try the EntityGLC table��Contains the list of GL Controls assigned to a
business entity such a Customer record or a PartClass record.�



Regards,
Scott


------------------------------

*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *randyweb
*Sent:* Monday, March 21, 2011 1:34 PM
*To:* vantage@yahoogroups.com
*Subject:* [Vantage] Version 9 BAQ GL Control, Part Class and Product group



I am trying to write a BAQ that will show Part Classes and related GL
Controls as well as Product Groups and related GL Controls such as:

PartClass - GL ControlType - GLControlCode
and

ProdGroup - GL ControlType - GLControlCode

I cannot seem to find the tables that contain the relationships. If you can
paste a query that would be nice.

Thanks in advance,

Randy Weber
Rayotek Scientific


[Non-text portions of this message have been removed]
I am trying to write a BAQ that will show Part Classes and related GL Controls as well as Product Groups and related GL Controls such as:

PartClass - GL ControlType - GLControlCode
and

ProdGroup - GL ControlType - GLControlCode

I cannot seem to find the tables that contain the relationships. If you can paste a query that would be nice.

Thanks in advance,

Randy Weber
Rayotek Scientific