Pension Assessment doesn't work as expected

Steps to take if the pension assessment loads, but doesn't work correctly in Sage 50 Payroll.

In rare cases, the Pension Assessment may not work as expected. This may mean employees aren't enrolled or Opt-Ins, Opt-Outs or Postponements aren't retained.

This issue can also cause the assessment to load, but with no employees.

If you need advice about any employees enrolment not being on time, contact The Pensions Regulator first.

Audit Trail Reporting

Sometimes, audit trail reporting settings can affect this. If it's already enabled, you can refresh this by turning the audit trail off then back on. To do this, follow the steps below.

 CAUTION: If you use the audit trail, follow the steps below in full to re-enable it once you've finished troubleshooting. 

1. Back up your data.
2. Go to Company then Audit Trail Settings.
3. Clear the Enable Audit Trail Reporting checkbox.
4. Select Save.
5. Close Sage 50 Payroll, then open it again and log in as normal.
6. Check if you've resolved the issue.
7. Whether or not you've resolved the issue, go to Company then Audit Trail Settings.
8. Select the Enable Audit Trail Reporting checkbox.
    NOTE: You must select this again to continue recording Audit Trail reporting.
9. Select Save.

If you:

• Fixed the issue by disabling audit trail and it's still fixed when you enabled it again, continue to process as normal
• Fixed the issue by disabling audit trail but it occurred again when you enabled it, contact Sage Technical Support
• Didn't fix the issue with the steps above, continue to the troubleshooting section

---

Troubleshooting

If the issue still occurs, follow the sections below:

Program

Delete the submission components then re-install Sage 50 Payroll.

1. Close Sage 50 Payroll.
2. Press the Windows key  + R, enter C:\Program Files (x86)\Common Files\Sage\Internet Submissions\V5, then click OK.
3. Delete the following .dll files:
    CAUTION: Close Sage 50 Payroll and log into Windows with full access before you delete these files. If you find the required folder doesn't exist, this suggests a Windows permission issue. Speak to your IT support to ensure you have full access to the folder then skip straight to re-install your software.

• • Esubs.model
  • Esubs.model.interfaces
  • Esubs.view
  • Esubs.viewmodel
  • SgEData
  • SgELauncher

Visit the download and install Sage 50 Payroll article and re-install the latest version of payroll then re-run your pension assessment. 

If this doesn't fix the issue, to identify where the issue lies, take a backup of the payroll and troubleshoot in the areas below.

Data

• Optimise the data
• Check if the Duty Start date is a future date in Pensions Module Settings 
• Test with different existing employees
• Create a new employee record and test
• Untick Audit trail reporting in Company then Audit Trail Settings
• Create a test Cost Centre and Department, and assign them to all employees (including current and historical leavers)
• Restore a backup to the previous period
• Test on a different set of live company data or a blank set of data
• Refresh your legislation tables

Environment

If the previous steps don't resolve the problem, the issue is environmental. Check the following areas:

 NOTE: For help with following these steps, contact your local IT support. 

• Enable Microsoft.Net in full
• Ensure all relevant Windows Updates are installed
• Log in as the Administrator or a user with full Administrator rights
• Log in to the PC with a different user profile
• Test on a different PC

Check the Company folder

1. Rename the Company folder, and create a new one with the same name.
2. Create a paydata folder and copy the mdb file into it.
3. Try the Pension Assessment again.

---

If the Open Company window displays a full path

To resolve this, you need to follow the steps below to delete the relevant company from the Open Company window then re-browse to the data.

Before following these steps, it's important that you back up your data.

1. Log in to any company with a truncated path in the Open Company window.
   • A truncated path starts at the company folder, for example, Company_002\Paydata\Payroll.mdb.
2. Click File then click Delete Company.
3. Select the company that has the full path in the Path to Data column, make a note of the path then click OK.
4. When prompted that this company's entry will be removed and whether you also want to permanently delete the data, click No.

   If your data is on a network, you're only prompted to remove the company from the list. To continue, click Yes.

5. Click File then click Open Company then click Browse.
6. Browse to the payroll.mdb file for the company you've removed from the list in Step 3 above then click Open.

The company reappears on the Open Company window with a truncated path and you can open it as normal.

---