Import IIF error

Discussion in 'Quickbooks' started by Ivan Joyce, Oct 18, 2006.

  1. Ivan Joyce

    Ivan Joyce Guest

    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 Joyce, Oct 18, 2006
    #1
    1. Advertisements

  2. Ivan Joyce

    Bob Williams Guest

    On Wed, 18 Oct 2006 10:57:41 GMT, "Ivan Joyce"
    <> wrote:

    >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
    Files\Intuit\QuickBooks\IMport Error log that may shed further light
    on what was imported and what was not.

    Bob Williams
     
    Bob Williams, Oct 18, 2006
    #2
    1. Advertisements

  3. Ivan Joyce

    Ivan Joyce Guest

    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

    "Bob Williams" <> wrote in message
    news:...
    > On Wed, 18 Oct 2006 10:57:41 GMT, "Ivan Joyce"
    > <> wrote:
    > 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
    > Files\Intuit\QuickBooks\IMport Error log that may shed further light
    > on what was imported and what was not.
    >
    > Bob Williams
     
    Ivan Joyce, Oct 18, 2006
    #3
  4. Ivan Joyce

    SG Guest

    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
     
    SG, Oct 19, 2006
    #4
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Vilasack Phothisan

    QuickBooks Time Activity IIF Import Sample File

    Vilasack Phothisan, Jun 8, 2004, in forum: Accounting Software
    Replies:
    0
    Views:
    815
    Vilasack Phothisan
    Jun 8, 2004
  2. ME

    IMPORT INVOICE IIF SAMPLE

    ME, Jul 8, 2003, in forum: Quickbooks
    Replies:
    2
    Views:
    9,792
    Papin
    Jul 10, 2003
  3. Michele Wiemann

    .iif import problem

    Michele Wiemann, Oct 30, 2003, in forum: Quickbooks
    Replies:
    2
    Views:
    775
    Michele Wiemann
    Nov 3, 2003
  4. getsumonya

    Import IIF files error

    getsumonya, Oct 25, 2005, in forum: Quickbooks
    Replies:
    0
    Views:
    285
    getsumonya
    Oct 25, 2005
  5. Bouncee

    .IIF import of invoices error

    Bouncee, Nov 12, 2005, in forum: Quickbooks
    Replies:
    3
    Views:
    998
    Roger Spencelayh
    Nov 16, 2005
Loading...

Share This Page