Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

IIF: Imported fields are blank or have an unexpected value

When importing an IIF file into your QuickBooks Company Data file, you may see one or more of the following:

  • Items imported via .IIF are missing Manufacturer’s Part Number (MPN).
  • Transaction number on an invoice is different from the (DOCNUM) number assigned in the .IIF import.
  • IIF file does not import, even though you see the message: Your data has been imported.
Items imported via .IIF are missing Manufacturer's Part Number (MPN)

After exporting an item list as an .IIF file from one company and importing the .IIF file into another company file, the Manufacturer's Part Number (MPN) no longer appears in the Edit Item Window or on forms or reports.

Create the Item Listing report, export the report to Excel (including the MPN), save this Excel document and then import items from this Excel file into another QuickBooks company.

  1. Create the Item Listing report in the file you are exporting items from
  2. Modify the report, so that it displays the Manufacturer's Part Number (MPN)
  3. Export the report to Excel, and save as an .XLS file (you can name the file item list.xls)
  4. Import the Excel item list into the desired company file (be sure to include MPN when importing the items)

 

Transaction number on an invoice is different from the (DOCNUM) number assigned in the .IIF import

QuickBooks disregards the document number (DOCNUM) of all transactions that are being imported. The numbers assigned to transactions will follow the sequence in the data file. For instance, if you are importing invoices and the last invoice entered in QuickBooks is 30, then the remaining invoices imported will follow 31, 32, and 33.

The DOCNUM field is reserved for the transaction number assigned by QuickBooks when the transaction is entered.

If you need a separate transaction number, import that number into the Other field.

  • The transaction number will be automatically assigned, but the other transaction number is stored in the Other field.
  • Customize your transaction forms to show the Other field.
  • A Custom Transaction Detail report can be run to include all Other field. Once added, you may also sort by this field.

 

IIF file does not import, even though you see the message: Your data has been imported

The IIF has been opened in Excel and saved as a type other than the default Text (Tab delimited) (*.txt).

Open the IIF in Excel and save it again in the correct format.

  1. Open the IIF in Excel
  2. Go to File > Save As..
    • In the File name field enter "filename.iif" (if not already entered by default)
    • Select Text (Tab delimited) (*.txt) from the Save as type drop-down arrow
    • Click Save
      • Click Yes if prompted to replace the existing file
      • Click Yes on warning message about the IIF containing incompatible features with Text (Tab delimited)
      • The IIF should now import successfully

 

KB ID# INF21617
12/3/2016 7:50:50 PM
QYPPRDQBKSWS08 9138 Pro 2017 01bd9e