Problem Description:

I am trying to insert data into the Invoice table, but QODBC is not allowing me to write data into the Invoice table.

20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB in transaction line item(s). QuickBooks error message: A row/shelf bin was expected, but an inventory site was selected. Source: src\InvoiceStorage.cpp line #513 HRESULT=0x80043973

I am trying to query data in the Invoice table, but QODBC does not show any output.

20131209.105426 E 6704 InvoiceStorage::DoQuery Failed to get an Interface ptr: Source: .\src\IteratorHelper.cpp line #360 HRESULT=0x80004005

I am trying to query data in the TimeTracking table, but QODBC does not show any output.

20131201.204256 E 10080 TimeTrackingStorage::DoQuery Failed to get an Interface ptr:  Source: src\TimeActFilter.cpp line #86 HRESULT=0x80004005

20260624.075004 E 20948 SalesOrderStorage::DoQuery Failed to get an Interface ptr:  Source: q:\source\QB\Platform\BizObjectClientAPI\IdnSdk\qbimpl\src\IteratorHelper.cpp line #360 HRESULT=0x80004005

What is the meaning of this error?

Solution

Step 1: Rebuild Your QuickBooks Company File. Data corruption in the company file can often cause these errors. You can fix this by navigating to File > Utilities > Rebuild Data within QuickBooks.

Step 2: Adjust the QODBC Iterator Value. If the rebuild does not resolve the issue, try adjusting how data is batched:

1. Open the QODBC Setup Screen.

2. Go to the Advanced tab.

3. Change the Iterator value to either 250 or 1000, then save and test again.

Next Steps: If the error persists after these adjustments, it indicates a deeper issue within the QuickBooks company file itself. In this case, you will need to contact Intuit Support for a file repair. When you reach out to them, please ensure you have your QuickBooks SDK log files ready to share, as they will need them to diagnose the file damage.

Also, Refer to 

https://intuitpartnerplatform.lc.intuit.com/questions/798632-after-turning-off-advanced-inventory-cannot-write-invoice-via-sdk

https://intuitpartnerplatform.lc.intuit.com/questions/795014-quickbooks-error-message-a-row-shelf-bin-was-expected-but-an-inventory-site-was-selected