on 05-08-2014 11:29 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.