Find Missing / Deleted Journal Entry in Microsoft GP

When your company auditor ask for all the missing or deleted Journal entry, it's not a big task now you can get it in minutes by running the script below in your SQL query analyser.
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

Keep visiting this site for more Dynamics Tips... J