Bulk Update Email Address used for Pay Slips with Import Scenario.

This page is for MYOB Advanced consultants

Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.

This knowledgebase article shows you how to bulk update email addresses that are used for payslip for employees using import scenario.

Build 2021.117.400.6951 [21.117.0037] onward.

Employees Email address are set up with their work Email address under Contact Info, but the employees want Payslips to be emailed to a different email address. 

This can be done individually by unselecting the ‘Use default email address’ option under Settings in the Pay Details (MPPP2310) and manually put in the personal Email address or in bulk using Import Scenario.

1. Set up an excel .xlsx file with the two columns: EmployeeID and Email address. Fill in the details as required.
   

   

2. In Data Providers (SM206015), Create a new Data Provider and set up the following fields.
   

   

3. In Import Scenarios (SM206025), Create a new Import Scenario and set up based on the following:
   

   

4. In Import by Scenario (SM206036), you can then Prepare & Import the data.
   

   

5. Check in Pay Details (MPPP2310) to make sure that records are updated correctly.
   

   

Attached sample import scenario and data file for your reference MPPP2310-Paydetails.xml, PayslipEmail.xlsx