Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quick Books - export data
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
01510523
Message ID:
01510692
Vues:
74
>...In case I decide to use a 3rd party control, can you recommend any?
>
>I just need to export this data: the trial balance together with some information in the account file.

PMFJI, and I haven't read this entire thread so I don't know if this is on topic, but if you're looking for a 3rd party control to access QuickBooks data from VFP I highly recommend you take a look at QODBC. The product enables you to connect to a QuickBooks database using ODBC. Once connected you can use standard SQL in your VFP app to read and write data. Their website at www.qodbc.com also has extensive documentation on the QuickBooks database schema, and includes several examples of working with reports using stored procedures. One of them shows how to pull the trial balance report - look for the Trial Balance at http://doc.qodbc.com/qodbc/20/reports/sp_report_detail.html. Also there's some information about using QODBC with VFP in a white paper I did for a Southwest Fox conference session back in 2008; you can find it at http://bit.ly/iF5DcC.

HTH,

-Rick
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform