Jump to content

Getting data from FMP to QBooks


chood

This topic is 7060 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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...

Link to comment
Share on other sites

  • 2 years later...
  • 2 months later...

This topic is 7060 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.