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'
query words: reconcile to GL RM receivables general ledger gp AR