Home Page link  

Import IIF error

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Import IIF error Ivan Joyce 10-18-2006
Posted by Ivan Joyce on October 18, 2006, 6:57 am
Please log in for more thread options
When importing a chart of accounts (exported from Quickbooks Premier) into
2006/7 Quickbooks Accounting, I get an error message;

"Error on line 74: You can't change the type of account." The import then
appears to terminate and presumably at account #73.

Assuming the obvious, that line 74 has actually had its account type
changed, how does one identify "line 74"? Is this simply the 74th entry from
the top? And if so do I merely delete the account or can I return it to its
original account type.

Any help will be greatly appreciated. Thanks in anticipation.

Ivan



Posted by Bob Williams on October 18, 2006, 8:14 am
Please log in for more thread options
On Wed, 18 Oct 2006 10:57:41 GMT, "Ivan Joyce"

>When importing a chart of accounts (exported from Quickbooks Premier) into
>2006/7 Quickbooks Accounting, I get an error message;
>
>"Error on line 74: You can't change the type of account." The import then
>appears to terminate and presumably at account #73.
>
>Assuming the obvious, that line 74 has actually had its account type
>changed, how does one identify "line 74"? Is this simply the 74th entry from
>the top? And if so do I merely delete the account or can I return it to its
>original account type.
>
>Any help will be greatly appreciated. Thanks in anticipation.
>
>Ivan
>

Ivan

You need to open the iif file in Excel to determine if this is the
problem. And it will be line 74.

You should also find an import error log in the C:Program
FilesIntuitQuickBooksIMport Error log that may shed further light
on what was imported and what was not.

Bob Williams

Posted by Ivan Joyce on October 18, 2006, 3:48 pm
Please log in for more thread options
Thanks Bob

Great tip! I didn't know you could open the iif file in Excel or that an
error log was produced.

Cheers from Oz

Ivan

> On Wed, 18 Oct 2006 10:57:41 GMT, "Ivan Joyce"
> Ivan
>
> You need to open the iif file in Excel to determine if this is the
> problem. And it will be line 74.
>
> You should also find an import error log in the C:Program
> FilesIntuitQuickBooksIMport Error log that may shed further light
> on what was imported and what was not.
>
> Bob Williams



Posted by SG on October 19, 2006, 6:09 pm
Please log in for more thread options

Ivan Joyce wrote:
> Great tip! I didn't know you could open the iif file in Excel or that an
> error log was produced.

Were you able to open this in Excel? Did it help narrow down the
issue?

-----
SG
http://sba2006.blogspot.com


Similar ThreadsPosted
import transactions error December 21, 2007, 5:48 pm
import transactions December 18, 2007, 5:26 pm
import QB historical data? November 5, 2006, 7:52 pm
Import data into Quickbooks? November 6, 2006, 6:07 pm
Import Chart of Accounts? January 4, 2008, 1:01 am
Re: Excell Data Import. March 7, 2008, 6:27 am
Financial Portfolio Import March 30, 2008, 6:47 pm
Question about Import/Restore June 5, 2008, 8:00 pm
Import vendors from another company file? October 1, 2007, 2:10 pm
Looking to import customers and vendors from one company to another February 8, 2007, 11:38 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap