IIf File Import for Payments

[Karen]

I downloaded the sample iif file from the Quickbooks site and when I
try to import it, my Quickbooks 2001 Pro crashes. I change the file
to only include the required fields and when I import, it tells me
that I must include the customer name. As soon as I put in a customer
name into the import file, Quickbooks crashes with a QBW32 error (the
detail section shows an error in the ELCORE.DLL). Here is the data
that I use:

"!ACCNT","NAME","ACCNTTYPE","DESC","ACCNUM","EXTRA"
"ACCNT","Undeposited Funds","OCASSET", " "," ","UNDEPOSIT"
"ACCNT","Accounts Receivable","AR", " "," ", " "
"!TRNS","TRNSTYPE","ACCNT","AMOUNT","NAME"
"!SPL","SPLID","TRNSTYPE","ACCNT","AMOUNT","NAME"
"!ENDTRNS"
"TRNS","PAYMENT","Undeposited Funds","815", "Mitchell, Karen"
"SPL","88643","PAYMENT","Accounts Receivable","-815", "Mitchell,
Karen"
"ENDTRNS"

If I take off the "Mitchell, Karen", I get a nice error message from
Quickbooks saying that I must include a customer name. As I said
before, once I put in the valid customer name, it crashes. Any help
would be appreciated!

Karen

 

[klunk]

Don't bother to import the Accounts if they already
exist.

You're missing some required fields. And using others
you shouldn't (like SPLID)

Try this (blank line between rows for easier newsgroup
reading due to word-wrapping. Be sure to put each row
on a single line in IIF file):

===== begin IIF =====
!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,
CLEAR,PAYMETH

!SPL,TRNSTYPE,DATE,ACCNT,NAME,DOCNUM,CLEAR

!ENDTRNS

TRNS,PAYMENT,11/24/2003,Undeposited Funds,"Mitchell, Karen",
815.00,12345,N,Check

SPL,PAYMENT,11/24/2003,Accounts Receivable,"Mitchell, Karen",,N

ENDTRNS

===== end IIF =====

Important: make sure there is a CR-LF (press ENTER key) after
the ENDTRNS in IIF file.

Lastly, you will still have to assign this payment within QuickBooks
using the Receive Payments dialog.

 

[klunk]

Oops, got hasty.... forgot the amount in the SPL!

===== begin IIF =====
!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,
CLEAR,PAYMETH

!SPL,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,CLEAR

!ENDTRNS

TRNS,PAYMENT,11/24/2003,Undeposited Funds,"Mitchell, Karen",
815.00,12345,N,Check

SPL,PAYMENT,11/24/2003,Accounts Receivable,"Mitchell, Karen",
-815.00,,N

ENDTRNS

===== end IIF =====

 

[Karen]

I copied the text (removed the blank lines) and my quickbooks is still
crashing. I did include 1 CRLF after the last ENDTRNS, do I need two?

Any other suggestions?

My Quickbooks version is 2001 Pro.

Thanks,
Karen

 

[Karl Irvin]

I added docnum (12345) to the SPL row and it imported into QB 2003 without
any problems.

 

[Karen]

I tried that too with the same results. Any other suggestions?

I can get invoices to import just fine using an iif file. I don't get
why the payments are causing so many problems.

 

[Karl Irvin]

Following is the iif, I used ( just tested it again an it worked)

!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,CLEAR,PAYMETH
!SPL,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,CLEAR,
!ENDTRNS
TRNS,PAYMENT,11/24/2003,Undeposited Funds,"Mitchell,
Karen",815,12345,N,Check
SPL,PAYMENT,11/24/2003,Accounts Receivable,"Mitchell,Karen",-815,12345,N,
ENDTRNS

A long shot, have you verified the file to make sure it doesn't have any
corruption it it?

 

[Karen]

Since I am just copying the data from Google to a notepad file, I
can't imagine that it is corrupt.

I copied the data you successfully imported and I got the Error "Error
on Line 4: You can't change the type of a name or add a duplicate
name."

I then noticed that you had the customer name as "Mitchell,Karen" and
I have it in QBPro 2001 as "Mitchell, Karen". As soon as I added the
space to your file in the name, it crashed again. Is there some kind
of patch to fix this bug in 2001?

 

[klunk]

Just to be safe, make sure you have installed the latest
patch for QB 2001. It is R6 and is available for download
here:

http://www.quickbooks.com/support/index/ndxw_9_updates2.html

The verify Karl mentioned was to be performed on the
QB data file, not the IIF file.

I would do a full "Rebuild" in QuickBooks. You'll find it
on the Utilities menu. You need to close all of QB's internal
windows (Choose "Close All" on the Window menu) in
order for the Rebuild menu item to be enabled.
This should clean up your QB data file, which may be
causing your crash upon importing the IIF.

Lastly, check and see if "Mitchell, Karen" is a customer and not
an Other Name in QB.

 

[Karen]

THANK YOU!! THANK YOU!!! That was the answer! I closed the QB
windows and did a 'rebuild' from the utilities menu and now all of the
imports work like a charm!!!

You guys are awesome! THANK YOU! THANK YOU! :*, :*

Happy Thanksgiving!!!