Skip to Content
avatar image
Former Member

Expense Detail of a specific project having dedicated bank account

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    or

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

    T1.[RefDate]

    Add comment
    10|10000 characters needed characters exceeded