query report for account with the check no.

[Former Member]

Hi,

I need a report where it should have the posting date,duedate,check no.,row details which is available in JDT1,Debit amt,balance of a g/l account.

I couldn't retrive the check no. for that account..

Kindly help me.

[vijay_kumar1 · Accepted solution]

Dear Jambulingam,

You could use JDT1.Ref3Line to retrieve the check no.

Regards,

Vijay kumar

[former_member187989]

Ref3 is field in journal entry where cheque no is captured.

Jeyakanthan