Skip to Content
avatar image
Former Member

how i can create query , that will show credit and debits in system currency of Account balance?

I want to create a query in query manager that will show my a/c balance credit and debits in system currency

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 02, 2017 at 12:19 PM

    Try accessing OJDT and JDT1 table for the field SYSCODE you need to link the query with OACT table.

    Hope this helps

    Add comment
    10|10000 characters needed characters exceeded