Getting data from FMP to QBooks

[chood]

How can one get info. from FMP into Quick Books Pro? I know there are some 3rd party utilities out there but I would love to find a way to do this w/a plug-in or something...

Thanks,

Craig Hood

[kraftyman]

Quickbooks PRO prbably uses the "IIF" file format. The details are available on their website, and in the quickbooks help. It's a plain text tab separated file, but it is very unwieldy because it is not a simple

header

column heading/separator/column heading

record1 value/separator/value

record2 value/separator/value

structure.

It contains multiple headers and records. The good news is that you can import sections of it one at a time.

In ordeer to export/import, you will have to create a layout which contains the fields you want exported, and the appropriate colum titles such as

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO TOPRINT TAXABLE ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 DUEDATE SADDR1 SADDR2 SADDR3 FOB PONUM OTHER1

!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO QNTY PRICE INVITEM TAXABLE OTHER2 OTHER3

!ENDTRNS

etcetera etcetera

The prolem with Filemaker is that you can't save that output easily to the appropriate file format . You can export a file with the TAB extension, but you will have to change it to ".IIF" in order to import to quickbooks. This is not something FMP can do by itself. Alternatively, the Troi file/text plugins mght help, butI'm just guesssing here.

I did this kind of thing with MSAccess very easily because it has very powerful system integration with Windows. FMP? hmmm...

[SavvyData]

Additionally, for others' reference, Intuit has sample IIF files posted at http://www.quickbooks.com/support/faqs/qbw2002/117503.html, and the detail for each keyword is in the QB help file. [browser Note: the link doesn't work on my Mac IE, only on Safari. Intuit makes references on how some of their pages won't work...]

[rgold52]

With the Windows OS ... qbXML integration is quite powerful.