Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting: Item not properly linked to an Account Table
Posted by Juliet (QODBC Support) on 01 September 2011 08:46 AM

Troubleshooting: The item is not properly linked to an Account Table

Problem Description

When cross-referencing (join) the Item table to the Account table using the six different account ListID related fields listed here:

http://doc.qodbc.com/qodbc/20/tables/table_relations_us7262.html?trelations_id=109&tn_us=TRUE


In the QuickBooks user interface, some Discount items are assigned to an account, but the data returned by QODBC shows that all 6 Account cross-reference list ID fields are blank.

Solutions

The issue was limited to linking the item table to the account table. This problem has been reported as a bug in QODBC under B00083. It was fixed in QODBC build 280.

You can resolve this issue by upgrading your QODBC if you're using build 279 or lower.

Please update to the latest version of QODBC.

Please click here to download the latest version of QODBC.

If you are still getting the same error after updating the version, then I kindly request you to please raise a support ticket to the QODBC Technical Support department by clicking here

(62 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).