Questions & Answers:
Why couldn't the policy of overtime and deduction run usually in the Payroll Preparation?
In Payroll Preparation, there are some modules that need to do job run because of the load of data.
1. deduction
2. overtime
3. missing swipe
If you want to test deduction, overtime, and missing swipe, you can use the following queries to do job run.
--EXEC dbo.Web_Payroll_Preperation_Auto_Calculate_Bonus
EXEC dbo.Web_Payroll_Preperation_Auto_Calculate_Allowance
EXEC dbo.Web_Payroll_Preperation_AutoCalculate_Deduction
EXEC dbo.Web_Payroll_Preperation_AutoCalculate_Overtime
--EXEC dbo.Web_Payroll_Preperation_AutoCalculate_Deposit
EXEC dbo.AutoSchedule_Calculate_SSB
EXEC dbo.AutoSchedule_Calculate_TAX
--Run at every end of the month ONCE
--EXEC Web_Payroll_Preperation_AutoCalculate_Missing_Swipe (run at last day of the month)