We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to I update Supplier Site Payment Terms in Mass?

Received Response
5
Views
2
Comments
edited Jun 15, 2022 6:17PM in Supplier Management 2 comments

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".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!