I am looking to get all Journal Entry data for QuickBooks. I am already pulling all Manual Journal Entries with the query below. I could do with some help from an expert on the system.

Our existing MJE data is created using the following example.

SELECT

*

FROM

[qb].[journalentryline] LT
LEFT OUTER JOIN [qb].[account] GL ON GL.[ListID] = LT.[JournalLineAccountRefListID]

WHERE

LT.[IsAdjustment] = 1
AND LT.TXNDATE >= @FROMDATE
AND LT.TXNDATE <= @TODATE

I did originally hope removing the LT.[IsAdjustment] = 1 from the where clause would work, however only manual journal entries are still showing. Can you advise on the correct table to find this info? Or what my query should be changed to?