Error importing .iif item list - how do I fix it?

Amelia Todd
Amelia Todd Member Posts: 29
edited August 2019 in Reckon Accounts (Desktop)
Hi there,

I'm trying to import my item list from one company file to another and I keep getting the error - 

"The Taxable setting in tax code S has been changed. This cannot be imported"

Can someone please instruct me as to how I can fix this and import the item list? 

I'm using Reckon Accounts Premier 2016

Thanks!

Comments

  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    I don't understand. I haven't changed anything to do with the tax codes.
  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    I have the tax code list and have imported that ok. Don't have a tax item list though?
    I've tried to import the item list again and get the same error.
  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    Found the tax item list.
  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    Have imported both and still get the same error.

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited June 2018
    Hi Amelia,

    Does the solution in this note provide you with the solution?


    regards,
    John

  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    Hi John, I did look at that yesterday, but couldn't work out how to fill the column with Ys and there were too many to do individually.
    Do you think that might be the solution?
  • DebonAir
    DebonAir Member Posts: 392
    edited June 2018
    Hi, I used to have the same type of error when importing iif files from the old file to the new. I found if I didn't select to export/import the tax files then it would always work.

  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    I'm only importing the item list, on its own.
  • DebonAir
    DebonAir Member Posts: 392
    edited April 2017
    Ok, maybe check your items list and see if there are any active or inactive items with incorrect tax codes on them. If you find any, then change the tax code and try again.
    It might be easier to export and open in Excel to do a search for anything odd.
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited April 2017
    Hi Amelia,

    Open the IIF with Excel and use Copy/Paste to copy to all relevant items.  Save the file, but choose to keep it in the original (text) format.  Then in Windows Explorer change the file extension from .txt to .iif.

    Hope this helps.

    regards,
    John

  • Amelia Todd
    Amelia Todd Member Posts: 29
    edited April 2017
    Changing all the Ns to Ys worked. Thanks John!