Deleting Records
Deleting records is an important operation from the data consistency point of view. It has to be done with caution. In order to delete a record from a master company, the record has to be deleted from all the receiver companies. Even though the deletion is complex, it can be carried out solely in the master company.
Deleting a Record
Records can be deleted directly from a page in the master company. For instance, deleting a vendor from the Vendors list page. For records that have been replicated, MDMS issues a series of web service calls to all the companies that have received the record and tries to delete the record remotely. If the process is completed successfully, the record is deleted in the master company as well.
Note
Only MDMS Super Users are authorized to delete replicated records. Records that are not replicated can be deleted when the Allow Deleting Before Replication option is set up on the MDMS Setup page.
To delete an already replicated record:
Go to the record's page.
Select the Delete action.
Confirm a message in the dialog window saying: "The system will now try to delete current record in all companies it was sent to. Do you want to continue?"
Review the list of receiver deletion attempts and their statuses and then press Close.
Important
Direct deletion of a record executes the OnDelete trigger in the receiver companies.
Deleting Records with MDMS Records Management
The MDMS Records Management page allows deleting multiple records at once.
To delete already replicated records with MDMS Records Management:
Choose the icon, enter MDMS Records Management, and then select a related link.
Fill in the Replicated Table Name field.
Select the Calculate Records action to calculate the worksheet lines.
Selected records manually or using the Select All action.
Select the Delete Records to delete the selected records.
Review the list of receiver deletion attempts and their statuses and then press Close:
- Record ID - Specifies a Record ID of a managed record.
- Receiver No. - Specifies the receiver of a managed record. Empty values indicate master company records.
- Status - Specifies the record management operation status. The field contains Success, if a record has been deleted from a receiver or Error, if something has gone wrong.
- Error Text - Specifies the error message received from a receiver company or current master.
- Selected - Specifies that a line or multiple lines are selected in order to perform actions on them (deleting, checking record status).
Important
Executing the OnDelete trigger in the receiver companies is optional and can be set on the MDMS Records Management page. The trigger is never run for the master company records, if the operation is performed on the MDMS Records Management page.
Note
Record synchronization entries of the Delete type are created after the deletion process.