cancel
Showing results for 
Search instead for 
Did you mean: 

Need General Ledger Report (CR Format)

saad_omair
Explorer
0 Kudos

Dear Members, Can anyone help me regarding the subjected matter,

i need General Ledger, Party Ledger or Account Ledger with Remarks or Narration

with Document References.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Saad Omair,

You have to create SQL query using OJDT and JDT1 table to get the desired field data and arrange it properly in Crystal Report.

Regards,

Rahul

saad_omair
Explorer
0 Kudos

i have already done that Rahul, but struggling to get the remarks field, check this out for the reference;

DECLARE @D1 DATETIME

DECLARE @D2 DATETIME

SET @D1=  '2013-11-01 00:00:00.000'

SET @D2=  '2014-06-01 00:00:00.000'

select T0.RefDate as  'Posting Date' ,T0.DueDate ,T0.TaxDate as 'Document Date',T0.BaseRef  as 'Doc.No.' ,

T0.TransId as 'Trans.No.' ,T0.Memo as 'Remarks' , T1.[ContraAct] 'OffsetAcct',

Account=(CASE WHEN T2.AcctName IS NULL THEN  t3.cardname else T2.AcctName end ),

T1.Debit, T1.Credit

from OJDT T0

inner join JDT1 T1 on T0.TransId =T1.TransId

left outer Join OACT T2 ON T2.AcctCode=T1.ContraAct

left outer join OCRD t3 on t3.CardCode=T1.ContraAct

Where T0.RefDate>=@d1 and T0.RefDate<=@d2

and (t1.ShortName='SU000147')

and (T1.Debit - t1.Credit) <> 0

--For Inner Account ---

--and (T2.AcctName='ADVANCE TO SUPPLIER')

order by [Posting Date],T0.BaseRef

Former Member
0 Kudos

Hi,

It works perfect as an output and displaying remarks field too. But which additional remark field you are talking about?

You can display line level remark field as well which is T1.LineMemo in your case.

If you have any UDF for special remarks you can display that too.

Regards,

Rahul

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

I am also getting remarks field.

Please advice your exact field to include in above query.


Thanks & Regards,

Nagarajan