CREATE TRIGGER ENPRISE_JOBCOST_CUSTOM_GLCODEFROMITEMGROUP ON ENPRISE_JOBCOST_JOBLINES FOR INSERT
AS
BEGIN
 UPDATE JL
 SET
  SALESGLCODE = OITB.RevenuesAc,
  COSGLCODE = OITB.SaleCostAc
 FROM ENPRISE_JOBCOST_JOBLINES JL
 INNER JOIN inserted I ON I.SEQNO = JL.SEQNO
 INNER JOIN OITM ON I.STOCKCODE=OITM.ItemCode
 LEFT JOIN OITB ON OITM.ItmsGrpCod=OITB.ItmsGrpCod
 WHERE I.LINETYPE <> 'Q'
END