When importing an IIF file into your QuickBooks Company Data file, you may see one or more of the following:
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.
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 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.