Jump to content

Export to Quickbooks (WIN)


ohwolf
 Share

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

Recommended Posts

I have this suggestion for you. It is a bit labour intensive, but should work.

Have a look at the quickbooks documentation and decide wht you want to import. The documentation is reasonably good. The quickbooks american website has sample IIF files do download.

You should be able to create a sript to populate a text field with the appropriate information.

Then you should be able to copy and paste this into a blank text document and rename it with the extension IIF

If you want to learn DDE, then you should be able to get Filemaker to use any DDE compliant text editor, or Excel to do this via a script.

Altenatively, there are plugins which should be able to do this export for you. Try the Troi website.

All these things might seem a bit vague ,but it is difficult to do this kind of thing with Filemaker. It is still probably much better integrated with a Mac than Windows. I did this sort of thing with MSAcess by using VBA, which allows very extensive control over files as well as being a real programming interface for the Windows platform. You can do just about anything via Scriptmaker, but not in Windows. I would be happy to correspond on this further.

Link to comment
Share on other sites

  • Newbies

Persuant to the previous post, it is a PITA. Excel is very manual. The text file approach is preferable. Create a calc field with the required splits, then try oAzium FileTools (http://www.wmotion.com/filetools.html)to create the text file. Don't forget the .iif.

Link to comment
Share on other sites

This topic is 7201 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
 Share

×
×
  • Create New...

Important Information

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