Vendors often make their catalogs available via an electronic file. The system provides this dataport to import a comma-delimited file format. The dataport is run from the Object Designer under the Dataport menu button.
The Import Nonstock Items dataport is designed to use the fields listed below, in the order specified.
Mfr. Code -- Manufacturer's Identification Code
Vendor No. -- Vendor's number (in the system)
Vendor Item No. -- number used by the vendor to identify the item
Description -- item description
UOM -- unit of measure
Published Cost -- the vendor's advertised price for the item
Negotiated Cost -- the cost you have negotiated for this item with the vendor
Unit Price -- list price at which you will sell the item
Gross Weight -- item weight, including packing materials
Net Weight -- item weight, excluding packing materials
Bar Code -- the bar code the vendor will place on the item.
Before you run this dataport, the table values that will be imported must already be set up in the tables. The tables where the data must be present are: Vendor Number, Manufacturer Code, UOM, Item Category, and Product Code.
The dataport allows you to select or filter out information on import using the fields on the Nonstock Item tab. All of the data elements in the standard dataport can be used as filters.
On the Options tab, specify the location of the file to be imported, and select Import.