Home/ Troubleshooting/ Employee Not Found on Master File

Employee Not Found on Master File

Problem

You receive the following error message when working with an employee:

Employee not found on master file

This error typically occurs when trying to access an employee's records during payroll processing or when generating reports.

Cause

This error indicates a mismatch between ProPay's Master file and Detail file. The employee exists in the Detail file (which contains paycheck history) but their corresponding record is missing from the Master file (which contains employee information like name, address, and Social Security number).

Common causes include:

  • Database corruption - Power outages or system crashes during data saves
  • Incomplete data import - Employee data was partially imported from another system
  • Index file corruption - Index files became corrupted and are not reading data correctly
  • Improper program shutdown - ProPay was closed unexpectedly while processing data

Solution

Use the Master File and Detail File Integrity utility to automatically repair the missing record.

Step 1: Run the file integrity check

  1. Go to Client Functions > Miscellaneous > File Integrity > Master File & Detail File Integrity on the ProPay Main Menu.
  2. Select the client that has the problem from the list.
  3. Click OK to run the integrity check.

The routine will automatically detect the missing employee record in the Master file and add it back. The new Master file record will be created using the Employee Number, Name, and Pay Period from the Detail file.

Step 2: Complete the employee record

After the integrity check recreates the missing record, you need to fill in the additional employee information:

  1. Select the employer from the client list on the ProPay Main Menu.
  2. Go to Employees > Add or Change on the Payroll Main Menu.
  3. Find and select the employee whose record was just recreated.
  4. Edit the employee record and fill in the missing information:
    • Address
    • Social Security Number
    • Tax withholding settings
    • Any other required fields

    Step 3: Verify the fix

    1. Return to the area where the error originally occurred.
    2. Confirm that the employee record is now accessible without errors.
    3. Review any reports or paychecks that were affected.

    Prevention

    To minimize the risk of Master file and Detail file mismatches:

    1. Always exit ProPay properly - Use the menu to exit rather than closing the window or shutting down unexpectedly
    2. Use a UPS (Uninterruptible Power Supply) - Protect against power outages during data processing
    3. Run regular backups - Maintain current backups of your ProPay data
    4. Perform periodic maintenance - Run file integrity checks and reindex files quarterly

    Related Topics

    ← Back to Index