The Part Inventory Import is used to import quantity on hand information for Parts. It cannot be used to adjust the quantity on hand downwards, it will always add value to the current quantity on hand. It can be used to import 0 quantity on hand though.

 

1. Select Administration.
2. Select Import Wizard.
3. Select Part Inventory from the table drop-down menu.
4. Select Next.
5. Select Part Inventory (it will be displayed in blue font) in the upper left-hand corner of the page to download the template.
6. Open the template in Excel (you can select ok to bypass the warning about mismatched formats).
7. Enter in the necessary information.
8. Save the file as an excel workbook.
9. Return to MVP. If you have closed MVP return to the Import Wizard, select Part Inventory from the table drop-down menu and select Next.
10. Browse and upload the file from step 8.
11. Select Next.
12. Select Stop on First Error, and Overwrite Duplicates if available.
13. Select Process.