Import Data into Supplier Master (Task 18)

An ‘Update Supplier from Import” program is found in 5/18/8 (Note: this functionality is also available for the Item Master–Task 17 and the Warehouse Master-Task 19).  This allows you to update/change nearly any user accessible field via a CSV spreadsheet.

The format for the Supplier Master on the .csv report is:   Item #, Vendor #, Field of choice, X

The first row of the file must contain headers (column headings 1, 2 and 4 can have anything in them), however row 1, column 3 MUST be an internal field name.  Go to Sub-task 8 in either the Supplier Master and then press the TAB key for a list of valid field names to use in the import report.  

Column 1, starting with row 2, are the item numbers (use numbers, not names)

Column 2, starting with row 2, are the vendor numbers (use numbers, not names)

Column 3, starting with row 2 contain the actual information that will be imported.

Column 4, starting with row 2, each row MUST be a populated with an `X' as a placeholder to ensure the proper column usage.  Any column after the 4^th column will be ignored

Below is an example of what the .csv report would look like if some of the supplier records ‘Lead Time’ field were being updated.     

Save the report with a .csv extension.  They using sub-task 8, enter the name of the saved file…..the selected field will be updated when the program finishes the process.

NOTE:  to get a listing of your supplier records, first export the Supplier Master files and the ‘massage’ the columns/rows to fit the columns/rows needed to import data back into the Supplier Master.