cancel
Showing results for 
Search instead for 
Did you mean: 

time management

shikha02
Explorer
0 Kudos

Client requirement for Leave Accrual

Client has below formula for monthly Leave Accrual:

Actual Attendance (Working Days) = No. of days in a month – (Public Holiday + Weekend + LOP)/16

Scenario: January 2023

1. Let’s take the example of January 2023

Total days = 31 days

Public Holiday = 2 days

Weekend = 9 days

LOP = 1 days

Total Attendance day = 19 days

Leave Accrual = 19/16 = 1.18 days

**16 is constant value for each month

1 days leave would be credited and 0.25 will be carry forward in next month.

Option A (As per Client requirement): 1 days leave would be credited and 0.18 will be carry forward in next month.

Option B (If option A is not possible): 1.18 should be accrued, but at front end it should display as absolute value ‘1’.

Scenario: Feb 2023

Let’s take the example of Feb 2023

Total days = 28 days

Public Holiday = 0 days

Weekend = 8 days

LOP = 0 days

Total Attendance day = 20 days

Leave Accrual = 20/16 = 1.25 days

Option A (As per Client requirement): (1.25+0.18) = 1.43 days. 1 day leave would be credited and 0.43 will be carry forward in next month.

Option B (If option A is not possible): 1.25 day should be accrued, but at front end it should display as absolute value ‘1’. And total leave should be 1.18 +1.25 = 2.43 days (at backend) and display as absolute value ‘2’.

Accepted Solutions (0)

Answers (0)