Knowledgebase
[QXL-Desktop] Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found.
Posted by Jack - QODBC Support on 06 April 2017 12:57 PM

Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found.

Problem Description:

I am trying export data from QXL. I have selected ItemAssembliesCanBuild & other tables from "Table Setting" tab. After that, I click on QXL export button I got below error message after export.

ERROR [00000] [QODBC] Error: 3120 - Object "X" specified in the request cannot be found. 

Solution:

ItemAssembliesCanBuild Query does require ItemInventoryAssemblyRef(ListID or FullName) and TxnDate in the WHERE Clause to perform the query in QuickBooks SDK.

When you execute query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate, then you will get this error.

So you need to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through custom query. 

You need to write table name in Custom Table Name box & write the query in Custom Query box. After writing table name & query click on "Add or Update" button to add the query.

For Example:
SELECT * FROM ItemAssembliesCanBuild where ItemInventoryAssemblyRefFullName='assembly item' and TxnDate={d'2018-01-01'}

After adding query, Please try to export again. You will not get the error.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).