Solved: [QODBC Online] Column not found - ARAgingSummary and APAgingSummary
Posted by Rajendra Dewani (QODBC Support) on 31 July 2020 12:51 PM

Solved: [QODBC Online] Column not found - ARAgingSummary and APAgingSummary

Problem Description:

Unable to use ARAgingSummary and APAgingSummary

Error - Column not found: Amount_Title, Column not found: Amount_1, Column not found: Amount



QODBC Online is able to access data from QuickBooks Online using the QuickBooks Online API.

It seems there have been some changes to the ARAgingSummary and APAgingSummary report output in QuickBooks Online API. 

We have reported this issue to Intuit. Intuit may fix the issue, and the issue you are facing in the QODBC Online report should get resolved automatically.

If you are on a time-critical project or you urgently need the ARAgingSummary and/or APAgingSummary report output, Please download the latest version of QODBC Online.


Install QODBC Online version or later

Close all the connections to QODBC Online.

Uninstall the current version of QODBC Online. Do not deactivate the QODBC Online license before uninstalling QODBC Online.

Download the latest version of QODBC Online. Click here to download 

Install QODBC Driver for QuickBooks Online.

Skip the CDKEY step during the installation.

Restart Windows (if prompted).

After installing the latest version of QODBC Online, please test ARAgingSummary and APAgingSummary reports using QODBC Online.


If you are still facing the issue, please raise a support ticket to the QODBC Technical Support Department from below-mentioned link & provide requested information:

Submit a Ticket

Please attach the below-listed files:

1) Screenshot of QODBC Setup Screen -- > About

2) Screenshot of the issue you're facing.

Share Entire Log Files as an attachment in text format from

3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages

4) QODBC Setup Screen -- > Messages -- > Review SDK Messages

Refer to: How to take a screenshot: How to take a screenshot


Tags: QuickBooks Online, QBO, Aging Report, Columns Not Found, Column missing, Amount_1 not found, QODBC Online, QO

(0 vote(s))
Not helpful

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