http://in.compucrete.com/index.php?action=history&feed=atom&title=DataScope%3A_Cash_Posting_Detail_Quick_Fix
DataScope: Cash Posting Detail Quick Fix - Revision history
2026-05-15T16:10:07Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=DataScope:_Cash_Posting_Detail_Quick_Fix&diff=102&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:48Z
<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-101:rev-102 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=DataScope:_Cash_Posting_Detail_Quick_Fix&diff=101&oldid=prev
Chanson: Created page with "This Datascope report makes summing cash posting activity by unique Invoice, or unique Posting. ==Setup== Query: <pre> select cd.*,ch.post_date,ch.check_no, 1 ct,ses.start_d..."
2019-09-12T15:22:25Z
<p>Created page with "This Datascope report makes summing cash posting activity by unique Invoice, or unique Posting. ==Setup== Query: <pre> select cd.*,ch.post_date,ch.check_no, 1 ct,ses.start_d..."</p>
<p><b>New page</b></p><div>This Datascope report makes summing cash posting activity by unique Invoice, or unique Posting.<br />
<br />
==Setup==<br />
Query:<br />
<pre><br />
select cd.*,ch.post_date,ch.check_no, 1 ct,ses.start_datetime,ses.user_id,i.job_po_loc,CD.SESSION_NO||'K'||CD.TRANS_NO CSHKEY,I.SESSION_NO||'K'||I.TRANS_NO INVKEY,CH.CHECK_NO,<br />
cd.credit_amount - (cd.allow_amount + cd. disc_amount) Cash_amount from artcshdt cd<br />
inner join artcshhd ch on ch.session_no=cd.session_no and ch.trans_no=cd.trans_no<br />
inner join artinv i on i.session_no=cd.ar_session_no and i.trans_no = cd.ar_trans_no<br />
inner join cctsessn ses on ses.session_no=cd.session_no<br />
where ch.post_date >= '3/2' AND CH.CUST_NO='AJ1211' AND SES.USER_ID='HIT'<br />
rows 2000<br />
</PRE><br />
<br />
Adjust where clause to the situation. For example it could be...<br />
<CODE>where i.cust_no='9910' and i.invoice_no in (538991,538990,538989)</CODE></div>
Chanson