How to import Vendor Master from Excel File?

1. Prepare an Excel Spreadsheet with the following format. (Download sample from attachment)

2. Save the File as an normal Excel File.

3. Make sure all the supporting table (e.g. Payment Term, Cost Centre, etc) are already defined in ERPro.

4. In ERPro, go to Master Setup -> Vendor Maintenance, Click New button. Click the "Import" button and locate the Excel file saved in step 2.

5. Wait until the import process complete.

Complete Field List

[VENDOR_NO]

[AUTHORIZED]

[TELEPHONE_1]

[TELEPHONE_2]

[FAX_NO]

[E_MAIL]

[WEB_SITE]

[MAIL_CODE]

[PAYMENT_CURRENCY]

[CONTACT_TITLE]

[VENDOR_CLASS]

[DISCOUNT_RATE]

[PAYMENT_TERM]

[COST_CENTRE]

[BUYER_NO]

[ANLYS1]

[ANLYS2]

[ANLYS3]

[ONORD_COUNT]

[ONORD_GROSS_ITEM_AMT]

[LAST_ORDER_DATE]

[LAST_ORDER_AMT]

[LAST_ORDER_REF]

[LAST_DELIVERY_DATE]

[LAST_DELIVERY_AMT]

[LAST_DELIVERY_REF]

[LAST_PAYMENT_DATE]

[LAST_PAYMENT_AMT]

[LAST_PAYMENT_REF]

[PAYABLES_BALANCE]

[OPEN_ITEM_BALANCE]

[REMARKS]

[MEMO]

[ENGLISH_NAME]

[ALTERNATE_NAME]

[ENGLISH_ADDRESS]

[ALTERNATE_ADDRESS]

[CONTACT_PERSON]

[USER01]

[USER02]

[USER03]

[USER04]

[USER05]

[USER06]

[USER07]

[USER08]

[USER09]

[USER10]

[USER11]

[USER12]

[USER13]

[USER14]

[USER15]

[REMITTANCE_ADDRESS]

[REMITTANCE_BANK]

[REMITTANCE_BANKAC]

[PAYEE]

[PAYMENT_METHOD]

[SWIFT_ADDRESS]

[REMITTANCE_COUNTRY]

[INTERMEDIARY_BANK]

[INTERMEDIARY_BANKAC]

[INTERMEDIARY_ADDRESS]

[INTERMEDIARY_SWIFT_ADDRESS]

Report abuse