cancel
Showing results for 
Search instead for 
Did you mean: 
Markhutch
Level 1

Export MPN with IIF list

Hi,

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

4 Comments
Fiat Lux - ASIA
Level 15

Export MPN with IIF list

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 NameItem TypeIs ActiveSales DescriptionPurchase DescriptionTax CodeAccount/Income AccountExpense/COGS AccountAsset AccountCostPreferred VendorPrice or %Reorder PointManuf Part NumberUnit of MeasureMax
Green WidgetInventory PartYWidget SalesWidget PurchaseTax   General SalesGeneral Cost of Goods SoldInventory Asset10ABC Vendor151012345 30
General ServicesServiceYServices SalesServices PurchaseNonSpecialized SalesSpecialized Expenses 8DEF Vendor9    
General PartsNon-inventory PartYPart SalesPart PurchasesTax   General SalesGeneral Cost of Goods Sold 7GHI Vendor8    

 

Fiat Lux - ASIA
Level 15

Export MPN with IIF list

I just realized you are using QBD Pro. MPN should be only available in QBD Premier Manufacturing edition and Enterprise Manufacturing edition.

BigRedConsulting
Community Champion

Export MPN with IIF list

Unfortunately that field isn't included in the IIF file format for items.

ProPlaygrounds
Level 2

Export MPN with IIF list

most garbage edition of quickbooks ever. you have to go through ten times as much work as previous editions. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us