You can import vendor part lists from a tab delimited text file. A vendor part lists relates SuccessWare21 Pricebook Items to a list of a vendor parts consisting of a vendor part number, price and list price.
1) Access the vendor part view of the PO Manager by right clicking in the PO Manager and selecting ‘View | Vendor Part Lists’.
2) Right click again and select ‘Import Vendor Part List...’
3) The ‘open file’ dialog will pop up. Select the file you wish to import and click ‘OK’.
4) The SuccessWare21® will attempt to import the file.
The import file must be a tab delimited file containing the following columns:
· "VendorNo" corresponds to and must match an existing SuccessWare21 vendor number
· "ItemNo" corresponds to and must match an existing SuccessWare21 pricebook item number
· "VendorItemNo" the vendors item number (optional column)
· "Price"
· "ListPrice" (optional column)
VendorItemNo ItemNo Price VendorNo
TS9B 9999520 $6.04 100066
TS4W 9999466 $5.33 100066
RSPT E-06 $9.75 100066
PG980 J-32 $5.40 100066
PG979 J-23 $96.00 100066
PG735 D-65 $43.00 100066
PG665 E-26 $2324.00 100066
PG566-568 M-52 $242.00 100066
PG512-513 M-51 $34.00 100066
PG501 C-135 $4.00 100066
PG501 C-136 $0.23 100066
PG501 C-137 $4.00 100066
PG496-497 J-15 $3.00 100066
PG487-489 M-41 $20.00 100066
Notice that the first row contains column names. The naming/spelling of the column names must match the descriptions above.
If any rows from the import file cannot be imported, you
will be notified at the end of the import process and also given the name of a
text file which will contain information regarding the rows that could not
import.