Hi Experts,
My Client Requirement is as below mentioned:
Client have divided travel cities into 2 types:
1. X - Cities (Delhi, Mumbai, Chennai & Kolkata)
2. Y - Cities (Other Cities)
And DA rates will be different for X - Cities & Y - Cities.
Daily Allowance Calculation:
DA should be calculated based on the below rules:
Not exceeding 6 hours - 25%
Exceeding 6 hours but less than 12 hours - 50%
Exceeding 12 hours - 100%
Meals per Diem has been setup for the above rules.
Now system is calculating DA including journey time/period but as per the client requirement for journey period we need to pay only Y - cities DA rate amount.
For Ex: Kindly find the below scenario for better understanding,
TR wherein DA is calculated on total travel period ie for 2 days but we have to pay "Y" cities rate for journey period which is for Half a day
Calculation is as below
Departure | Arrival -Delhi | Total travel period |
18-04-2016 16:05 | 20-04-2016 13:35 | 45:30 |
Departure | Arrival | Journey period |
18-04-2016 16:05 | 18-04-2016 21:35 | 5:30 |
20-04-2016 08:05 | 20-04-2016 13:35 | 5:30 |
| | 11:00 |
Here total journey is 45:30 hrs from which we have to deduct 12:00 hrs ie half a day as travel time (Rs.840*0.5)-"Y" city rate
Net Hrs remaining is 33:30 hrs which comes to 1.5 days DA (1.5*900)-"X" city rate
Total DA payable is Rs.420+1350=Rs.1770 & not Rs.1800/-
NOTE: X - City DA rate 900 per day, Y - city DA rate 840
Regards,
Venkat Polisetty
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.