AR DIAG: Payments in Prior Period than Invoice Date

select i.cust_no,i.invoice_no,h.post_date,i.invoice_date,d.invoice_date "CshDetInvDt",d.credit_amount
from artcshdt d 
inner join artcshhd h on h.session_no=d.session_no and h.trans_no=d.trans_no
inner join artinv i on i.session_no=d.ar_session_no and i.trans_no=d.ar_trans_no
where i.invoice_date>:cross_date
and h.post_date<=:cross_date
order by cust_no,invoice_date,post_date