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

Solutions:

QODBC Online can access data from QuickBooks Online using the QuickBooks Online API.

QuickBooks Online API has made some changes to the ARAgingSummary and APAgingSummary report output. 

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

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

Install QODBC Online version 20.0.0.337 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 the below-mentioned link & provide the 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