DataScope: Cash Posting Detail Quick Fix

This Datascope report makes summing cash posting activity by unique Invoice, or unique Posting.

Setup

Query:

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,
cd.credit_amount - (cd.allow_amount + cd. disc_amount) Cash_amount from artcshdt cd
inner join artcshhd ch on ch.session_no=cd.session_no and ch.trans_no=cd.trans_no
inner join artinv i on i.session_no=cd.ar_session_no and i.trans_no = cd.ar_trans_no
inner join cctsessn ses on ses.session_no=cd.session_no
where ch.post_date >= '3/2'  AND CH.CUST_NO='AJ1211' AND SES.USER_ID='HIT'
rows 2000

Adjust where clause to the situation. For example it could be... where i.cust_no='9910' and i.invoice_no in (538991,538990,538989)