Skip to Content

Transaction Journal Report

Dear All,

Anyone can help me how to display journal number into transaction journal report?

Thanks,

Saufil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 07:12 AM

    Hi,

    That is standard SAP report we can't modify that. So you need to create query report for this.

    You can try this

    SELECT T4.SeriesName, T3.Number, T0.TransId,

    CASE WHEN T1.LocManTran = 'Y' THEN T0.ShortName ELSE T1.[FormatCode] END as 'Account Code',

    CASE WHEN T1.LocManTran = 'Y' THEN T2.CardName ELSE T1.AcctName END as 'Account Name',

    T0.[Debit], T0.[Credit], T3.Memo as 'Remarks'

    FROM JDT1 T0

    INNER JOIN OACT T1 ON T0.Account = T1.AcctCode

    LEFT JOIN OCRD T2 ON T2.CardCode = T0.ShortName

    INNER JOIN OJDT T3 ON T3.TransId = T0.TransId

    INNER JOIN NNM1 T4 ON T4.Series = T3.Series

    WHERE T4.SeriesName LIKE 'MNL%'

    ORDER BY T0.TransId

    Regards,

    SP Samy

    Add comment
    10|10000 characters needed characters exceeded