Item Sites table contains no data

Troubleshooting: Could not Find Data in ItemSites Table QuickBooks

Problem Description:

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.

Solution:

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.