Does anyone have the query to get the related GLC Control Code for each Product Group?
So far I have this, does anyone know of a better way? Does this look about right?
SELECT e.Company, e.BusinessEntity, e.Key1, g.GLControlCode, g.Description
FROM EpicorLive10.Erp.GLCntrl AS g INNER JOIN
EpicorLive10.Erp.EntityGLC AS e ON g.Company = e.Company AND g.GLControlCode = e.GLControlCode AND e.BusinessEntity = ‘ProdGrup’
WHERE (g.GLControlType = ‘Product Group’)