Expense Detail of a specific project having dedicated bank account

[former_member324969]

We have different project being executed at different locations. Need query for detail expense crystal report for a specific period.

I have following query:

SELECT T2.[AcctName],T2.[Segment_1],T1.[TransID],T1.[BaseRef],T1.[RefDate], T1.[Debit], T1.[Credit],T1.[LineMemo] FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.[TransId] = T1.[TransId] INNER JOIN OACT T2 ON T1.[Account] = T2.[AcctCode] WHERE (T2.[FormatCode] like 'o%' or T2.[FormatCode] like 'a%' )

[vitaly_izmaylov]

The only Date field is T1.[RefDate] , so you can add the Filter to the Qery WHERE clause

or

bring all the data to Crystal reports and filter it in records selection formula using a new parameter based on

T1.[RefDate]