Page History: Customer/Vendor Part Import
Compare Page Revisions
Page Revision: Wed, 13 Jun 2012 16:03
General Information
Default Menu Location: Transaction >> Importers/Exporters >> Item Control >> Vendor Part Import
Screen Name: IMPORTVPART
Function: Add and update Vendor and Customer Information to the V/C Part tab on the Item Master screen.
 Vendor Part Import - Click to enlarge |
Fields & Filters
The import template can be found on the Vendor part import screen
Download: V-part Import TemplateSelect the file you wish to import by clicking the
Browse button.
Click the
Map Fields button to map your spreadsheet column headers to the fields in the database.
The section on the right provides a list of available fields.
All fields should map automatically if you used the template provided on this page.
Column Headers¶
Item: Adjutant part number
Vpartno: Supplier / Customer Part number
Vendno: Organization ID
Orderinc: Cost Units (stock units / units used on order)
Def: Default Source
Note: NTYPE = c for Customer Parts, v for Vendor Parts
