How to update leave balance to carry forward

Below is a sample of 2 queries. The last one will update the balance to carry forward but you must run the 1st one to check the leave unkid no

select * from lvleavebalance_tran where isvoid = 0 and leavetypeunkid = 1

Optionally you can check leave unkid no by running select * from tran_TZ_Jan2020_Dec2020..lvleavetype_master 

where TZ is the company code and remember to keep FY as what is suppose to be.

**Update lvleavebalance_tran set isnoaction= 1 , cfamount = 0 where isvoid = 0 and leavetypeunkid = 1**