AR Cash Detail Invoice Date Mismatch

From KeystoneIntranet
Revision as of 15:24, 15 June 2022 by Chanson (talk | contribs) (Created page with "<PRE> →‎cash detail invoice date mismatches invoice invoice date: select d.invoice_date,i.invoice_date,d.* from artcshdt d inner join artcshhd h on h.session_no=d.session_...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
/* cash detail invoice date mismatches invoice invoice date */
select d.invoice_date,i.invoice_date,d.*
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 > :"From Date"
and i.invoice_date<>d.invoice_date