Skip to Content
Former Member
Oct 09, 2009 at 11:55 AM

Query help for Journal - Addtional fileds required


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.