Has anyone attempted to pull a report/data table using excel/ODBC driver to get inventory by bin location similar to the report in QB Enterprise?
Example: The "inventory by bin location" report in quickbooks is a great report. However, it's not easily customizable, and even more so, in excel when you export the report. So, i am trying to pull this data into excel using the ODBC and microsoft query. However, I can't seem to find a table or multiple tables to use when performing the query. I.E. the "itemsite" table doesn't actually provide quantity on hand at all. the "itemInventory" table pulls in company-wide quantity on hand. We have multiple locations, and any inventory part might be in multiple bins/locations within that geographical location.
So, is it possible to create a report or data table using this method to have matching data? I.e. i want my table to show the exact same quantity on hand for a given bin/location as quickbooks shows me in it's internal reporting.
any and all help is greatly appreciated