Topic: How to automate salary payment


I normally add the salaries as payroll expanse in the Journal Entry, I need to automate the process every month, is there any way to this.

Re: How to automate salary payment

Probably you can try the quick entry to make it easier way.  But there is no cron job based activity in FA  as of now.

Can you show me the GL entries, I guess there Is an easier way around in entry itself.

Subscription service based on FA
HRM CRM POS batch Themes

Re: How to automate salary payment

I tried quick entries as I only have 15 employees to pay them salaries. So its OK but then when you look deeper into Payroll and how complex it gets (even for 15) then QE are not meant for that. QE is limited on the Base amount and other calculations are linked to it.. One cant work on a reduced or increased Base for a second iteration. The Remainder is the end Result..One cant go further after the Remainder.
@notrinos might have some ideas for this question as he is developing an HRM module that includes Payroll..but still too much for a very small employee sized company...
I was thinking of Import Transactions or Import Multiple Journal Entries as I have the data into a spreadsheet.

Ideas are welcomed.

Re: How to automate salary payment

@rafat  I know this is not a place for this post to be but I hope somebody can give a answer.

I have alter my payment table to add 2 extra column, check_no, source_ref to process my bank payments as all my bank payment require a checks, and cash payment voucher(source_ref). Now when I want to process a payment I get this error below:

What I understand is that the number of data being sent in the database does not correspond to the field required. Would you please tell me where I should add the 2 columns from UI?  I also wanted to put validation to check if a check no is already inserted to refuse duplicates.

Great Thanks!

array_combine(): Both parameters should have an equal number of elements in file: /var/www/html/fms/gl/includes/db/ at line 394DATABASE ERROR : Cannot insert a source bank transaction
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for computer services, 1, '2021-01-07', '-10500', '0', 'Cedrick ')' at line 2
sql that failed was : INSERT INTO bank_trans (type, trans_no, bank_act, ref,check_no, source_ref, trans_date, amount, person_type_id, person_id) VALUES (1, 130, '3', '001/2021', payment for computer services, 1, '2021-01-07', '-10500', '0', 'Cedrick ')

Re: How to automate salary payment


Sorry I don't have a clue of what you are talking about. You are very right in stating that this thread is not the place for your new query. You might need to start a new thread.

Maybe someone else in the forum can answer you.

I am confident we  do have good guys who can shed a light on this.. but not clue.

6 (edited by AmburdeLey 08/11/2022 08:38:18 am)

Re: How to automate salary payment

My company has more than 50 employees, but only 1 manager is responsible for calculating their salaries. Employers need to record what their employees received and how much. It's necessary for the HR department. Creating payroll forms for your business can now be simplified, and the best part is that you can create payroll online. ThePayStubs forum  often help me quickly create payroll for my employees. As a leader, I have to control this process, no matter where I am. I must optimize the operation of my business, even if this requires investments. In this way, I guarantee honest cooperation between myself and my employees.

Re: How to automate salary payment

Journal entry method is to post the payouts.

To calculate the salary you have to use payroll calculations.

Subscription service based on FA
HRM CRM POS batch Themes