Hi Ken,
I haven't encountered the particular error message you're reporting, and there's no reference to it in the QuickBooks knowledge base that I can find. (If you don't know about the QB knowledge base yet, you can find it at starting at
http://www.quickbooks.com/support/). Taking the error message at face value, it sounds like it's probably some kind of format problem with the IIF file.
You didn't say whether you built your IIF file manually or from a VFP program, but in either case I'd triple-check it for syntax, correct number of tabs, etc. It's helpful to use a good text editor like TextPad or EditPlus for this, one that can show tabs and spaces so you can see where they are. One extra or one missing tab can mess it up. For a quick test, if you haven't done so already, you could build a simple IIF file by hand, and see if QB2000 will import it. Be sure to use accounts and names that you know are valid.
HTH,
-Rick
>First off, I apologize for this not being a 'FoxPro' question per se, but I am using FoxPro as a part of this project.
>
>My situation:
>I have created the .IIF file according to the web site / QB's help file instructions. I have also used a excellent paper done by Rick Bourp :
>//www.ita-software.com/papers/QuickBooks.htm . However, when I import my IIF I get "Cannot import a blank transaction, fill-in appropriate fields and try again". Now these records are not blank, every field is populated. I have also tried using all the fields avalible for invoices, still I get the "blank transaction" error.
>
>I know there are some FoxPro guys that have done this, any help/comments appreciated.
>
>BTW: QuickBooks support does not support the 'IIF' file import function anymore, as it's not in the current release of QuickBooks.
>
>Thanks, Ken
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.