Two employees with the same advice number in Payroll

We had an internal connectivity issue while direct deposit advices were printing and there are two employees with the same advice number, but only one of them is showing in Manual Check Reconciliation. 

• Munis
• Payroll Start and Status
• Print Payroll Advices
• Manual Check Reconciliation
• SQL

Contact Payroll Support as a connection to the Server to run SQL scripts will be necessary. 

1. Go to Manual Check Reconciliation (Payroll>End of Period>Check Reconciliation>Manual Check Reconciliation)
2. Search for the duplicated advice number.
   1. The employee not showing a record will need to have their Advice number set to 0 via SQL.
   2. Once the advice is 0, the Print Payroll Advices step will need to be set to Green (Not completed) in SQL.
3. Once Print Payroll Advices has been set to Not completed, go into the Print Payroll Advices step (Payroll>Payroll Processing>Payroll Start and Status. Click Print Payroll Advices. Confirm active warrant prompt)
   1. One advice should be showing left to print. 
4. Click Change if necessary to update the Starting check number to the correct next starting Advice number. 
5. Click Print checks/adv in the toolbar and print like you typically would or select the Save option to save to the Spool directory. 
6. Go back into Manual Check Reconciliation (Payroll>End of Period>Check Reconciliation>Manual Check Reconciliation) 
7. Search for the employee and new advice number to confirm the record created.