AR Cash Detail Invoice Date Mismatch
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