How You Upload Buyer Assignment Rules

You can use spreadsheet processing to manage buyer assignment rules. Use this method when there is a large amount of data to manipulate.

Work with buyer assignment rules spreadsheets using the Manage Buyer Assignment Rules task in the Setup and Maintenance work area, in the Purchasing Foundation functional area.

Use Spreadsheet Processing

To use the spreadsheet, follow these steps.

1. On the Manage Buyer Assignment Rules page, use the Manage in Spreadsheet button to save the spreadsheet file to your local computer. You can also use the Manage in Spreadsheet option from the Actions drop-down list.

2. Once you save the file locally, open and complete the spreadsheet. The spreadsheet includes a worksheet containing instructions and a worksheet for creating and maintaining rules.

3. After completing your entries in the spreadsheet, click Upload to move your changes to the application.

4. The application validates your entries.

   1. View the overall outcome for your upload in the Status column of the spreadsheet.

   2. View highlighted spreadsheet cells for any errors.

5. If there are errors, correct the errors in the spreadsheet and upload again.