Scenario 18. Payroll Calculation Functions
Step 1. Payroll calculation functions for elements setup
Path: Administration / Payroll Calculation Function
Description of payroll functions’ operation
| Function No. | Parameters passed to the function | Value returned by the function | Comments |
|---|---|---|---|
| 220 | 1) Table record 17415 "Payroll Document Line". 2) Base amount code from table 17459 "Payroll Document Line Calculation". 3) Amount type (Payroll Amount, Taxable Amount, Corr. Amount) for tax.”5) If it is necessary to update the “Tax deduction code” field in the line of the payroll document.6) Calculate for an employee or person | The function returns the amount from the Payroll Amount” field from the lines of the current document. Filters are applied based on the settings of table 17409 “Base payroll amount”. | Income indicator for the 1DF report. Indicated on the payroll element card. |
| 247 | 1) Table record 17415 "Payroll Document Line". 2) Code of the base amount from table 17459 "Payroll Document Line Calculation." | The function returns the amount from the Payroll Amount” field from the lines of table 17418 “Payroll Ledger Entry”. Filters: by employee code, by line of the payroll document and by settings from table 17409 “Base payroll amount”. | |
| 249 | Calculates the amount by line of the payroll range. If the “For Benefit” setting is enabled, it will take the amount from the Employee ledger entry. Returns the weighted average for the year. | ||
| 252 | Returns the minimum value of the range (first line). Filter by range code, element code, period (gender and age of the employee from the setup). | ||
| 253 | Returns the maximum value of the range (first line). Filter by range code, element code, period (gender and age of the employee from the setup). | ||
| 255 | Returns the quantity. Filter by range code, element code, period (gender and age of the employee from the setup). | ||
| 261 | Payroll amount for employee payroll entries, for an element from the beginning of the year to the current period. | ||
| 263 | Taxable amount for employee payroll entries, element, posting type, from the beginning of the year to the current period. | ||
| 271 | Finds the latest salary limit of the “USC Limit” type with a filter up to the current period (i.e., the current one). | ||
| 2002 | 1) Table record 17415 “Payroll Document Line”. 2) “Corr. amount" from the document line. | The search is carried out using table 17411 Payroll range line”. Filters by employee gender, birthday, disability, period code from the payroll range header. If the directory code is filled in, the document line value is updated. The function returns “Tax amount” + (“Corr. amount” (from the document line) – “Extra amount”) * “Tax rate” / 100. | |
| 2005 | 1) Table record 17415 “Payroll document line.” | Returns the payroll amount from the beginning of the year. | |
| 2036 | Payroll document line | Personal income tax amount from the beginning of the year. Returns Corr. amount by filters: employee, element type, posting type, payroll period. | |
| 2070 | Payroll document line | Vendor. Returns the original balance (Balance (LCY)). With selection by period up to the start date. | |
| 2100 | NUMBER OF HOURS IN TIMESHEET of the employee for the time activity group code from the calculation setup. Calculation for period code. | ||
| 2101 | NUMBER OF DAYS IN TIMESHEET of the employee for the time activity group code for the calculation setup. Calculation for period code. | ||
| 2102 | Number of calendar days in the current period. | ||
| 2103 | Number of working days in a year for a calendar from a line for a period. | ||
| 2104 | Number of working days for the calendar from the line for the period. | ||
| 2105 | Number of working hours for calendar from the line of the period. | ||
| 2106 | Number of working hours per year for calendar from the line of the period. | ||
| 2107 | The number of calendar days in the minimum interval between the start date and the end date or period. | ||
| 2108 | The number of working days in the minimum interval between the start date and the end date or period. | ||
| 2110 | Fills in the lines in tables 17431 “Line 33 of the payroll document” and 17433 “Payroll period 33”. | ||
| 2111 | Finds the setting for the sick leave type of this line, the filter to the start date of the line (employee entries) returns “Max. Average earnings”. | ||
| 2112 | Finds the setting for the sick leave type of this line, the filter to the start date of the line (employee entry) returns “Max. Accrual amount”, using a filter by employee’s length of service. | ||
| 2113 | The amount of wages for the past period. For elements from the “Payroll element code by days, hours, amount, rate” setup. | ||
| 2114 | NUMBER OF CALENDAR DAYS IN THE CALENDAR PERIOD. | ||
| 2220 | Returns the amount of base salary for a period. | ||
| 2221 | Returns the amount of bonuses based on base salary. | ||
| 2230 | 1) Table record 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time activity group in table 17459 “Payroll Document Line Calculation”. | The “Planned Hours” and “Actual Hours” fields are updated on the document line. The function returns "Amount" (from table 17413 "Employee Ledger Entry") * "Actual Hours" (from the document line) / "Planned Hours" (from the document line). | |
| 2232 | 1) Table record 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time activity group in table 17459 “Payroll Document Line Calculation”. | The function returns “Amount” (from table 17413 “Employee Ledger Entry”) * hours worked/planned hours. Filters by period, employee code and element code (from “HR and Payroll Setup”, “Payroll Element Code by Hour” + “Element Code for Payroll Amount”). | |
| 2239 | Table record 17415 "Payroll Document Line". | The function returns “Amount” (from table 17413 “Employee Ledger Entry”) * hours worked/planned hours. Filters by period, employee code and element code (from the document line). | |
| 2240 | 1) Table record 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time activity group in table 17459 “Payroll Document Line Calculation”. | The "Planned Days" and "Actual Days" fields are updated in the document line. The function returns "Amount" (from table 17413 "Employee Ledger Entry") * "Actual days" (from the document line) / "Planned days" (from the document line). | |
| 2241 | Payroll document line, time activity group | Returns a monthly bonus based on salary and hours for a time group. | |
| 2242 | 1) Table enrecordtry 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time activity group in table 17459 "Payroll Document Line Calculation". The function returns “Amount” (in table 17413 “Employee Ledger Entry” * days worked/planned days. Filters by period, employee code and element code (by “HR and Payroll setup” “Payroll Element Code by Day” + “Element Code for Salary by Amount”). | ||
| 2300 | Calculates the number of years from the date of hiring to the Working date, does not return 0 if the length of service is less than 5. | ||
| 2301 | Searches the table Labor Contract (17360) for a Labor contract: returns 1 if the Type is Civil contract, 0 – if Labor Contract. | ||
| 21094000 | Finds the payroll amount from the Employee Ledger Entry (Employee Ledger Entry (17413)) on the "Start Date" using a document from the line. | ||
| 21094001 | Adds payroll amounts from the Start Date and End Date and divides by the number of such entries, reads payroll amounts as a function 21094000, takes the date from the working days of this period, from the calendar. | ||
| 21094002 | Employee payroll document line, current start date | Returns the average salary as of a date. | |
| 21094003 | Employee payroll document line, current start date | Returns the amount of extra payments as of a date. | |
| 21094004 | Employee payroll document line, current start date | Sum of functions 21094002 and 21094003. | |
| 21094005 | Finds work dates according to the work record (Employee Job Entry (17363)) in the period (start date, end date) and counts the number of working days according to the calendar. | ||
| 21094006 | Table record 17415 "Payroll Document Line". | The function returns the "Average monthly number of calendar days" (from table 17390 "Sick Leave Setup"). Looks for the current setting on the document line's start date. | |
| 21094007 | 1) Period code of the document start date from the document line. 2) Data type 'MROT, FSI'. | The function returns the amount from table 17397 "Salary Limits". Searches for the current setting based on the document line start date period code. With MROT type. | |
| 21094008 | Table record 17415 "Payroll Document Line". | The function returns Max. Average earnings" from table 17390 "Sick Leave Setup". The payroll entry is searched by entry number from the line. “Sick Leave Setup” is filtered by “Salary limits”, type of sick leave from the ledger entry, start date not later than the start date of the document from the ledget entry. If there are no current records, the sick leave type filter is reset and the search is performed again. | |
| 21094009 | Table record 17415 "Payroll Document Line". | The function returns “Max. accrual amount" from table 17390 "Sick Leave Setup". The payroll entry is searched by entry number from the line. “Sick Leave Setup” is filtered by “Salary limits”, type of sick leave from the ledger entry, start date not later than the start date of the document from the ledger entry, by the number of years of insurance experience. If there are no current records, the sick leave type filter is reset and the search is performed again. | |
| 21094010 | 1) Table record 5200 Employee. 2) Number of months to calculate the function. 3) Period start date (month of the previous year according to the start date of the document from the document line). 4) Period end date (last day of the previous month from the start date of the document from the document line). The function calculates the number of months of insurance service during the period (parameter No. 2). The calculation is made using table 17353 “Employee’s work record” with filters by employee code, start date of the insurance period and end date of the insurance period. Based on the periods found, the number of months of insurance service is calculated. If the start date of the period is less than the employee’s hiring date, then before this period, the length of service is calculated as for a person and added to the employee. | ||
| 21094011 | Table record 17415 "Payroll Document Line". | If the number of days in a month = 31, the function returns 31 or 0. | |
| 21094012 | Table record 17415 "Payroll Document Line". | For an employee, lines of a labor contract with a transfer type are searched by the start and end date of the document. For the found contract line, the line of contract terms with the following element code is searched for: “Element code for salary by day” + “Element code for salary by hour” + “Element code for salary by amount” from table 5218 “HR and Payroll Setup”. The indexation coefficient is calculated for the contract line. Then the average value of the coefficient for the period is found. This value is returned by the function. | |
| 21094013 | Table record 17415 "Payroll Document Line". | Returns the value of the exchange rate for the expiration date and the exchange rate for the employee ledger entry obtained by entry number on the document line. | |
| 21094014 | 1) Table record 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time activity group from table 17459 “Payroll Document Line Calculation”. | The “Planned Hours” and “Actual Hours” fields are updated in the document lines. The function returns “Sum” (from table 17413 “Employee Ledger Entry”) * hours worked/planned hours. Filters by employee code and element code (from ‘HR and Payroll Setup”, “Payroll Element Code by Hour”), current records by start and end dates for the accrual period. | |
| 21094015 | 1) Table record 17415 "Payroll Document Line". 2) Calculation type hours/days. 3) Time Activity Group from table 17459 “Payroll Document Line Calculation”. | The "Planned Days" and "Actual Days" fields are updated in the document line. The function returns "Amount" (from table 17413 "Employee Ledger Entry") * days worked/planned days. Filters by employee code and element code (from ‘HR and Payroll Setup”, “Payroll Element Code by Day”), current records by start and end dates for the accrual period. | |
| 21094016 | Number of hours according to the timesheet with a filter by time activity group from the calculation setup with a filter by accrual period. | ||
| 21094017 | Number of days according to the timesheet with a filter by time activity group from the calculation setup with a filter by accrual period. | ||
| 21094018 | 1) Table record 17415 "Payroll Document Line". 2) Type of calculation period (period code or accrual period). 3) Calculation for person. | The function returns the taxable amount from table 52000 Employee with filters: by employee code, element type, posting type, element code, accrual period from the document line. | |
| 21094019 | 1) Table record 17415 "Payroll Document Line". 2) Type of calculation period (period code or accrual period). 3) Calculation for person. | The function returns the salary amount from table 52000 Employee with filters: by employee code, element type, posting type, element code, accrual period from the document line. | |
| 21094020 | Same as 21094021, only we take the filter by period from the line period code, and not from the accrual period code. | ||
| 21094021 | 1) Table record 17415 "Payroll Document Line". 2) “Corr. amount" from the document line. 3) Type of calculation period (period code or accrual period). | Table 17410 "Payroll range header" is filtered by element code and accrual period code from the document line, the last record in the selection is found. Table 17411 "Payroll Range Line” is filtered by element code, range code, period code from the payroll range header; depending on the settings in the payroll range header, additional filters are applied by employee’s gender and birthday, disability, “Extra Amount” less than “Corr. amount" from the document line. If there are no records, then the disability and “Extra Amount” filters are reset one by one. The last record in the selection is searched for. If the directory code is filled in, the document line value is updated. The function returns “Tax amount” + (Corr. Amount). | |
| 21094022 | Same as 21094023, only we take the filter by period from the line period code, and not from the accrual period code. | ||
| 21094023 | 1) Table record 17415 "Payroll Document Line". 2) Type of calculation period (period code or accrual period). | Table 17410 "Payroll range header" is filtered by element code and accrual period code from the document line, the last record in the selection is found. Table 17411 Payroll Range Line” is filtered by element code, range code, period code from the payroll range header; Depending on the settings in the payroll range header, additional filters are applied by the employee’s gender, birthday, and disability. If there are no records, then the disability filter is reset. The last record in the selection is searched for. The function returns the amount from the found record. | |
| 21094024 | 1) Table record 17415 "Payroll Document Line". 2) Code of the base amount from table 17459 "Payroll Document Line Calculation." 3) Amount type (Payroll Amount, Taxable Amount, Corr. Amount). 4) Whether to create a record in table 21094004 “Detailed tax base”. 5) Whether it is necessary to update the “Tax deduction code” field in the payroll document line. | The function returns the amount for the “Taxable amount” field from the lines of the current document. Filters are applied based on the settings of table 17409 “Base payroll amount”. | |
| 21094025 | Table record 17415 "Payroll Document Line". | Sets the source of payment in the line = FSS. | |
| 21094026 | 1) Accrual period code. 2) Data type 'MROT, FSI'. | The function returns the amount from table 17397 "Salary Limits". Searches for the current setting for the accrual period of a document line with type MROT. | |
| 21094027 | 1) Accrual period code. 2) Data type 'MROT, FSI'. | The function returns the amount from table 17397 "Salary Limits". The current setting for the accrual period from the document line with the Social Insurance Fund type is searched for. | |
| 21094028 | Employee code | Lines of the labor contract with filters by contract number and “Hiring” and “Transfer” types are searched for. Based on the terms of the contract lines, the current salary is searched for. Then the previous line of the labor contract is searched for. If the current position does not coincide with the previous one, 0 is returned, otherwise the difference in current and previous salaries is returned from the labor contract lines. | |
| 21094029 | 1) Employee code. 2) accrual period. | The function returns the indexation percentage value from table 21094003 “Indices for indexing”, the record is found by parameter 2 and “Base month for indexing” from table 5200 Employee. | |
| 21094030 | 1) Table record 17415 "Payroll Document Line". 2) Code of the base amount from table 17459 "Payroll Document Line Calculation." 3) Amount type (Payroll Amount, Taxable Amount, Corr. Amount). 4) Whether to create a record in table 21094004 “Detailed tax base”. 5) Whether it is necessary to update the “Tax deduction code” field in the payroll document line. | Function for returning the amount by the Payroll Amount” field from the lines of the current document. Filters are applied based on the settings from table 17409 Base payroll amount. A record is created in table 21094004 Detailed tax base. | |
| 21094031 | 1) Table record 17415 "Payroll Document Line". 2) Code of the base amount from table 17459 "Payroll Document Line Calculation." 3) Amount type (Payroll Amount, Taxable Amount, Corr. Amount). 4) Whether to create a record in table 21094004 “Detailed tax base”. 5) Whether it is necessary to update the “Tax deduction code” field in the payroll document line. | The function returns the amount from the Payroll Amount” field from the lines of the current document. Filters are applied according to the settings from table 17409 “Base payroll amount”. The Tax deduction code field in the payroll document line is updated. | |
| 21094032 | 1) Table record 17415 "Payroll Document Line". 2) Amount type (Payroll Amount, Correction Amount). | The payroll amount per document line is distributed proportionally to the lines in table 21094004 “Detailed tax base”. | |
| 21094033 | 1) Table record 17415 "Payroll Document Line". 2) Amount type (Payroll Amount, Correction Amount). | Corr. amount from the document line is distributed proportionally to the lines in table 21094004 “Detailed tax base”. | |
| 21094034 | Table record 17415 "Payroll Document Line". | A record is created in table 21094010 “Data on insurance experience”. | |
| 21094035 | 1) Table record 5200 Employee. 2) Number of months before the function calculation. 3) Period start date (month of the previous year before the start date of the document from the document line). 4) Period end date (last day of the previous month from the start date of the document from the document line). 5) Array for calculating the insurance experience. | The function calculates the number of months of insurance experience during the period (parameter No. 2). The calculation is made using table 17353 “Employee’s work record” with filters by employee code, start date of the insurance period and end date of the insurance period. Based on the records found, the number of months of insurance experience is calculated, taking into account the inclusion factor from table 21094010 “Data on insurance experience.” If the start date of the period is less than the employee ’s hiring date, then before this period the length of service is calculated as for a person. | |
| 21094036 | Payroll document line | Returns the amount of payroll tax by period and person. | |
| 21094037 | The function calculates length of service according to Data on insurance period: takes into account the value of Inclusion factor of period code for the month from the Data on insurance period table. Summarizes the value of the Inclusion factor of period within the Wage Period for Person No., if the value is greater than 1, then we take 1. The resulting value is applied to the number of calendar days of the Wage Period and rounded mathematically to an integer value - the number of days of the month that will be taken into account when calculating the length of service. | ||
| 21094038 | Table record 17415 "Payroll Document Line". | If the hiring date falls on the first working day, the function returns 1 or 0. | |
| 21094039 | Table record 17415 "Payroll Document Line". If the employee’s contract type = “Labor contract” and the nature of the job = “Main work”, then the function returns 1 or 0. | ||
| 21094040 | Table record 17415 "Payroll Document Line". | If the employee is not disabled at the beginning of the accrual period, then the function returns 1, otherwise 0. | |
| 21094041 | 1) Table record 17415 Payroll Document Line 2) Calculation period type (period code or accrual period). 3) Employee calculation. | The function returns Corr. Amount of the table 52000 Employee with filters: by person code, element type, posting type, employee code, accrual period from the document line. | |
| 21094042 | 1) Table record 17415 "Payroll Document Line". 2) Code of the base amount from table 17459 "Payroll Document Line Calculation." 3) Amount type (Payroll Amount, Taxable Amount, Corr. Amount). 4) Whether to create a record in table 21094004 “Detailed tax base”. 5) Whether it is necessary to update the “Tax deduction code” field in the payroll document line. | The function returns the amount from the “Corr. amount" field from the lines of the current document. Filters are applied based on the settings of table 17409 “Base payroll amount”. | |
| 21094043 | Table record 17415 "Payroll Document Line". | If the accrual period code is less than and equal to the period code, then the function returns 1 or 0. | |
| 21094044 | 1) Accrual period code. 2) Data type 'MROT, SSC Limit,,,,,,,,,Indexation Threshold'. | The function returns the amount from table 17397 "Salary Limits". Searches for the current setting for the accrual period of a document line with the “Indexation Threshold” type. | |
| 21094045 | Beginning of the period | Returns the cost of living. | |
| 21094046 | Payroll document line | Returns the position rate under the labor contract as of the current date. | |
| 21094047 | Payroll document line, time activity group | Returns the amount for indexing, Result := 100 * ActualTime (hours) / PlannedTime. | |
| 21094048 | Payroll document line, time activity group | Returns the amount for indexing, Result := 100 * ActualTime (days) / PlannedTime. | |
| 21094049 | Payroll document line, beginning of the payroll period | Returns a fixed indexing coefficient. | |
| 21094050 | Employee, period end date | Returns salary as of date. | |
| 21094051 | Period code | Returns the cost of living, must be an entry from the employee's ledger entry. | |
| 21094052 | Payroll document line, base amount code | Corr. amount of a person. | |
| 21094053 | Payroll document line | Returns the amount of taxes from the payroll ledger entry. | |
| 21094054 | Payroll document line, time activity code | Returns the number of hours in the timesheet using the time activity filter. | |
| 21094055 | Payroll document line, time activity code | Returns the advance on the date (hourly payment). | |
| 21094056 | Payroll document line, AE Setup code | Returns the increase coefficient for average earnings. | |
| 21094057 | Payroll document line | Returns paid days from the absence order. | |
| 21094058 | Payroll document line | Returns the norm of hours (HR and Payroll Setup module – State calendar code). | |
| 21094059 | Payroll document line | Returns the norm of days. | |
| 21094060 | Payroll document line, Data set code from payroll document line calculation | Returns the amount from the work ledger entry. | |
| 21094061 | Payroll document line, Time activity group code | Fills out periods for calculating average earnings for vacation. | |
| 21094062 | Payroll document line, Time activity group code | Returns the balance of vacation days for calculating the reserve. | |
| 21094063 | Payroll document line, Base amount code | Returns the corrected document amount for the past period. | |
| 21094064 | Payroll document line | Updates the accrual code. | |
| 21094065 | Payroll document line | Fills out the calculation of average earnings for vacation as of the date. | |
| 21094066 | Payroll document line, Time activity group code | Returns vacation days for the employee's period of work. | |
| 21094067 | Payroll document line | Sign of disability (Yes/No). | |
| 21094068 | Employee Code | Returns the position field for a person with a disability Yes/No. | |
| 21094069 | Payroll Document Line, Period code | Returns whether the period codeis included in the employee’s working dates. | |
| 21094070 | Employee code, Period code | Returns the payment amount by vendors. | |
| 21094071 | Payroll Document Line | Returns the amount from the payroll ledger entry and is used for vacation + amount from the payroll document line using the same filters. | |
| 21094072 | Payroll Document Line | Value from a posted and non-posted payroll document, the Payroll Amount field, provided there is an entry number from the payroll ledger entry. | |
| 21094073 | Payroll Document Line | Returns the taxable amount from the previous period. | |
| 21094074 | Payroll Document Line, Base Amount Code | Accepts a filter from the Base Amount, Searches through document lines with this filter, If at least one line is found, it returns 1. | |
| 21094075 | Payroll Period Code | Returns the amount of the cost of living for the first period of the year of the period from the line. | |
| 21094076 | Payroll Document Line, Time Activity Code | Returns Balance of vacation days for reserve. | |
| 21094077 | Payroll Document Line, Base Amount Code | Creates a copy of the current line with a new element from the base amount. | |
| 21094078 | Payroll Document Line | Returns the amount of withholding debt, which checks the Employee Ledger Entry No. If the Effective Start Date is less than the Period Code Start Date, then you need to find the unique periods that the effect of this line falls under BEFORE the current Period Code. 1. Using these periods and the entry number, find the Payroll Amount in the Payroll Ledger Entry and summarize it. 2. Multiply the number of these months by Amount. | |
| 21094079 | Payroll Document Line, Base amount code | Returns the amount of correspondence for the previous payroll period. | |
| 21094080 | Payroll Document Line, Period code | Returns the correspondence amount from the payroll ledger entry, filter by employee, element code and period code. | |
| 21094081 | Payroll Document Line, Period code | Returns the taxable amount from the payroll ledger entry, filter by employee, element code and period code. | |
| 21094082 | Employee code, Start date from the payroll document line | Returns the salary as of the date, comparing it with the minimum wage and returning the larger value. | |
| 21094083 | Employee code, Start date from the payroll document line | Returns the greater value between the average earnings on the date and the minimum wage. | |
| 21094100 | Payroll Document Line | Returns the posted amount of personal income transaction tax. | |
| 21094101 | Payroll Document Line | Returns the tax deduction from the payroll ledger entry. | |
| 21094102 | 1) Payroll Document Line 2) Code of the base amount from the payroll document line calculation | Returns the amount of deduction from the detailed tax base + the difference between the payroll amount and the paid amount from the line of the payroll document. | |
| 21094103 | 1) Payroll Document Line 2) Code of the base amount from the payroll document line calculation | Returns the amount from the paysheet line | The paysheet line is filled in from the payroll document line. |
| 21094104 | 1) Payroll Document Line 2) Code of the base amount from the payroll document line calculation | Returns the amount from the base payroll amount | The base amount is filtered by the element code from the payroll document line. |
| 21094105 | Payroll Document Line | Checks whether there is a payroll calculation group and if there is, this is the “Interperiod” group. | |
| 21094108 (GE) | Payroll Document Line | Returns the number of months between AE Period From..AE period To. | |
| 21094109 (GE) | Payroll Document Line | Accepts Payroll Element Filter from Base Amount, checks the Base Element Code value for Employee.Position using this filter, if there is a value, then returns 1. | |
| 21094110 | Returns the number of calendar working days from the next period line. | ||
| 21094111 | Returns the amount from the Employee Ledger Entry as of the start date of the payroll document from the line. | ||
| 21094900 | Employee code | Returns the maximum amount from the payroll range line | If the payroll range header is found using filters: element code, range type, range code from the payroll document line. |
| 21094901 | 1)Employee code from the payroll document line 2)Start date from the payroll document line 3) End date from the payroll document line | Returns the average earnings per hour. | |
| 21094902 | 1)Employee code the payroll document line 2) Start date from the payroll document line 3) End date from the payroll document line | Returns the average earnings per day. | |
| 21094903 | 1) Payroll Document Line 2) Code of the base amount from the payroll document line calculation | Returns the payroll amount for the period for persons. | |
| 21094904 | 1) Payroll Document Line 2) Code of the base amount from the payroll document line calculation | Returns the amount of taxes for the period for persons. | |
| 21094905 | 1) Payroll Document Line 2) Time activity group from the payroll period line | Returns the number of working days on the time sheet for the filter of time activities by the start date and end date. | |
| 21094906 | Payroll Document Line | Returns the maximum amount for payroll periods. | |
| 21094907 | Payroll Document Line | Returns length of service. | |
| 21094908 | Payroll Document Line | Returns the amount and percentage of salary from the payroll range line | |
| 21094909 | Payroll document line | Returns the start date and the end date for the period from the payroll period | |
| 21094910 | Payroll document line | Returns the start date and the end date for the period from the payroll period | The end date is the advance date for the payroll period. |
| 21094911 | 1) Payroll document line 2) Base amount code from the payroll document line calculation | Returns the salary by the base amount code. | |
| 21094912 | 1) Employee code from the payroll document line 2) End date from the payroll document line | Returns the length of service in the current position. | |
| 21094913 | Payroll document line | Fills in the advance date from the payroll period | If the advance date is in the payroll period . |
| 21094914 | Payroll document line | Checks whether the employee’s position is part-time. | |
| 21094915 | 1) Payroll document line 2) Base amount code from the payroll document line calculation | Returns the salary amount for a person. | |
| 21094916 | 1) Payroll document line 2) Base amount code from the payroll document line calculation | Returns the tax amount for a person. | |
| 21094917 | 1) Payroll document line 2) Base amount code from the payroll document line calculation | Returns the base balance for the previous period. | |
| 21094918 | 1) Employee code by payroll document line 2) Start date by payroll document line 3) End date by payroll document line | Returns the number of planned working hours for the period. | |
| 21094919 | Payroll document line | Checks the “Main work” nature of the work in the labor contract. |
Step 2. Payroll calculation functions for reports
Path: Subdivisions / HR / Payroll / Calculation Setup / Calculation Functions
Description of payroll functions’ operation
| Function No. | Parameters passed to the function | Value returned by the function | Comments |
|---|---|---|---|
| 21094500 | 1) Filter by period. 2) Calculation for sick leave or not. | The function returns the sum of positive values for the Turnover (LCY) field from table 23 Vendor. Filters: by date – by the end date of the period, vendor type – person, filter by Additional Vendor Posting Group, if filled. | |
| 21094501 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Calculate only employees with working hours. 4) Calculate only the number of employees. | The function returns the number of manhours for a given period, taking into account the settings of table 21094007 "Payroll Report Line Setup". Hours are calculated for each employee based on the actual hours in the timesheet. | |
| 21094503 | Filter by period | The function returns the number of vendors with the value of the "Turnover (LCY)" field from table 23 "Vendor" greater than zero. Filters: by date – by the end date of the period, vendor type – peron. | |
| 21094504 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Filter by employee. | The calculation is based on table 17418 "Payroll Ledger Entry" or 17415 "Payroll document line", depending on the selected data source. Filters and calculation type are set according to the settings from table 21094007 "Payroll Report Line Setup”. | |
| 21094505 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Filter by employee. | The number of actual calendar days according to the timesheet for the period is calculated with the filter by employees and the time activity group code from table 21094007 "Payroll Report Line Setup". | |
| 21094506 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Filter by employee. | The calculation is based on table 17418 "Payroll Ledger Entry" or 17415 "Payroll document line", depending on the selected data source. Filters and calculation type are set according to the settings from table 21094007 "Payroll Report Line Setup". The obtained result is limited by the FFS limit. | |
| 21094507 | 1) Filter by period. 2) Filter by employee. | The function returns the amount by the "Amount (LCY)" field from table 25 "Vendor Ledger Entry". Filters: by date – parameter 1, number – by employee vendors from parameter 2. document type – payment. | |
| 21094508 | 1) Filter by period. 2) Calculation type (All, DisabledOnly, WithAddGuarantees, Women, External Co-work, Civil Contract). | The calculation is based on table 17363 "Employee work record" with filters by: start date and end date (relevant records for the period), position rate is greater than zero, freelance position – no, nature of work – Main Work. For the records found, timesheet lines are searched for; if they exist, this record is taken into account. The function returns the counted number of records divided by the number of days in the period. | |
| 21094509 | 1) Filter by period. 2) Calculation type (All, DisabledOnly, WithAddGuarantees, Women, External Co-work, Civil Contract). | The calculation is based on table 17363 "Employee work record " with filters by: start date and end date (relevant records for the period), position rate is greater than zero, freelance position – no, nature of work – Main Work. For the records found, a check is made whether the employee is disabled. If yes, then the timesheet lines are searched for, if they exist, this record is included in the calculation. The function returns the counted number of records divided by the number of days in the period. | |
| 21094510 | 1) Filter by period. 2) Gender. 3) On staff or not. 4) Newly created position or not. | The function returns the number of hired employees with filters by: hire date and filter by freelance position depending on the settings of table 21094007 "Payroll Report Line Setup". | |
| 21094511 | 1) Filter by period. 2) Gender. 3) On staff or not. 4) Newly created position or not. | The function returns the number of hired employees with filters by: hire date and filter by freelance position depending on the settings of table 21094007 " Payroll Report Line Setup", filter by gender – women. | |
| 21094512 | 1) Filter by period. 2) Gender. 3) On staff or not. 4) Reason for dismissal. | The function returns the number of dismissed employees with filters by: hire date, freelance position filter and reason for dismissal depending on the settings of table 21094007 " Payroll Report Line Setup". | |
| 21094513 | 1) Filter by period. 2) Gender. 3) On staff or not. 4) Reason for dismissal. | The function returns the number of dismissed employees with filters by hire date, filter by freelance position and reason for dismissal depending on the settings of table 21094007 "Payroll Report Line Setup", filter by gender – women. | |
| 21094514 | 1) Filter by period. 2) Gender. 3) On staff or not. | The function returns the number of working employees with filters by: hire date, dismissal date, freelance position filter depending on the settings of table 21094007 "Payroll Report Line Setup". | |
| 21094515 | 1) Filter by period. 2) Gender. 3) On staff or not. | The function returns the number of working employees with filters by: hire date, dismissal date, part-time position filter depending on the settings of table 21094007 "Payroll Report Line Setup", filter by gender – women. | |
| 21094516 | 1) Filter by period. 2) Gender. 3) On staff or not. 4) Newly created position or not. | The function returns the number of employees hired for newly created positions with filters by: hire date and part-time position filter depending on the settings of table 21094007 "Payroll Report Line Setup", filter by the new position field = yes. | |
| 21094517 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Calculate only employees who have working hours. 4) Calculate only the number of employees. | The function returns the number of manhours for a given period, taking into account the settings of table 21094007 "Payroll Report Line Setup". Hours are calculated for each employee based on actual hours in the timesheet. The calculation is performed only for employees who have actual hours in the timesheet. | |
| 21094518 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Calculate only employees with working hours. 4) Calculate only the number of employees. | The function returns the number of employees for the specified period, taking into account the settings from table 21094007 "Payroll Report Line Setup". Hours are calculated for each employee based on actual hours in the timesheet. The calculation is performed only for employees with actual hours in the timesheet. | |
| 21094519 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Take the range into account or not. 4) Threshold of hours worked. | The number of employees who worked 100% of the time is calculated. The search includes employees who are currently working, additional filters by gender and freelance positions from setup. The coefficient of hours worked is checked based on the timesheet status. Only employees with a coefficient greater than or equal to 100% are included in the calculation. | |
| 21094520 | 1) Filter by period. 2) Calculation type (All, DisabledOnly, WithAddGuarantees, Women, External Co-work, Civil Contract). | The calculation is based on table 17363 "Employee work record" with filters by: start date and end date (current records for the period), position rate greater than zero, freelance position – no, nature of work – Main Work. Timesheet lines for women are searched for; if there are any, this entry is taken into account. The function returns the calculated number of entries divided by the number of days in the period. | |
| 21094521 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Nature of work (External Co-work, Civil Contract). | The function returns the employees’ PE. The search is for working employees with filters by: filter by freelance position and gender depending on the settings of table 21094007 "Payroll Report Line Setup. | |
| 21094522 | 1) Filter by period. 2) Calculation type (All, DisabledOnly, WithAddGuarantees, Women, External Co-work, Civil Contract). | The calculation is based on table 17363 "Employee work record" with filters by: start date and end date (current records for the period), position rate is greater than zero, freelance position – yes, nature of work – external co-work. The search is for timesheet lines for women; if there are any, this record is taken into account. The function returns the counted number of records divided by the number of days in the period. | |
| 21094523 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Nature of work (External Co-work, Civil Contract). | The function returns the employee’s PE. Working employees are searched for with filters by: filter by freelance position and gender depending on the settings of table 21094007 "Payroll Report Line Setup". The calculation is performed only for employees with the "External Co-work" nature of work. | |
| 21094524 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Nature of work (External Co-work, Civil Contract). | The function returns the employee’s PE. Working employees are searched for with filters by: filter by freelance position and gender depending on the settings of table 21094007 "Payroll Report Line Setup". The calculation is performed only for employees with the "Civil contract" type of work. | |
| 21094525 | 1) Filter by period. 2) Calculation type (All, DisabledOnly, WithAddGuarantees, Women, External Co-work, Civil Contract). | The calculation is performed according to table 17363 "Employee work record" with filters by: start date and end date (relevant records for the period), position rate is greater than zero, freelance position – yes, type of work – civil contract. Timesheet lines for women are searched for; if there are any, this record is taken into account. The function returns the calculated number of records divided by the number of days in the period. | |
| 21094526 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Take into account the range or not. 4) Threshold of hours worked. 5) Nature of work (External Co-work, Civil Contract). | Calculates the number of PE employees who fall within the range according to the settings of table 21094007 "Payroll Report Line Setup" and who have worked 50% of the time. Searches for employees currently working, additional filters by gender, and freelance positions from the settings. The coefficient of hours worked is checked by the timesheet status. | |
| 21094527 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Take the range into account or not. 4) threshold of hours worked. | Calculates the number of PE employees who fall within the range according to the settings of table 21094007 "Payroll Report Line Setup" and who have worked 100% of the time. Searches for employees currently working, additional filters by gender, and freelance positions from the settings. The coefficient of hours worked is checked by the timesheet status. | |
| 21094528 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Take the range into account or not. 4) Threshold of hours worked. | Calculates the number of PE employees who fall within the range according to the settings of table 21094007 "Payroll Report Line Setup". Searches for employees currently working, additional filters by gender and freelance positions from the settings. | |
| 21094529 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Filter by employee. | Depending on the type of amount in table 21094007 "Payroll Report Line Setup", the function returns the payroll amount, taxable amount, corr. amount, paid days, average daily earnings, add. amount, number of payments from table 17418 "Payroll Ledger Entry". | |
| 21094530 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. 3) Filter by employee. | 1) If the data source is "Account", the function returns the payroll amount, taxable amount, corr. amount, paid days, average daily earnings, add. amount, number of payments from table 17418 "Payroll Ledger Entry". 2) If the data source is "Payroll Documents", the function returns the payroll amount, taxable amount, corr. amount, paid days, average daily earnings, add. amount, number of payments from table 17415 "Payroll Document Line". 3) If the data source is "Posted Payroll Documents", the function returns the payroll amount, taxable amount, corr. amount, paid days, average daily earnings, add. amount, number of payments from table 17417 "Posted Payroll Document Line". | Values are returned depending on the amount type in table 21094007 "Payroll Report Line Setup". |
| 21094531 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Returns the credit amount from table 17 "G/L Entry". | |
| 21094532 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Depending on the amount type in table 21094007 "Payroll Report Line Setup", the function returns the payroll amount, taxable amount, corr. amount, paid days, average daily earnings, add. amount, number of payments from table 17418 "Payroll Ledger Entry". | |
| 21094533 | 1) Filter by period. 2) Filter by employee. | Returns the amount (LCY) from table 25 "Vendor Ledger Entry". | |
| 21094540 | 1) Record of table 21094007 “Payroll Report Line Setup". 2) Filter by period. | Counts the number of employees on the payroll at the beginning of the reporting period. | |
| 21094541 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Returns the number of new employees in the reporting year from the Stat. Report. | |
| 21094542 | 1) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Counts the number of employees falling within the range of settings of table 21094007 "Payroll Report Line Setup" by employee gender, staff position, new workplace. Searches for the number of employees by the date of hiring. | |
| 21094543 | 1 ) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Counts the number of employees falling within the range of the settings in table 21094007 "Payroll Report Line Setup" by employee gender, staff position, new workplace. Searches for the number of employees by the date of hiring, by the position number in table 17370 "Position" in which the reason for opening field must match the setting in table 21094007 "Payroll Report Line Setup" or must not be empty if the setting in the table has a value. | |
| 21094544 | 1 ) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Calculates the number of employees falling within the range of table 21094007 "Payroll Report Line Setup" by employee gender, staff position, and dismissal filter. Searches for the number of employees by dismissal date. | |
| 21094545 | 1 ) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Calculates the number of employees falling within the range of table 21094007 "Payroll Report Line Setup" by employee gender, staff position. Searches for employees by element type filter, element code filter, element group filter. Returns the sum of employees' salaries. | |
| 21094551 | 1 ) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Average annual number of employees. Stat. Report. | |
| 21094552 | 1 ) Record of table 21094007 "Payroll Report Line Setup”. 2) Filter by period. | Total salary of employees for the period. | |
| 21094553 | 1 ) Record of table 21094007 "Payroll Report Line Setup". 2) Filter by period. | Education of employees. Stat. Report. |