I have used this 3rd party activex control for QB QBXML integration:
http://www.nsoftware.com/ibiz/quickbooks/default.aspxBut its been a start/stop effort so far, although i do like the control so far. Its pretty slick to watch the data appear in your QB session as you push data from VFP. The biggest issue i've found is adding/updating QB in the right sequence, so that the validations are met. That means populating the QB data (ITEMS, CLASSES, COA CODES, CUSTOMER:JOBS, VENDORS) in the correct order and validating the existance of this data before creating/updating STATEMENTS and INVOICES and applying payments.
I was hoping to replicate what i do when updating MSOutlook from fox and that is to store a PK value on an Outlook contact record (in a rarely used field) and simply search for that value in order to determine if an add or an update is needed. But have not found a a means of doing the same w/ QB. The version of the control i have does not support the creation of or the searching of user-defined QB fields (that may have changed though).
>Are there anyone in here that have "integrated" with QuickBooks in their application?
>I am starting to look into exporting to QuickBooks and I am curretly gathering information and trying to get the "big picture" overview.
>Any links, book references or comments (on the topic) would be welcome.
>
>Thanks,
>Einar