[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 QuickBooksProblem 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. | |
|