AR Cash Detail Invoice Date Mismatch: Difference between revisions
Jump to navigation
Jump to search
(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_...") |
m (1 revision imported) |
(No difference)
| |
Latest revision as of 12:58, 14 July 2023
/* 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