select *  from gltransaction
where journaltypecode = 'BILL' and documentno not in (select billcode from bill)