Knowledgebase
[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.

Problem Description:

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 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?

Solution:

I'm sorry to inform you that the Class information in 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.

Refer: How to export QuickBooks data not available in QODBC

You can use of reports such as GeneralLedger, CustomTxnDetail, TxnDetailByAccount, TxnListByDate etc.

For Example:

sp_report GeneralLedger show Blank, TxnType, Date, RefNumber, Name, Class, Memo, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'All'

Refer: How to use the QuickBooks Reporting Engine with QODBC for more details.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).