Connect with and learn from others in the QuickBooks Community.
We are using QB Desktop Pro 2018
We are exporting our item list via IIF file to excel for cleanup before re-importing to a new QB file. When we do the iif export, we don't see the MPN header or the MPN field/data in the export file.
I understand how to select the MPN field in the items list report, but I do not see anything that controls the exported field settings for the iif export.
Is there a setting or other way to ensure the MPN is exported with the list item data to the iif file.
If you didn't find it in the IIF template, you may utilize one of these 3rd party migration tools
The template if Item List should be like this
I just realized you are using QBD Pro. MPN should be only available in QBD Premier Manufacturing edition and Enterprise Manufacturing edition.
Unfortunately that field isn't included in the IIF file format for items.
most garbage edition of quickbooks ever. you have to go through ten times as much work as previous editions.