cancel
Showing results for 
Search instead for 
Did you mean: 

Bank Reconciliation Report on Crystal Report

0 Kudos
513

Hello.

What Parameter Names do i have to pass for the Previewing Previous External Reconciliations on Crystal Report.

Thanks

View Entire Topic
0 Kudos
SELECT 
T0.MthAcctCod
,T0.MatchNum
,T0.Totals
,T0.MatchDate
,T1.TransId
,t1.DueDate
,T1.[Account]
,T1.[Debit]
,T1.[Credit]
,T1.[IntrnMatch]
,T1.[ExtrMatch]
,T1.Ref1
,T1.[LineMemo]
,T2.DueDate
,T2.DebAmount
,T2.CredAmnt
,T2.Sequence
FROM OMTH T0
INNER JOIN JDT1 T1 ON T0.MatchNum = T1.[ExtrMatch]
inner join OBNK T2 ON T2.BankMatch = T0.MatchNum
where 
T0.MatchNum = [%0]
--and 
--T0.MthAcctCod = '1.01.01.02.01'
--AND T1.[Account] = '1.01.01.02.01'
--AND T2.AcctCode = '1.01.01.02.01'
order by T0.MatchNum , t1.TransId
0 Kudos

Need the Parameters Names for Crystal Report.