Troubleshooting - Trying to update the ItemInventoryAssemblyLine table
All our products are Inventory Assemblies. I am using MS Access connected to QuickBooks via QODBC. I am using queries in MS Access to loading/synchronize Inventory data from my master inventory list, which is kept outside of QuickBooks, to make sure QB has the latest inventory data.
I have successfully inserted ItemInventoryAssemblyLine entries, but now I'm trying to update the Quantity information on parts for existing assemblies.
To do the update, I need to join a local table I've created from the external inventory data, which I've loaded with the ListID, ItemInventoryAssemblyLnItemInventoryRefListID, and FQPrimaryKey values from ItemInventoryAssemblyLine, in order to facilitate joins.
Here's my SQL (from MS Access Query Designer):
UPDATE ItemInventoryAssemblyLine INNER JOIN Assemblies_with_PK ON ItemInventoryAssemblyLine.FQPrimaryKey = Assemblies_with_PK.FQPrimaryKey SET ItemInventoryAssemblyLine.ItemInventoryAssemblyLnQuantity = [Qty];
"Qty" is a column in the local table with the updated Quantity that I'd like to edit into the QuickBooks table.
When I run this query, I get the dreaded "Error parsing complete XML return string." error. I have tried alternatively joining on the combination of ListID and ItemInventoryAssemblyLnItemInventoryRefListID instead of FQPrimaryKey with the same result.
I have updated Custom Fields in the parent ItemInventoryAssembly table using the same approach with no problems.
Any help with this would be greatly appreciated!
Please update your QODBC to the latest QODBC version and test again.
Please click here to get the latest QODBC version.
If you are still getting the same error after updating the version, I kindly request you to please raise a support ticket to the QODBC Technical Support department by clicking here.