Skip to Content

Expense Detail of a specific project having dedicated bank account

Dec 22, 2016 at 10:40 AM


avatar image
Former Member

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%' )

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Dec 22, 2016 at 04:45 PM

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


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


10 |10000 characters needed characters left characters exceeded