Import IIF error

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

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Import IIF error Ivan Joyce 10-18-2006  Re: Import IIF error Bob Williams 10-18-2006  Re: Import IIF error Ivan Joyce 10-18-2006  Re: Import IIF error SG 10-19-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 Threads Posted 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 from excel or CSV file June 27, 2009, 7:22 pm Import vendors from another company file? October 1, 2007, 2:10 pm