Transaction Journal Report

[former_member224367]

Dear All,

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

Thanks,

Saufil

[Former Member · Accepted solution]

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

[former_member224367 · Accepted solution]

Dear SP Samy,

Thanks for your feedback. I just ran the query but no record display.

Thanks,

Saufil

[Former Member · Accepted solution]

Hi Saufil,

If you remove Where Condition from the above query then it should work.

Or  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
ORDER BY T0.TransId

Thanks,

Rahul

[former_member224367 · Accepted solution]

Hi Rahul,

Yes , correct. Thanks for your help

Thanks

Saufil