Salary Structure base on Hour Work

[iqbalzahir]

So basically i don’t have choice to not use the timesheet?

[vrms]

@Pawan

how are you planning to capture the number of hours worked by employee

there is something called “Attendance” if I am not mistaken. Does that not record ‘punch in’, ‘punch out’ and likewise hours worked as well?

EDIT: no, it doesn’t. Attendance seems to record only complete days. Not sure what for exactly though. it doesn’t seem capable of creating a salary slip or likewise from it.

[iqbalzahir]

Okay i think it is not possible for calculating by hour. But how to calculate by day. which means by status “Present” in the attendance doctype. i want to generate the salary structure base on status “Present”.

Lets say day = 100 USD
Salary slip = 100 USD + Present in the month.

For simple word, employee’s salary is based on attendance

Im sorry for my english. its really bad. but please help me @vrms

[vrms]

sorry, I have looked at Attendance for the first time in my live. For now I think you can not calculate the salary slip from the Attendance but only from the Timesheet I have so far only created Invoices from it, so I am not familiar with the exact procedure for creating salary slips from Timesheets

I think you may just have to play with it and figure out how that works. Probably similar to creating a Sales Invoice from a Timesheet

One thing I have seen is that you have to assign a Default Holiday List for an Employee before the system allows to use Make Salary Slip from a Timesheet. Also the Timesheet has to be in state Committed before the Make Salary Slip option even appears (on the top right of the Timesheet)

[iqbalzahir]

yeah! i think so. because i just figure out how to create condition that employee must attend to work for 8 hours/day by customizing the form.

About the Default Holiday List is already fix. but thank you for your reply.

[LifeP]

@iqbalzahir check if this is what you are after?

Attendance and overtime?

I’ve gone through a lot of threads/issues here and on github relating to timesheets, timelogs, over-time & attendance. There have been many requests over the years from end-users while developers have their own valid point of duplicating the same thing. These are some points that I think need discussion and thought by developers - Are timelogs efficient for storing daily data for say 100-200 workers and above? Data entry needs to be easier. From what I understand this would solve most of …

[SOLOSOFT]

as @LifeP already posted before we should relook at the timesheet/attendance features there is a lots of thinkgs still missing the basic ones.

can anyone raise a bounty for that features we can contribute. right guys?

regards

[iqbalzahir]

Yes i’m looking something like that. Currently i try by myself to link the attendance with the salary so that i wil get to generate salary base on attendance that i marked.

[LifeP]

Here’s one approach to the solution - Aditya Duggal - Deep ERPNext Customizations at Rohit Industries Group - YouTube
@SOLOSOFT let’s list out feature list and ways to integrate it first?

[vrms]

@SOLOSOFT

can anyone raise a bounty for that features we can contribute. right guys?

@SOLOSOFT anybody can create a bounty. Ideal procedure in my eyes would be to

1. form a group of interested parties
2. discuss requirements in detail
3. write them down in a very structured manner as an issue on github
4. create a bounty on that github issue and then
5. relentlessly advertise your bounty (forum, facebook, linkedin … anywhere)

whoever will satisfy your request and deliver the code will be able to pocket the funds. That may be the frappe team or anybody else. If you want me to guide you through such a procedure, feel free to get in touch.

…

No 1 quality you need for such an endeavor in my eyes is to being consistent and aggressively advertise, advertise, advertise … It’s pretty easy to get suggestions and opinions on a matter, much harder to get anyone to pull out cash for such.

[vrms]

I just got aware that seem to be plans to establish an ERPNext specific bountysystem on the ERPNext Foundation website. depending on the proceeding of this you can decide where to put your bounty when you’re ready

[Luesak_Luesukprasert]

I support the idea presented by @LifeP. We need to be able to record attendance with time. Any biometric or time attendance system nowadays will have both a date and a time. Leaving office for x hours is a normal thing. But leaving the office for 0.25days is not normal.

Kim

[LifeP]

This issue seems to be gaining popularity.
@adityaduggal From the talk last year it seems that majority of points were addressed by you. I’ve tried to generalize the system below. Can you please help us with this?

@LifeP

Enable Entry and exit time-stamps for all employees. Fill these directly into time-logs, (with option to split time lengths for work done as in time log, if we really want to merge those two. Data entry could be automated by importing timestamps from csv files. This way everyone can continue to use whatever attendance machines they are using.)

Define shift timings along with holiday list for employees.

Define overtime payment rate.
Set rules for minimum hours for half day/ attendance etc.
Calculate overtime hours. Then do salary calculations for overtime and mark attendance.
–Scenario A) Employee doesn’t get paid for overtime, Just attendance. –>Set OT pay rate to zero.
–Scenario B) Employee get’s paid per hour only. –>Simply set shift to zero hours. Paid overtime rate only.
– Scenario C) Employee paid attendance+overtime –> This is the basic scenario what the above system is defined for.

I think this could really make the erpnext attendance and HR system really robust without duplicating code, like for civil contracting and projects, etc.

As for merging time logs with attendance. The workflow should be -

1. Mark attendance (time in and time out).
2. Then enter work done between those times (time log as is)
3. Report idle time/ billed time etc. in percentage.

Looking forward to your experiences and feedback on the above.

[Luesak_Luesukprasert]

Please. ERPNext dev team. Please implement this feature. It’s very important!

[MaysaaSafadi]

Hi all,
I’d like to inform you that I implement this feature.

[LifeP]

That is awesome!
Would you be able to send a pull request?

[MaysaaSafadi]

I will do

[Nader_Adel1]

Dears

Any update here ??

[yousef_wazer]

hello maysaa, can we get connected to tell me about how you made it ?

[megha007]

how can I use this?