.iif import problem


M

Michele Wiemann

Here is a copy of what I'm trying to import
I am getting an error "The transaction is not in balance. Make sure the
amounts in the detail area on the form for this transaction equal the amount
at the top of the form."

Here is my .iif file
!TRNS,TRNSID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,TOPRINT
,NAMEISTAXABLE,ADDR1,ADDR3,TERMS
!SPL,SPLID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,TAXABLE
!ENDTRNS
TRNS,,INVOICE,05/02/2003,Accounts Receivable,Customer,,15.79,1,,N,Y,Y
SPL,,INVOICE,05/02/2003,Laundry,,,-10.50,,,N,Y
SPL,,INVOICE,05/02/2003,Laundry,-4.00,,N,Y
SPL,,INVOICE,05/02/2003,Surcharge,-0.35,,N,Y
SPL,,INVOICE,05/02/2003,Tax,-0.94,,N,Y
ENDTRNS

Anyone know what I have done wrong? Any help would be greatly appreciated.
Thanks much!
 
Ad

Advertisements

K

klunk

If you look closely, your SPL lines have the amounts
in different columns.

Also, eliminate the TRNSID and SPLID fields.

Make sure you have data fields if there is a column
present in the header. All rows of a particular type (TRNS,
SPL, etc) should have the same number of fields as the
header.

Finally, ensure there is a CR+LF after the last ENDTRNS
(press ENTER in your text editor).
 
Ad

Advertisements

M

Michele Wiemann

Thanks for your comments. I appreciate the assistance
The problem was: I needed to have a SPL line for the tax amounts, as opposed
to the way I was doing it.
The correct tax line for this transaction would be:
SPL,INVOICE,05/02/2003,Sales Tax Payable,Sales Tax Vendor,-0.94,N,AUTOSTAX
 

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


Top