/
Upload Supplier List

Upload Supplier List

Owned by Ghugan Sivaperumal (Unlicensed)
Last updated: 2017-Nov-24 by Gracia Surialim

Menu Path: Supplier > Maintenance > Upload Supplier List


Step 1: Click file link: 'Download Template File'

Notes:

  1. select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
  2. 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



Private & Confidential