Edit

RM SQL scripts to locate RM transactions that are not in GL in Microsoft Dynamics GP

  • Article
  • 2 minutes to read

This article provides RM SQL scripts to locate RM transactions that are not in GL (work, open, or history) in Microsoft Dynamics GP.

Applies to:   Microsoft Dynamics GP
Original KB number:   4229852

You can use the scripts below to locate transactions that are in the RM side (open and history) but not in the GL (work, open, or history). Any results returned, you will need to review those on your own.

select * from RM20101
where DOCNUMBR not in
(select ORCTRNUM from GL30000 where SERIES=3)
and DOCNUMBR not in
(select ORCTRNUM from GL20000 where SERIES=3)
and DOCNUMBR not in
(select a.ORCTRNUM from GL10001 a
inner join GL10000 b on a.JRNENTRY=b.JRNENTRY
where b.SERIES=3)
and VOIDSTTS=0 and POSTDATE<> '1900-01-01 00:00:00.000'

select * from RM30101
where DOCNUMBR not in 
(select ORCTRNUM from GL30000 where SERIES=3)
and DOCNUMBR not in
(select ORCTRNUM from GL20000 where SERIES=3)
and DOCNUMBR not in 
(select a.ORCTRNUM from GL10001 a
inner join GL10000 b on a.JRNENTRY=b.JRNENTRY
where b.SERIES=3)
and VOIDSTTS=0 and POSTDATE <> '1900-01-01 00:00:00.000'