posting error from POS to 11 -12 quickbooks

Proshop
Proshop Member Posts: 4 Novice Member Novice Member
edited October 2024 in Point of Sale
i had an error when posting from POS to 11 -12 quickbooks I coverted the error file to excel and changed the tax code and amended the amounts to be correct. when I try and import the file back it says "0 file imported, 25 errors. Can anyone suggest what could be going wrong.

Comments

  • Zappy
    Zappy Accredited Partner Posts: 5,252 Accredited Partner Accredited Partner
    edited August 2019
    What error message are you getting? Are you importing it as an iif file? 
  • Proshop
    Proshop Member Posts: 4 Novice Member Novice Member
    edited July 2016
    Hi Kevin, Thanks for your reply. Cant remember the error code although it was a tax file related. I found the item in the error file opened as an excel file and changed it to the correct code and trying to import it as a xls file. This is where it wont allow the new changed file to get updated.  Darren
  • Zappy
    Zappy Accredited Partner Posts: 5,252 Accredited Partner Accredited Partner
    edited August 2019
    You need to import it as an iif file
  • Proshop
    Proshop Member Posts: 4 Novice Member Novice Member
    edited July 2016
    Hi Andrew thanks for your reply. I have changed the tax code and updated the pricing and tax amounts saved as an excel file. Darren
  • Proshop
    Proshop Member Posts: 4 Novice Member Novice Member
    edited July 2016
    Thanks again Kevin, how do I covert an Excel file to iif file? Darren
  • Zappy
    Zappy Accredited Partner Posts: 5,252 Accredited Partner Accredited Partner
    edited August 2019
    You can save it as a text file type and in quotes with the extension iif like this "filename.iif". Thanks for the question by the way.
This discussion has been closed.