http://in.compucrete.com/index.php?action=history&feed=atom&title=AR_Cash_Detail_Invoice_Date_MismatchAR Cash Detail Invoice Date Mismatch - Revision history2026-05-15T15:41:55ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=AR_Cash_Detail_Invoice_Date_Mismatch&diff=26&oldid=prevWikiAdmin: 1 revision imported2023-07-14T12:58:47Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-25:rev-26 -->
</table>WikiAdminhttp://in.compucrete.com/index.php?title=AR_Cash_Detail_Invoice_Date_Mismatch&diff=25&oldid=prevChanson: 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_..."2022-06-15T15:24:05Z<p>Created page with "<PRE> <span dir="auto"><span class="autocomment">cash detail invoice date mismatches invoice invoice date: </span> select d.invoice_date,i.invoice_date,d.* from artcshdt d inner join artcshhd h on h.session_no=d.session_..."</span></p>
<p><b>New page</b></p><div><PRE><br />
/* cash detail invoice date mismatches invoice invoice date */<br />
select d.invoice_date,i.invoice_date,d.*<br />
from artcshdt d <br />
inner join artcshhd h on h.session_no=d.session_no and h.trans_no=d.trans_no<br />
inner join artinv i on i.session_no=d.ar_session_no and i.trans_no=d.ar_trans_no<br />
where i.invoice_date > :"From Date"<br />
and i.invoice_date<>d.invoice_date<br />
</PRE></div>Chanson