[QODBC-Desktop] Troubleshooting - How would I produce a transaction list that includes the class field.
Posted by Jack - QODBC Support on 19 January 2018 09:03 AM
Troubleshooting - How would I produce a transaction list that includes the class field?
I am working on the transactions table but do not see a "class" field. How would I produce a transaction list that includes the class field?
For example, I can run a GL report in QBE 18 that includes the class field and wish to do the same with transactions.
What tables have the class field?
Could you please point me in the right direction to where I can query this information using QODBC?
I'm sorry to inform you that the Class information in the Transaction table is not available through the Intuit SDK, so they are not available through QODBC.
QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.
You can use reports such as GeneralLedger, CustomTxnDetail, TxnDetailByAccount, TxnListByDate, etc.
sp_report GeneralLedger shows Blank, TxnType, Date, RefNumber, Name, Class, Memo, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'All.'
Refer: To how to use the QuickBooks Reporting Engine with QODBC for more details.