Fit notes are sent via the batch job named Absence Fit Note. The data source in the batch job settings does not filter down to records where workflow status = 1 (live).
To resolve, the batch job data source requires a small amendment. Follow the steps below to apply the fix for this issue to the batch job.
In the Admin Tool, click Batch Jobs.
Double-click on Absence Fit Note.
Next to the Data Source field, click Change.
Log in.
Copy the below SQL:
Select Absence.History.[Absence Number], Absence.History.[Person Number], Absence.History.[Absence End Date], Absence.GetSelfCertDays(Absence.History.[Person Number]) As [Self Certified Days], Absence.History.[Absence Start Date], Absence.Types.[Absence Type Group], Sum(Absence.Days.Days) As [Total Days So Far], Absence.Statements.[Statement Date], Absence.History.Workflow From Absence.History Inner Join Absence.Types On Absence.History.[Absence Type] = Absence.Types.[Absence Type] Inner Join Absence.Days On Absence.History.[Absence Number] = Absence.Days.[Absence Number] Left Join Absence.Statements On Absence.History.[Absence Number] = Absence.Statements.[Absence Number] Where Absence.Days.[Absence Date] <= GetDate() Group By Absence.History.[Absence Number], Absence.History.[Person Number], Absence.History.[Absence End Date], Absence.GetSelfCertDays(Absence.History.[Person Number]), Absence.History.[Absence Start Date], Absence.Types.[Absence Type Group], Absence.Statements.[Statement Date], Absence.History.Workflow Having Absence.Types.[Absence Type Group] = N'Sickness' And Sum(Absence.Days.Days) > Absence.GetSelfCertDays(Absence.History.[Person Number]) And Absence.Statements.[Statement Date] Is Null And Absence.History.Workflow = 1
In the top left of the open Data Source window, click Options, Paste SQL from clipboard.
Click OK, then OK again.