Thanks, for the response!

Actually, I figured this out on my own.

I used a COUNT(*) clause, as follows:

COUNT(*) OVER (PARTITION BY RM20101.CUSTNMBR, RM20201.APTODCNM, RM20201.APTODCDT) as Cnt.

Specifically, I embedded this clause within a cte statement as shown in the code below.

John

DECLARE @AGE DATETIME

DECLARE @RUN DATETIME

SET @AGE = '2015-09-30 00:00:00.000'

SET @RUN = '2016-07-31 00:00:00.000'

;with cte as

(

select RM20101.CUSTNMBR as [CustomerID], RM00101.CUSTNAME as [CustomerName], RM20101.DOCNUMBR as [DocumentNumber],

COUNT(*) OVER (PARTITION BY RM20101.CUSTNMBR, RM20201.APTODCNM, RM20201.APTODCDT) AS Cnt,

CASE WHEN RM20101.RMDTYPAL > 6 and RM20101.DOCDATE < @AGE and RM20201.DATE1 > @AGE

and RM20201.APTODCDT > @AGE AND RM20201.APFRDCDT < @AGE

AND RM20101.DOCNUMBR not in (select RM20201.APFRDCNM from RM20201

INNER JOIN RM20101 ON RM20201.CUSTNMBR = RM20101.CUSTNMBR AND RM20201.APTODCNM = RM20101.DOCNUMBR

and RM20201.APPTOAMT = RM20101.ORTRXAMT

GROUP BY RM20201.APTODCNM, RM20201.APTODCDT, RM20201.APFRDCNM)

AND

RM20101.ORTRXAMT <> RM20101.CURTRXAM

AND RM20201.APFRMAPLYAMT <> RM20101.ORTRXAMT

AND RM20101.DUEDATE <> ''

THEN RM20201.APFRMAPLYAMT * -1 ELSE 0 END

as [OPEN A/R]

from RM20101

INNER JOIN RM00101 on RM20101.CUSTNMBR = RM00101.CUSTNMBR

INNER JOIN RM20201 on RM20101.DOCNUMBR = RM20201.APFRDCNM AND RM20101.CUSTNMBR = RM20201.CUSTNMBR

LEFT OUTER JOIN CN00500 ON RM20101.CUSTNMBR = CN00500.CUSTNMBR

WHERE (RM20101.VOIDSTTS = 0) and (RM20101.CUSTNMBR IN ('266267', '0100012160'))

GROUP BY RM20101.CUSTNMBR, RM00101.CUSTNAME, RM00101.PYMTRMID, CN00500.CRDTMGR, RM00101.COMMENT1, RM00101.COMMENT2,

RM20101.RMDTYPAL, RM20101.DUEDATE, RM20201.APFRMAPLYAMT, RM20101.DOCNUMBR, RM20201.APFRDCNM, RM20101.DOCDATE,

RM20201.DATE1, RM20201.APTODCDT, RM20201.APPTOAMT, RM20201.APTODCNM, RM20201.APFRDCDT, RM20101.ORTRXAMT, RM20101.CURTRXAM

HAVING

CASE WHEN RM20101.RMDTYPAL > 6 and RM20101.DOCDATE < @AGE and RM20201.DATE1 > @AGE

and RM20201.APTODCDT > @AGE AND RM20201.APFRDCDT < @AGE

AND RM20101.DOCNUMBR not in (select RM20201.APFRDCNM from RM20201

INNER JOIN RM20101 ON RM20201.CUSTNMBR = RM20101.CUSTNMBR AND RM20201.APTODCNM = RM20101.DOCNUMBR

and RM20201.APPTOAMT = RM20101.ORTRXAMT

GROUP BY RM20201.APTODCNM, RM20201.APTODCDT, RM20201.APFRDCNM)

and

RM20101.ORTRXAMT <> RM20101.CURTRXAM

AND RM20201.APFRMAPLYAMT <> RM20101.ORTRXAMT and RM20201.APPTOAMT <> RM20101.ORTRXAMT

AND RM20101.DUEDATE <> '' AND RM20101.DOCNUMBR = RM20201.APFRDCNM

THEN RM20201.APFRMAPLYAMT * -1 ELSE 0 END

<> 0)

select * from cte where Cnt > 1;