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

Problem Description:

I am trying to export data from QXL. I have selected ItemAssembliesCanBuild & other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the 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.

You will get this error when you execute a query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate.

So it would be best to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through a custom query. 

You need to write the table name in the Custom Table Name box & write the query in the Custom Query box. After writing the table name & query, click on the "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 the query, Please try to export again. You will not get the error.