Reporting in SAGE Micropay after RPN Retrieval

SOLVED

Having an issue once you have retrieved RPNs. it seems Sage not have added any reporting function to show anything other then successful. Previous versions of Sage when importing Tax Certificates you got a option to look at - People on the file and successful - People on the file but not the payroll - People on the payroll but not on the file.

I retrieved RPNs this morning for one payroll with 179 staff and I got a message saying 174 retrieved and 5 had no RPNs. Sage have told me there is no way to find out who these 5 are other then manually going through it one by one. Surely Sage can design a report that simply tells you who these 5 people where that did not appear on the retrieval of RPNS

On my last check before the Holidays on the old system all 179 appeared now we suddenly have 5 that don't so I am sure this is something that would be helpful for many.

  • +1
    verified answer

    Hi, 

    this is something we are adding to Sage Payroll in a release later this year. In the meantime, you can create a report to compare the RPN numbers and from this you can tell who has not received an updated RPN. 

    To create this report

    • From the 'Reports' menu, select 'Report Writer'
    • From the 'Data Files' drop down select 'Employee File'
    • On the 'File' menu, select 'Fields'
    • On the pop up screen, select
      • Employee->Employee
      • Employee->Surname
      • Employee->First Name
    • Scroll down and select
      • Employee->RPN Number
      • Employee->RPN Issue Date
    • Click OK
    • Click the Process button
    • The results will be displayed. 
    • Select 'File', 'Save As' to save the report to a location of your choice. 

    If you run this report before the RPN import and again after the RPN import, you can compare the RPN numbers on the results. If the RPN number has not changed, then the employee has not received an RPN. 

    Best regards, 

    Tanya

    Sage UKI