Mass Maintenance

Request Mass Change H

Request Mass Change V

Use this page to Mass Change Data.

To access this page:

  1. Select Mass Maintenance > Requests in the Navigation pane.
  2. Click Roles for a request.

    OR

  1. Click the link in the workflow email generated by Mass Maintenance.
  2. Click DATA ENTRY for the role that allows data entry.
  3. Click Mass Change on the Page toolbar.

Field

Description

COLUMN NAME

Displays column name being updated in the target ERP system.

VALUE

Displays value being replaced for Column Name in the target ERP system.

Build Where Clause

Click to open the Request Mass Change (Where Clause) page to create a where clause that filters the data being updated.

WHERE CLAUSE

Displays a where clause that filters the data being updated. Field is protected on the Horizontal View; it can be edited on the Vertical View.

View Data

Click to view a report of the data being changed. Data is pulled from the view for this request and is limited if a Where Clause has been applied. This icon is only available until the request is posted.

Execute

Click to run the mass change process. This process applies the Value to all rows for the selected Column Name on the data entry page. This icon is active when the other values on the page have been entered and saved.

Request Mass Change V

Request Mass Change H

Use this page to Build Mass Change Where Clause.

Field

Description

Column Name

Displays column name being updated in the target ERP system.

Value

Displays value being replaced for Column Name in the target ERP system.

Advanced Properties

Where Clause

Displays a where clause that filters the data being updated.