Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 25, 2016 at 03:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded