chart of accounts query

[Former Member]

Hi Gurus,

Help me get a query that shows line by line transactions of all transaction in 2016.

If its asset level would like to see all the transaction line by line etc

if in chart of accounts assets account A has usd 20000

i need to see what comprises that line by line if its an invoice i see the content of the invoice

[markus_schaefer242]

Hi,
you need to create a query about the journal-entries from financial-Module.

Select * from OJDT T0
inner JOIN JDT1 T1 on T0.[TransId] = T1.[TransId]

The Accounts and values are:
T1.Accounts, T1.Shortname, T1.Debit, T1.Credit, T1.LineMemo, T1.Transtype, T1.Ref1

Ref1 = Docnum from OINV, ORIN....

I hope, that helps.
Greetings

Markus