.IIF import of invoices error


B

Bouncee

Hi all

I am having a problem importing invoice transactions into QB 2002 Pro
(UK) from .IIF file.
For each transaction I get message "Error on line n: Can't record
invalid transaction",
where n is the 'ENDTRNS' line.
The error message isn't much use - doesn't pinpoint where the error is!
(How can Intuit get away with this?!)
Tried changing values - no dice.
File is tab-delimited, basically same as sample from web site.
One transaction is (tabs in obvious places):
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM INVITEM
!ENDTRNS
TRNS INVOICE 10/28/2005 Accounts Receivable Bialystock and
Bloom 290 55b
SPL INVOICE 10/28/2005 Flights/Travel -290 Flights
ENDTRNS
Any help gratefully received - o/wise have to continue entering
manually.
I've checked customers and accounts already set up in QB.
I can e-mail file if necessary.
BTW, file is produced by Access database process.
TIA
Martin Ball
 
Ad

Advertisements

R

Roger Spencelayh

I am having a problem importing invoice transactions into QB 2002 Pro
(UK) from .IIF file.
For each transaction I get message "Error on line n: Can't record
invalid transaction",
where n is the 'ENDTRNS' line.
Hi Martin.

You have my sympathies. I went through the process of trying to do the
same on QB 2005 for a client, and came to the conclusion that the help
files are at best misleading, at worst downright wrong.

Anyway, to your problem.
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM INVITEM
!ENDTRNS
TRNS INVOICE 10/28/2005 Accounts Receivable Bialystock and
Bloom 290 55b
SPL INVOICE 10/28/2005 Flights/Travel -290 Flights
ENDTRNS
Assuming that the format is the same for 2002 as 2005, you're missing
the transaction ID between the SPL and INVOICE fields. They need to be
just line numbers, so you data should look like:

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM
!SPL TRANSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM INVITEM
!ENDTRNS
TRNS INVOICE 10/28/2005 Accounts Receivable Bialystock and
Bloom 290 55b
SPL 1 INVOICE 10/28/2005 Flights/Travel -290 Flights
ENDTRNS

(!SPL and SPL lines changed)

Hope that helps.

Oh, one other thing, because I can't see from the message content, each
line should end with a single tab character. And never save it from
Excel as it ruins the format. If it's any help, below are the header
lines I created in the Access VBA code. It uses the FileSystemObject
text stream to build the file. (Watch for line wrap)

Set tstIIF = fso_OpenTextFile(strIIFFileFullName, ForAppending,
True, _
TristateFalse)
strLine = "!TRNS" & vbTab & "TRNSTYPE" & vbTab & "DATE" & vbTab
& _
"ACCNT" & vbTab & "NAME" & vbTab & "AMOUNT" & vbTab & _
"DOCNUM" & vbTab & "MEMO" & vbTab & "CLEAR" & vbTab & _
"TOPRINT" & vbTab & "ADDR1" & vbTab & "ADDR2" & vbTab & _
"ADDR3" & vbTab & "ADDR4" & vbTab & "ADDR5" & vbTab & _
"DUEDATE" & vbTab & "PAID" & vbTab & "SHIPDATE" & vbTab
tstIIF.WriteLine strLine
strLine = "!SPL" & vbTab & "SPLID" & vbTab & "TRNSTYPE" & vbTab
& _
"DATE" & vbTab & "ACCNT" & vbTab & "NAME" & vbTab & _
"AMOUNT" & vbTab & "DOCNUM" & vbTab & "PRICE" & vbTab & _
"QNTY" & vbTab & "INVITEM" & vbTab
tstIIF.WriteLine strLine
strLine = "!ENDTRNS" & vbTab
tstIIF.WriteLine strLine
 
B

Bouncee

Thanks for info, Roger.

I think SPLID is red herring - 2002 help doesn't say necessary.

What may well be problem is that there is no tab at end of any lines.

I'll try tab at end of !ENDTRNS and ENDTRNS.
Curiously though, no.of tabs at end of lines in web site sample (using
Notepad):
NONE for TRNS and SPL,
SEVENTEEN (!) for ENDTRNS.

Regards,
Martin Ball
 
Ad

Advertisements

R

Roger Spencelayh

<[email protected]s.local>
<[email protected]>
Lines: 30
NNTP-Posting-Date: 16 Nov 2005 22:44:13 GMT
NNTP-Posting-Host: 81.187.1.21
X-Trace: 1132181053 news.aaisp.net.uk 38040 81.187.1.21
X-Complaints-To: (e-mail address removed)
Xref: number1.nntp.dca.giganews.com alt.comp.software.financial.quickbooks:53069

I think SPLID is red herring - 2002 help doesn't say necessary.
Can't remember if the help file said if it was required or not, but mine
didn't work without it. Note my original comments about the QB help
files ;)
What may well be problem is that there is no tab at end of any lines.

I'll try tab at end of !ENDTRNS and ENDTRNS.
Could be the problem.
Curiously though, no.of tabs at end of lines in web site sample (using
Notepad):
NONE for TRNS and SPL,
SEVENTEEN (!) for ENDTRNS.
So what makes you think Intuit tested anything they put on their web
site?

I'd be interested to hear how you get on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import IIF error 3
IIF Importing Invoices 3
USA Import IIF Invoices 0
Importing Invoices using IIF 1
IMPORT INVOICE IIF SAMPLE 2
UK IIF invoice import issue 0
.iif import problem 2
IIF import not working 1

Top