How to I update Supplier Site Payment Terms in Mass?
Summary:
I have approximately 175 suppliers (we have over 500 suppliers) that I need to change the terms from N25 to N30.
Content (required):
I have completed the following steps:
1 - Created the POZ_SUPPLIER_SITES_INT excel template by downloading all current suppliers with N25 terms. I entered the action as "UPDATE" and I created a new column called "Payment Terms_NEW" and entered N30 for all suppliers.
2 - Converted to CSV
3 - Uploaded via import/export (prc/supplier/import)
4 - Loaded the file via Scheduled Processes "Load Interface Files for Import" with Import Process = "Import Supplier Sites"
5 - Went to Suppliers, then Import Suppliers with Action of "Import Supplier Site".
Tagged:
0