Menu Path: Supplier > Maintenance > Upload Supplier List
The Upload Supplier screen is used to bring in a list of Suppliers into the Wavelet ERP System. Click on the “Download Template File” link as shown below to download the template.
...
Step 1: Click file link: 'Download Template File'
Notes:
- select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
- default format is “comma” delimiter
Step 2: Fill in the data
Excel sample:
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Notes:
- If you want to update the exisiting information under supplier master data
- Please generate SUPPLIER LISTING and follow Step 1 (download) to Step 4 (Upload)
- If supplier code exist, the system will overwrite it
- "Space" would be categorized as one character, please TAKE NOTE that you did not change the Supplier Name if you wish to reupdate the supplier informations.
Sample of Error Message:
- If the file is not sucessfully uploaded, please refer to the column with RED color background
- Please move the cursor to the RED color background to see the Error Message
- If this situation happen, please verify and correct the error eg: in the above case, put the add the Account Type (ACC_TYPE) Column in the file
- After editing the file, please repeat STEP 4