I need to update data in ADM (Web DP or Master Data). How do I do it in an efficient manner?
Add the steps involved:
Open the ADM table and use the filter to show all rows that have to be updated
|
highlight the rows you want to update (same as with Excel, use the shift key)
|
hit the 
button. It opens a dialog window
|
fields with value: all selected rows have the same value for that field
 |
blank fields: at least one row shows another value for that field
|
You want to update MatField 1 → enter the target value in that field. Once you do, the checkbox is activated.
|
MatField1 is updated.
|
The above works well when updating massive number of records with one value. E.g. setting all selected record to MTO stock policy. For more complex mass changes, you want to touch base with Ion and give them a file to upload. Find a list of ADM tables that have been made MASS-change ready:
Open the tables, filter on the data you want to update, and hit |
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
|
. It export the selected data into an Excel spreadsheet you can update and send over to Ion.