Leave Template and Leave Process

Steps that you need to do:
Step 1: Create a Template
Step 2: Create Leave through Leave Master and map it with Template
Step 3: Modify the template as shown in video.
Step 4: Modify mstemployeeotherdetails table: In this table you need to enter the template ID and the date
Query 1: select fk_temp_id,tempassign_date,* from mstempotherdetails
Query 2: update mstempotherdetails set fk_temp_id='TestTemp', tempassign_date='1 apr 2010' where fk_emp_code in
(
'1013',
'1025',
'1048'
)

Step 5: Trnempleaveassign
select * from trnempleaveassign
If the employee has balance then insert the balance of the employee (here only those leaves will appear which are credited every month)