how to jet all journal entries which is originaly pass with journal voucher only

[Former Member]

I want to run query which give me journal entries only i.e. journal entry i pass by using journal vouchers only and not other forms like ap invoice or outgoing form.

[jitin_chawla]

Hi,

You need to check the "BatchNum" field in the OJDT and the JDT1 table. The "batchnum" field contains the Journal Voucher Number.

Regards,

Jitin