[QODBC-Desktop] Troubleshooting: Could not Find Data in ItemSites Table QuickBooks
Posted by Wilson (QODBC Support) on 10 February 2012 06:57 AM
Item Sites table contains no data
Troubleshooting: Could not Find Data in ItemSites Table QuickBooks
When referring to Intuit SDK OSR, a subject named Item Site can be found. It stores the quantities for each item by sites. But I could not find any data in this table in QuickBooks.
First, to use Item Sites table, you must enable multiple inventory sites feature in QuickBooks. You could turn on this feature via the following steps:
1 Choose Edit > Preferences .
2 Choose Items & Inventory.
3 Click the Company Preferences tab.
4 Click the Advanced Inventory Settings button.
5 Select the Multiple Inventory Sites is enabled checkbox.
And you could add inventory sites via the following steps:
1 Choose Lists > Inventory Site List.
2 Click the Site button at the bottom of the Site List and select New.
3 Enter the appropriate information.
Now you could view the newly added information in the InventorySites table using QODBC.
ATTENTION: if you are using QuickBooks Premier Edition, all tables related to multiple inventory sites will NOT be available. Because this feature is not included in this Edition.