Journal Report

[Former Member]

Hi Experts,

I need a ledger report which should contain Date,Account code, Account Name, or particulars (like invoice or receipt),Voucher no, Debit , credit......i Have seen the GL report but we want to do it in crystal and my customers wants in his own format... can any body help in giving this query....

regards,

Vignesh

[Former Member]

Hi Vignesh.......

Please try this.....

SELECT T0.[RefDate], T1.[Account], T1.[ShortName], T0.[Memo], T0.[BatchNum], T0.[TransId], T1.[Credit], T1.[Debit] FROM OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId

Regards,

Rahul