QODBC only supports the DEFAULT shipping address in USA editions of QuickBooks 2006. While USA users of QuickBooks 2006 can enter multiple addresses and set which address (Ship To 1, Ship To 2, Ship To 3 etc) is the DEFAULT shipping address, QODBC will only show the DEFAULT shipping address in the Customer table.
In this example I set the DEFAULT shipping address to Ship To 2 :
So when I run the following query:
SELECT "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressAddr3", "ShipAddressAddr4", "ShipAddressCity", "ShipAddressState", "ShipAddressPostalCode", "ShipAddressCountry" FROM Customer where "FullName" = 'Data Access Worldwide'
I now see the Ship To 2 shipping address:
|