Merge Legacy Employee Records
  • 09 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Merge Legacy Employee Records

  • Dark
    Light
  • PDF

Article summary

Employee records and the Employees page in Smart Ops are being updated throughout Q3 and Q4 of 2024. This article is for the legacy version of the employee record. For the updated version of the employee record, please refer the Merge Employee Records article.

It is common for Employees to work at multiple Locations and, therefore, have multiple/duplicate Employee records imported from multiple POS systems. These records must be merged into a single master record for correct Employee identification throughout R365.

Employees can be Merged individually on the Employee Record or in bulk via the Import Tool


Employee App Access Lookup

A screenshot of a computer  Description automatically generated

Before beginning a merge of Employee records, ensure to look up all of the Employee records for that Employee and find the record that has 'App Access'. The other Employee records should then be merged into this record.

  • If the other Employee records are not merged into the record with 'App Access', the link between the User Record and the Employee record will be broken.


Merge on the Employee Record

Smart Ops

Follow these steps to Merge Employees:

  1. Navigate to the Employees page

  2. Click on the desired Employee to open the Employee Record sidesheet

  3. Click on 'Merge' in the header

     

  4. Type into the search field to search for the appropriate Employee to Merge with

     A screenshot of a computer  Description automatically generated

  5. Select the appropriate employee from the drop-down menu

  6. Click  Merge to merge the Employees, or to close without merging.

Classic

A screenshot of a computer  Description automatically generated

Open the Classic Employee Record that will be merged in to a different record. Hover over the 'Save' menu and select 'Merge'.

A screenshot of a computer  Description automatically generated

The 'Merge into Selected Employee' prompt will load. Locate and select the destination Employee record and then click 'Merge'. The current record will be merged in to the destination record.

  • Information located on the 'General' tab in the original record will not be transferred to the destination record. If there is any information on the 'General' tab that needs to be transferred, perform the manual transfer prior to merging the records

Import Tool

To merge Employees in bulk the Import Tool is used. 

Important Note: The majority of records that reside in Restaurant365 can be updated via the Import Tool. When performing bulk updates, the Import Tool typically references a record based off the 'Name' value on the record. When making updates to Employee records, the 'EmployeeId' value is the key mapping value, as opposed to the 'Name' value. 

Export the Employee List to an Excel file. Open the file and locate the 'EmployeeId' column for each Employee record that will be merged via Import. Open the Import Tool and select 'Employee Merge' and 'Create New'

  • Employee Merge and Employee Updates are two separate tasks that use different options on the Import Tool.

A screenshot of a computer  Description automatically generated

Click 'Download Template' to download the Employee Merge template.

A close-up of a grid  Description automatically generated

Populate the 'Old' column with the original 'EmployeeId' and the 'Merge Into Employee' column with the destination 'EmployeeId'.

A screenshot of a computer  Description automatically generated

Save the template as a CSV then upload in to the Import Tool and proceed through the Import Tool steps to complete the Bulk Employee Merge.


Was this article helpful?