1 (edited by notrinos 10/03/2018 06:07:22 am)

Topic: Payroll & Human Resource Management.

I'm going to start recreate Payroll & HRM module to replace the old one which has been created for practice, from now the updates will be updated here.

SOURCE CODE: Github
DEMO

Phuong

Re: Payroll & Human Resource Management.

Sounds great.

/Joe

Re: Payroll & Human Resource Management.

There is a problem with Person Id  I have faced, when we make transactions with Payable or Receivable account for an Employee or another Person who has the same Id as that of a Supplier or Customer then in the gl trans view always appear like this https://ibb.co/c64ahv

I handle it by adding a prefix to the Employee's id in the gl function to make the Id different from Supplier.

Any Ideas ?

Post's attachments

PayrollTxn.png 47.3 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
Phuong

Re: Payroll & Human Resource Management.

Sub Ledger may be a way out.

5 (edited by notrinos 10/03/2018 06:08:06 am)

Re: Payroll & Human Resource Management.

Updated the Demo link in post #1

Phuong

Re: Payroll & Human Resource Management.

First version released with basic functions, looking forward for the feedback to make it better.

Phuong

Re: Payroll & Human Resource Management.

This looks great, notrinos. The Theme is wonderful.

Would you like to share this theme with us?

joe

Re: Payroll & Human Resource Management.

This theme is not an optimal solution for a theme Joe, I simply wrote CSS for all pages one by one so it will not work on new extensions or if there are changes in the core.
If we can figured out a way to restructuring FA to make create themes easier I will be very willing to work on a better one and share it.

Phuong

Re: Payroll & Human Resource Management.

Ok, I understand.

/Joe

Re: Payroll & Human Resource Management.

Great module!
Is the printing active in the demo, I can't find it.

Re: Payroll & Human Resource Management.

stefan wrote:

Great module!
Is the printing active in the demo, I can't find it.

I missed a step in the instruction which I wrote myself.
Thanks @stefan, updated.

Phuong

Re: Payroll & Human Resource Management.

These lines in the README.md:

- Comment out block of codes from lines 215 to 220 of "*admin/inst_module.php*".
..
..
- Uncomment lines 215-220 of "*admin/inst_module.php*".

are no longer required after this commit on 2017-12-15.

Added to the FA24extensions repo.

If your new table 0_payroll_account is intended to have just 1 record, can it not be accommodated in the 0_sys_prefs table?

Re: Payroll & Human Resource Management.

No @apmuthu, it will be incremented every time we add accounts in the Payroll Accounts page

Phuong

Re: Payroll & Human Resource Management.

@notrinos: Thanks for the info.

The table 0_salary_structure can remove the type field by using the signed nature of the amount field or if it is to be a flag, then an is_deduction field can replace it.

Was this necessary:

ALTER TABLE `0_gl_trans` ADD `payslip_no` INT(11) NOT NULL DEFAULT 0;

in the update.sql?
Could it not be looked up based on transaction date and employee code?
If the core FA table changes are avoided, it will be more portable.

15 (edited by notrinos 12/17/2017 03:59:34 pm)

Re: Payroll & Human Resource Management.

Yes, maybe is_deduction would be better, I will check soon.

About payslip_no field that's my fault when I did not refer to how to store transactions in FA schema, now to fix this will need changes a lot. I will try to improve it soon, maybe next month.

Great to see that we can now installing 3rd modules without any permission.

Phuong

Re: Payroll & Human Resource Management.

Created and attached an ERD as it stands now.

There are foreign keys such as department_id, pay_rule_id and payslip_no that have no proper linked tables for lookup.

In case the payslip_no should be the primary key, then the id field in that table (0_payslip_detail) can be removed.

There is no linkage with the account_id to any of the other FrontHRM tables.

Where is the emp_id linkage into the 0_payslip_detail table?

Gender can be an enum filed with M, F and O option set.

You can include the ERD into your codebase.

Post's attachments

FrontHRM_ERD_001.png 32.1 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: Payroll & Human Resource Management.

The current ERD updated
https://ibb.co/fMvaSG

Post's attachments

Front_HRM_ERD_001_upd.png 43 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
Phuong

Re: Payroll & Human Resource Management.

Based on suggetions of apmuthu and other FA community members the HRM module will be restructured for more portable and suitable for more form of work. It has been restructuring and hope will be released soon.

Phuong

Re: Payroll & Human Resource Management.

how long do you think it'll take?

Re: Payroll & Human Resource Management.

Early next month @Alaa

Phuong

Re: Payroll & Human Resource Management.

good-luck bro, waiting for the great news.

22 (edited by notrinos 10/03/2018 06:08:44 am)

Re: Payroll & Human Resource Management.

Restructured FrontHrm has been released:

- New tables structure without any changes to the orignal FA database.
- Monthly Salary and Daily Wages options for each Salary Scale
- Minutes based attendance input, example: 7:30, 06:15 ...

Source code
Demo

Phuong

Re: Payroll & Human Resource Management.

hello notrinos,

thanks for your nice project.

i installed it & everything is ok...but i got problem in Ledger...


when create Payment advice-------------
Accounts Payable should be decrease...so it will Debit (but it going to credit side.. actually it will be Debit, because when i created Payslip, on that time Accounts Payable GL is Credit) ACCOUNT PAYABLE INCREASING 2 TIMES NOW... ONE FOR CREATING PAYASLIP AND ANOTHER ONE FOR PAYMENT ADVICE...SO ACCOUNTS CALCULATION WILL WRONG...   

and Petty Cash/checking account should be CREDIT (now its going to debit side),  because money is going out from accounts.   


AND please tall me how to add Leave day and leave with pay / leave without pay

thanks- piash

Re: Payroll & Human Resource Management.

Hi, Phong, is your school project free?

Re: Payroll & Human Resource Management.

@stefan, it's my client's product, not free.

What a serious mistake sad
Thanks @mnhpiash for detecting. It has been fixed

Phuong