GL Debit Movement and Credit Movement

Dear Freinds
I need to find individual transaction for GL/PL movement ledger.For debit movement and credit movement I need to find individual transaction whose sum is this total debit movement and credit movement in GL line. Any one can help regarding the matter.

Regards
Monir

You need to select from xxxxENT.LWORK.DAY files based on the keys formimg the particular line.
I hope you understand the various files within CRF

Thanks Shibumi. Please tell me in detail. I have given in jshell like SELECT FBNK.ENT.LWORK.DAY. but its not working.
Waiting for your reply.

hi its ACCT.ENT.LWORK.DAY after that my suggestion is better to compare in stmt.entry also

monirku wrote: wrote:

Thanks Shibumi. Please tell me in detail. I have given in jshell like SELECT FBNK.ENT.LWORK.DAY. but its not working.
Waiting for your reply.

Since you need the GL And PL movement, you can select CAL and CPL and loop thru the keys looking for DR or CR movement fields. For CAL, make sure to select LOCAL.MOVEMENT when the currency is FCY. Also, take not of the ASSET.TYPE.