AR Cash Detail Invoice Date Mismatch

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(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