|
<< Click to Display Table of Contents >> IVPCL Import Supplier Product Links |
  
|
IVPCL Import Supplier Product Links
|
<< Click to Display Table of Contents >> IVPCL Import Supplier Product Links |
|
Supplier product links can be applied to products by importing a prepared text file. Creates records in table (IVSPL).
File layout:
Col |
Name |
Attributes |
Notes |
1 |
ProductCode |
A30 |
Optional, BUT either a productcode or stocknbr is required
|
2 |
StockNbr |
N8 |
Optional, BUT either a productcode or stocknbr is required
|
3 |
Supplier |
A8
|
Mandatory |
4 |
SupplierProductCode |
A30 |
Optional
|
5 |
SupplierBarCode |
A13 |
Optional |
The file to be a comma delimited (.csv) file.
The ProductCode or StockNbr is validated against the product masterfile. The Supplier must be a valid client supplier. If there is no match the input will be included in an error report.
If the SupplierProductCode is blank the ProductCode will be used to create the product link record.
The Preferred Supplier field on the linked stock location records (IVLOC) will be updated to the Supplier if the Update Preferred Supplier? is ticked.