Is 507 records what you would expect?  If not, then I would revisit your records to update.  Make sure you have a SQL backup prior to doing any mass update.  In records to update, if you are unsure about the last condition with U_prolic being blank, if the values you are looking for are T/F, you could do ... and tkpe.U_proflic<>.T.

Who will receive the mass update?  Anyone that is not terminate has does not have T in P/L Required.

New value will return a value of F if above conditions are met.

If you are still unsure, you can contact Sage HRMS Support.

J-

The update looks correct. One thing to note is that the custom detail table will only have records for employees who have data on a custom screen. In other words that employee count of 507 are all the employees who meet the criteria that you set AND have a record in the custom detail table. So you could also have many employees who would meet those criteria, but because they don't have any custom data they will not be mass updated. In order to catch all employees, you would need to create a record in the custom detail table for them by manually going into the screen and entering No/False for that field or simply give me a call or email and I can help you out.

Thanks to both of you!  The mass update did work correctly in the live environment after all.