Topic: How to automate salary payment
Hello
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.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Setup → How to automate salary payment
Hello
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.
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.
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.
@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/gl_db_banking.inc 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 ')
@cedricktshiyoy
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 me...no clue.
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 https://www.thepaystubs.com/ 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.
Journal entry method is to post the payouts.
To calculate the salary you have to use payroll calculations.
FrontAccounting forum → Setup → How to automate salary payment
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.