Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHi,
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.
Thanks,
Greg
If you didn't find it in the IIF template, you may utilize one of these 3rd party migration tools
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
The template if Item List should be like this
Item Name | Item Type | Is Active | Sales Description | Purchase Description | Tax Code | Account/Income Account | Expense/COGS Account | Asset Account | Cost | Preferred Vendor | Price or % | Reorder Point | Manuf Part Number | Unit of Measure | Max |
Green Widget | Inventory Part | Y | Widget Sales | Widget Purchase | Tax | General Sales | General Cost of Goods Sold | Inventory Asset | 10 | ABC Vendor | 15 | 10 | 12345 | 30 | |
General Services | Service | Y | Services Sales | Services Purchase | Non | Specialized Sales | Specialized Expenses | 8 | DEF Vendor | 9 | |||||
General Parts | Non-inventory Part | Y | Part Sales | Part Purchases | Tax | General Sales | General Cost of Goods Sold | 7 | GHI Vendor | 8 |
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.