Query help for Journal - Addtional fileds required

41 Views

Dear All,

Due to Audit requirement I need a report in which all journal entries which are based into SAP Business One should come and for that I am using the following query :

SELECT T0.[Number], T0.[Memo],T1.[Line_ID], T1.[LineMemo],T1.[ShortName], T2.[ActType], T2.[AcctName],T2.[Levels], T2.[GroupMask], T1.[FCDebit], T1.[FCCredit], T1.[Debit], T1.[Credit], T1.[RefDate], T1.[CreatedBy], T0.[BaseRef] 'Base Reference',T0.[FinncPriod] FROM [dbo].[OJDT]  T0 INNER JOIN [dbo].[JDT1]  T1 ON T0.TransId = T1.TransId INNER JOIN [dbo].[OACT]  T2 ON T1.Account = T2.AcctCode

but the problem is that I am not able to bring some fields such as creator, Type ( which is the origin in the journal screen ) and the series by which it is passed. I know these fields are available in the Transaction Journal Report but when I run this report I am seeing that not all journal entries are shown here. Some journal entries are missing as compared to my report which is generated from the above query. I think in the transaction by Journal report which is available in base product is not showing the Manual Journal entries that are passed by the user.

Please help and advise.

regards,

Depika