SQL Script to find missing or deleted Journal No in Microsoft GP

Script
 ------------------------------------------------------------------------- -- Find Missing or deleted Journal Entry No in Microsoft GP -- Code by Venugopal G A -- mail me if you need query for other type of transactions or for any -- queries venuasg@gmail.com ------------------------------------------------------------------------- If Object_Id('tempdb..#tempJV') is Not Null Drop table #tempJV create table #tempJV ( JVno int, MJV int identity(1,1) ) insert into #tempJV (JVno) (select distinct JRNENTRY from GL20000 ) select wg.MJV as id_is_missing from #tempJV wg left join #tempJV ti on wg.MJV = ti.JVno where ti.JVno is null order by wg.MJV