Setting up the work days in a month

Hi,

I was feeding in my employee details and when I got to the point of making a salary slip i came across a fundamental error,

Here’s how i went about the process:

Created Employee,
Set up holiday list,
Assigned holiday list to emplyee,
Created Salary Structure,

While making the salary slip i would have expected that the No. of days in the month would be after deducting the weekly off days (i.e Month-weekly off = working days - LWP = Net Payable days),

The software however takes the total # of days which would affect the amount that is deducted due to leave without pay,

Take for example in December there are 31 days,

We have weekly offs on Sunday which is not considered while framing the salary,

Total No. of sundays = 5

Total No. of working days = 26

Assume salary = 20000 for the month

Value per day according to working days = 769.23

Value per day according to total days = 645.16

In case a member of staff were to miss 2 days this would be their effective salary as per :

Working Days = 20000 - 1538.46 = 18461.54

Total Days = 20000 - 1290.32 = 18709.68

The Salary which is usually fixed is for the Total no. of working days,

However the software is unable to make to differentiation ,

I would suggest setting the no. of working days by taking :

Total no. of days and reducing the weekly off days and public holidays from it,

Regards,

http://stackoverflow.com/questions/2224742/business-days-in-python

Found an article that might be of help

On Tuesday, December 4, 2012 4:21:17 PM UTC+5:30, Salmandaw wrote:

Hi,

I was feeding in my employee details and when I got to the point of making a salary slip i came across a fundamental error,

Here’s how i went about the process:

Created Employee,
Set up holiday list,
Assigned holiday list to emplyee,
Created Salary Structure,

While making the salary slip i would have expected that the No. of days in the month would be after deducting the weekly off days (i.e Month-weekly off = working days - LWP = Net Payable days),

The software however takes the total # of days which would affect the amount that is deducted due to leave without pay,

Take for example in December there are 31 days,

We have weekly offs on Sunday which is not considered while framing the salary,

Total No. of sundays = 5

Total No. of working days = 26

Assume salary = 20000 for the month

Value per day according to working days = 769.23

Value per day according to total days = 645.16

In case a member of staff were to miss 2 days this would be their effective salary as per :

Working Days = 20000 - 1538.46 = 18461.54

Total Days = 20000 - 1290.32 = 18709.68

The Salary which is usually fixed is for the Total no. of working days,

However the software is unable to make to differentiation ,

I would suggest setting the no. of working days by taking :

Total no. of days and reducing the weekly off days and public holidays from it,

Regards,

Dear Salman,

Welcome back :slight_smile:

Thanks for indicating this issue. We didn’t validate this scenario considering compensatory offs. Assuming employee work on weekly offs!! We shall make necessary changes in near future and update you here.



Thanks and Regards,

Umair Sayyed
um…@erpnext.com
www.erpnext.com



On Tue, Dec 4, 2012 at 4:21 PM, Salmandaw <sa…@gmail.com> wrote:

Hi,

I was feeding in my employee details and when I got to the point of making a salary slip i came across a fundamental error,

Here’s how i went about the process:

Created Employee,
Set up holiday list,

Assigned holiday list to emplyee,
Created Salary Structure,

While making the salary slip i would have expected that the No. of days in the month would be after deducting the weekly off days (i.e Month-weekly off = working days - LWP = Net Payable days),


The software however takes the total # of days which would affect the amount that is deducted due to leave without pay,

Take for example in December there are 31 days,

We have weekly offs on Sunday which is not considered while framing the salary,


Total No. of sundays = 5

Total No. of working days = 26

Assume salary = 20000 for the month

Value per day according to working days = 769.23

Value per day according to total days = 645.16


In case a member of staff were to miss 2 days this would be their effective salary as per :

Working Days = 20000 - 1538.46 = 18461.54

Total Days = 20000 - 1290.32 = 18709.68

The Salary which is usually fixed is for the Total no. of working days,


However the software is unable to make to differentiation ,

I would suggest setting the no. of working days by taking :

Total no. of days and reducing the weekly off days and public holidays from it,


Regards,







Hi…
I am experiencing a similar problem with creating a salary slip. The software considers the total number of days in the month even if the holiday list is included. But since we make full monthly payments I thought I would simply remove the number of working days and payment days from the salary slip. I am able to remove the working and payment days form the top of the page but am unable to remove the ones from the bottom of the page. Please advice.!!

Thanks,
Akilesh

Was anything ever done about this?