(RUS) Generate pay statements
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
This topic explains how to create payroll journals, calculate average earnings, calculate salaries, calculate funds, create a salary journal, and close the payroll period.
Prerequisites
The following table shows the prerequisites that must be in place before you start.
Category |
Prerequisite |
|---|---|
Version |
Microsoft Dynamics AX 2012 R2 Payroll for Russia Feature Pack |
Country/region |
The primary address for the legal entity must be in the following countries/regions: Russia |
Related setup tasks |
|
Related task |
|
1. Create and post a payroll journal
Use the Payroll journal and Payroll journal lines forms to create a payroll journal and payroll journal lines that are used to create non-recurring accruals and deductions for employees. You can use a payroll journal to register payments that are not processed through other type of entries, such as timesheets, vacations, business trips, sick lists, or bonuses. You can also use a payroll journal to make manual adjustments to the values that are automatically calculated for other processes. You can create lines in a journal for specific employees or for groups of employees.
To create and post a payroll journal, follow these steps:
Click Payroll (Russia) > Calculation procedures > Payroll journal > Payroll journal.
Click New or press CTRL+N to create a journal.
In the Name field, select the identification code for a payroll journal name.
On the General tab, select the Use rate value per employee check box to use the date effective rate value that you specified for each employee or group in the Value field on the Overview tab in the Set up rate values form. If you clear this check box, the default rate value that you specified for the rate in the Value field on the Value tab in the Rates form is used for all of the employees or groups.
In the Number of incentive resolution field, select the number of the incentive resolution order that is related to the payroll journal. Click From order to create journal lines automatically based on the information that is available in the selected incentive resolution, such as the pay type code from the resolution type, or the employees that have incentive amounts from the resolution lines.
Specify values in other fields, if required, and then click Lines.
In the Payroll journal lines form, click New or press CTRL+N to create a payroll journal line, and then specify the line type, pay type, quantity, rate, and amount for the line.
Field
Description
Date
Select the transaction date for the journal line.
Line type
Select the type of line.
Select from the following options:
Employee – Create the journal line for an employee.
Group – Create the journal line for a payroll group.
Nota
If you select this option and create a payroll journal line, then the same payroll line, pay type, and amount are created for all of the employees in the group when you post the journal.
Code
Select the identification code for an employee or a payroll group code, depending on the line type that you select.
Pay type
Select a pay type for which an accrual or deduction is to be entered. The Description field is updated with the description of the pay type. You can modify the description.
Nota
The Qty, Rate, Percent, and Amount fields are available based on the information that you set up for the pay type in the Pay type setup form. For more information, see “6. Set up pay types” in (RUS) Set up parameters for the payroll process.
Qty
Enter the number of units for the line.
Rate
Enter the per unit rate that applies to the journal line.
Percent
A selected check box indicates that the rate is specified as a percent value.
Amount
Enter the accrual or deduction amount for the journal line.
Nota
If the Qty and Rate fields are updated, the amount is automatically calculated and updated in the Amount field.
Name of person
If the deduction code of the income code for the pay type that you select for the journal line is associated with an employee relative, select the name of the relative.
Click Validate, and then click OK to validate the journal lines.
Click Print to print the journal report, if required.
Click Post, and then click OK to post the journal lines.
You can click Reverse in the Payroll journal or Payroll journal lines form to cancel the posting of the journal in the same period in which you posted the journal. You can click Adjust storno in the Payroll journal or Payroll journal lines form to process the storno adjustment for the selected payroll journal in the period following the posting period. You can click View the storno in the Payroll journal or Payroll journal lines form to inquiry the storno adjustment for the selected payroll journal.
2. Calculate the average wages that are earned by a worker
Use the Employee average earnings calculation form to calculate the average earnings of an employee. You can calculate different types of salary accruals using the average earnings method. These can include per diem expenses, travel allowances, gifts, annual bonuses, vacations, and sick lists.
You can use multiple methods to calculate the different average earnings accrual types.
Microsoft Dynamics AX can also calculate the average earnings automatically if you configure it in the counters that are running. For more information about how to set up counters, see “4. (RUS) Set up counters for calculation sequences” in (RUS) Set up calculation procedures for the payroll process.
To calculate the average wages that are earned by a worker, follow these steps:
Click Payroll (Russia) > Average earnings calculation > Average earnings calculation lines.
In the Employee average earnings calculation form, in the Reporting period field, modify the calculation period, if required. This field displays the current calculation period by default
To create a calculation line manually, perform the following steps:
Click New or press CTRL+N to create a line.
In the Calculation method code field, select the identification code of the calculation method to use for the line.
In the Employee field, select the identification code of the employee to calculate average earnings for. You must select an employee for whom you have defined a working schedule.
–or–
To create calculation lines using a query, perform the following steps:
Click Add lines to open the Average earnings calculation line creation form.
In the Calculations field, select the identification code for the average earnings calculation method to create calculation lines for.
Click Select, and then specify additional criteria to create calculation lines, if required. Click OK to create calculation lines in the Employee average earnings calculation form.
In the Number of month field, select the identification code for a rate that contains the number of months for the average earnings calculation period.
In the Working week duration field, select 5 days, 6 days, or 7 days as the duration of the work week.
On the General tab, specify calculation methods, numerical parameters, time parameters, and bonus parameters.
Field
Description
Calculation method of short month
Select the calculation method for the days or hours that are worked and apply it to each month within the average earnings calculation period during which the employee did not work for the full month.
Select from the following options:
Summary – The number of days or hours that are worked is calculated using resulting information about the employee days or hours that are worked for the month:
The days or hours that are available to work according to the schedule - The days or hours that the employee is absent.
Calendar – The number of days or hours that are worked is calculated using the daily timesheet and calendar details:
((The days or hours according to the schedule - The days or hours that the employee is absent) / The number of calendar days in the month) * The average number of days in the month.
By coefficient – The number of days or hours that are worked is calculated using the resulting information from the number of employee days or hours that are worked for the month, the actual time that is worked considering the conversion factor that is set for the calendar of the employee, and the working week duration.
Calculation method of full month
Select the average earnings calculation method for the days or hours that are worked, and apply it to each month within the average earnings calculation period that the employee worked for the entire month.
Select from the following options:
According to calendar – The number of days or hours in the calculation period according to the working schedule.
Average value – The average number of days or hours per month.
Calculation type
Select By days or By hours to calculate average daily or hourly earnings.
Nota
If you select Calendar in the Calculation method of short month field, you must select By days in this field.
Base of calculation
Select the identification code for the average earnings calculation base. The base includes pay types that are used in the average earnings calculation.
Average earnings base
Select the identification code for the average earnings calculation base. The base includes pay types that are used in the average earnings calculation.
Nota
The average earnings base is applied for the average earnings calculation instead of base of calculation when there are no accruals available for previous calculation periods that are included in the base of calculation.
Step-up ratio
Select the rate that contains the ratio to index the average earnings during the calculation period.
According to schedule
Select a time group that defines the work time according to the schedule.
Actually worked
Select a time group that defines the time that was actually worked.
Nota
This field is available only if you select By coefficient in the Calculation method of short month field.
Absences from work
Select a time group that defines an acceptable reason for an absence from work.
Nota
This field is available only if you select Summary or Calendar in the Calculation method of short month field.
On average
Select a time group that defines the time during which the accruals that are entered in the Average earnings base field were made.
Bonus base
Select a calculation base that includes pay types that correspond with awards that are made for the period from the material incentives fund.
Criteria of bonus accounting
Select the criteria to specify the bonus accounting rules in the average earnings calculation.
Select from the following options:
Maximum – The applicable number of bonuses that are for the maximum amount are used for the calculation.
Minimum – The applicable number of bonuses that are for the minimum amount are used for the calculation.
First – The applicable number of bonuses that are accrued first are used for the calculation
Last – The applicable number of bonuses that are accrued last are used for calculation.
Nota
If the number of bonuses for a single reason exceeds the number that is allowed for the average earnings calculation, a single bonus is selected for the period, depending on the selected criteria. One twelfth of the bonus for the year prior to the event is included in each month that is entered in the average earnings calculation.
Proportional calculation
Select this check box to indicate that bonuses are included in the average earnings calculation in proportion to the days or hours worked.
The average earnings for the employee are updated in the Average earnings field.
On the Calculation tab, perform the following steps:
Click New or press CTRL+N to open the Salary Report form.
In the Calculation period field, select the month and year of the calculation period.
In the Payment source field, select Wage fund or Incentive fund as the source of the payments for the amount that is accrued.
Click OK to add new lines on the Calculation tab.
In the Days field, enter the number of working days in a month for the selected employee.
In the Amount field, enter the amount that is accrued for the calculation of average earnings.
Nota
The average daily earnings for each calculation line for the selected employee are displayed in the Average per day field. The total average daily or hourly earnings for all calculation lines for the selected employee are displayed in the Average earnings field based on the calculation type.
Click Recalculation to recalculate the average earnings wages of an employee if additional accruals were made for the employee.
Nota
If you modify the values in the Days and Amount fields, these modifications are not saved after recalculation.
Click Hours worked accounting to open the Resulting information about employee worked hours form, where you can view the details about the working days and hours of the employee for the selected calculation period. Close the form.
Click Bonus to open the Bonus form, where you can view the bonus details for the calculation of the average earnings of an employee. You can view all of the bonuses that are accrued by an employee during the selected calculation period. The Included check box is selected for the accruals from incentive funds that are related to the current average earnings incentive calculation for an employee. Close the form.
Click Payroll lines to open the Pay type transaction list form, where you can view the employee accruals for the selected calculation period. The Included check box is selected for the accruals from wage funds that are related to the current average earnings wages calculation for an employee.
3. Calculate salaries using calculation procedures
You can calculate salaries that include the payable amounts and the deductions by types of salary, funds, data for medical certificates, and vacations. You can use the data in the working time calculation table, salary journals, and periodic payments according to the configured algorithms or sequences of calculations to calculate the salaries. You can calculate earnings for an employee or all of the employees at once using one or all of the calculation methods.
You can set up the sequence of the calculation procedures in the Calculation procedures form.
When you change the input data by entering new pay lines, tables, or medical certificates for a calculation procedure, a message is displayed stating that you must repeat the calculation of all of the dependent procedures. To save calculation time, you can save only the most recent modifications by calculating the pay only for those employees for whom the data have changed.
To calculate salaries using calculation procedures, follow these steps:
Click Payroll (Russia) > Payroll calculation > Procedure calculation.
Nota
The form displays a list of all of the calculation procedures that are specified in the module settings, with an indication of their calculation status.
In the Status field, the current status of the procedure is displayed. You can modify the status for the procedure. Use the information in the following table to decide the status of the procedure.
Status
Purpose
Not calculated
The calculation of the given procedure has not been calculated, or its results are no longer up to date. Modify the status to Not calculated when you recalculate the procedure, so that all of the calculations for the procedure and all of the dependent procedures are recalculated.
Calculated
The procedure has been fully calculated. This option is updated automatically for the calculated procedure.
Exclude
The procedure is excluded from the calculation.
If you change the status of a procedure, the statuses of the child procedures also change. For example, the advance calculation requires a previous vacation payment calculation. When you set the status of the vacation payment calculation procedure to Not calculated, the same status is assigned to the advance calculation procedure. In the Modified date and time field, the date and time of the last payroll calculation are displayed for the corresponding procedure. The Modified by field displays the identification code of the user who ran the last calculation for this procedure.
On the General tab, in the Payment period and the Accrual date fields, the payment period and the accrual date for the current calculation procedure are updated.
Select the Accrual date - current calculation date check box to indicate that the date of the current calculation is updated in the calculated payroll lines for the selected calculation procedure.
To process the calculation of a procedure that has a status of Not calculated, select the procedure on the Overview tab, and then click Calculation. Specify the criteria, and then click OK.
Alternatively, to process calculations for all of the procedures that have a status of Not calculated, click Calculate all.
Click Payroll lines to open the Payments and deductions registration form, where you can view the results of the calculation of the current procedure.
4. Verify worker payments and deductions
Use the Payments and deductions registration form to verify payroll calculation results and register payments and deductions for a worker.
To verify worker payments and deductions, follow these steps:
Click Payroll (Russia) > Queries > Payments and deductions.
In the Payments and deductions registration form, in the left pane, a list of company employees is displayed.
In the left pane, select an employee. The details about the accruals and deductions of the employees for the calculation period are updated in the right pane.
To register a payment or deduction correction for an employee, select the employee in the left pane, and then in the right pane, click New to create a correction record. The current calculation period and identification code of the employee are updated in the Corrected period and Employee fields.
Specify the pay type, amount, department, line values, account, and dimensions codes for the payment or deduction.
Field
Description
Pay type
Select the pay type for the payment or deduction. The name of the pay type is updated in the Name field.
Amount
Enter an amount to pay or deduct.
Department code
Select the department code for the selected employee.
Accrual date
Select the actual date of the accrual.
Payment period
Select the month and year of the period for which the payment or deduction is processed.
Hours
Enter the number of hours for the pay type transaction.
Days
Enter the number of days for the pay type transaction.
Account type
Select the type of account for the pay type transaction that specifies the type of account that the transaction is applied to.
Account
Select the account for the pay type transaction.
Name of person
If the payment or deduction is associated with an employee relative, select the name of the relative.
Paid
The difference between the total amount of accruals and the total amount of deductions.
Nota
When you generate the pay sheet for payroll, the value in this field is transferred to the line.
Click Calculation to calculate or recalculate procedures for the selected employee. After the calculation is completed, the details in the form are automatically updated.
You can also generate the following reports to verify the payments and deductions:
Income sheet report – This report contains the payments that are made for each pay type for a calculation period. Click Payroll (Russia) > Reports > Income sheet.
Retention sheet report – This report contains the deductions that are made for each pay type for a calculation period. Click Payroll (Russia) > Reports > Retention sheet.
Payments and deductions report – This report contains a pivot table that you can use to view details about the payments and deductions that are made for a calculation period. For example, you can view the amount that is paid in the calculation period; you can view the amount, days, or hours for each employee, or for all of the employees; or you can view the payment and deduction amounts for employees based on pay types, departments, and other factors. Click Payroll (Russia) > Reports > Pivot tables > Pay type transaction list.
5. If required: Recalculate salaries based on the latest modifications to the data
If you make changes to the employee data after completing payroll calculation for the employees, you can use the Recent transactions form to view the employees for whom you made changes, and recalculate the salaries for these employees. You can make changes such as specify additional accruals and deductions in the working time registration table or make changes to the average earnings, vacations, or sick time.
To recalculate salaries based on the latest modifications to the data, follow these steps:
Click Payroll (Russia) > Payroll calculation > Recent transactions.
In the Recent transactions form, the list of employees for whom additional accruals or deductions have occurred in the current payment period are displayed. In the Procedure code and Name fields, the identification code and name of the calculation procedures to be recalculated are displayed.
To recalculate the salary for an employee, select the employee record, and then click Recalculate current. Alternatively, to recalculate the salaries for all of the employees that are listed, click Recalculate all.
6. Calculate taxes and funds
You can generate the tax base values and calculate accrued individual income tax deductions and off-budget funds contributions. When you calculate taxes and funds, Microsoft Dynamics AX uses the results of the payroll calculation and processes the data for all of the employees within a legal entity. You can calculate taxes and funds only after you calculate all of the payroll procedures, and there are no recently changed transactions available with a status of Not calculated.
To calculate taxes and funds, follow these steps:
Click Payroll (Russia) > Payroll calculation > Data and funds calculation.
Microsoft Dynamics AX runs the calculation of taxes and funds for the current period.
Nota
The taxes and funds can only be calculated if the current calculation date is the last in the current calculation period.
Click Payroll (Russia) > Periodic > Data for income tax calculation.
Microsoft Dynamics AX runs the calculation of accrued individual income taxes for all employees for the current period
You can use the following forms and reports to verify the calculated taxes and off-budget funds:
Income tax form – This form displays the income tax totals for each employee. Click Payroll (Russia) > Settlements with tax authorities > Income tax.
Payments to off-budget funds (totals) form – This form displays the total amount of off-budget funds for all of the branches for each employee. Click Payroll (Russia) > Settlements with tax authorities > Funds totals.
Income tax totals form – This form displays the total amount of taxes for all of the branches for each employee. Click Payroll (Russia) > Settlements with tax authorities > Income tax totals.
Off-funds allocations (in income types) report – This report contains the amounts that are allocated to each off-budget fund for each pay type in a calculation period. Click Payroll (Russia) > Reports > Off-funds allocations (in income types).
Off-funds allocations (in accounts) report – This report contains the amounts that are allocated to each off-budget fund for each account in a calculation period. Click Payroll (Russia) > Reports > Off-funds allocations (in accounts).
7. Create and post a salary journal
Use the Salary journal and Journal voucher forms to create and post a salary journal. After you create a salary journal for the current pay period, you cannot make changes in pay statements for that period. You can modify or delete the lines of a salary journal, although doing this is not recommended because it can cause deviations from the pay sheets, fund data, and tax registers. You can verify a journal before you post it. After you post the salary journal, you cannot make any changes to it. You can create a journal that contains reversed transactions for a posted journal.
Nota
You can create a salary journal only if you complete the calculation of payroll, taxes, and funds for the current period.
To create and post a salary journal, follow these steps:
Click Payroll (Russia) > Payroll calculation > Salary journal.
In the Salary journal form, click Create > Create journal to create a journal and journal lines. For more information, see Encabezado de diario (formulario).
Nota
The Create journal button is available only if you complete the calculation of payroll, taxes, and funds for the current period.
Click Lines to open the Journal voucher form, where you can view and modify the lines for the salary journal. For more information, see Asiento del diario - Diario general (formulario). Close the form.
In the Salary journal form, click Post > Preview journal transactions to open the Preview journal transactions form, where you can view the details that are related to sales tax for each journal line, such as sales tax code, sales tax group, and item sales tax group. Close the form
Click Validate > Validate to validate the journal lines.
Nota
You can also use the Distribution control form to view the relationship between pay types and accounting entities, such as accounts and dimensions that are based on the posting profile configuration. If there are any incorrect entries, you can correct them before posting the journal. Click Payroll (Russia) > Queries > Distribution control.
Click Post > Post to post the journal.
You can click Create > Reverse journal in the Salary journal form to reverse the accounting transactions of a posted journal. A journal that contains a reversal of the lines from the original journal is automatically created in the Salary journal form.
8. Close a payroll period
After you calculate the payroll, taxes, and funds; create and post a salary journal; create salary pay sheets; and transfer salary payments; use the Close the salary form to close a payroll period. If you do not create pay sheets, a message is displayed that you must create pay sheets before closing the period. When you close a period, Microsoft Dynamics AX performs the following tasks:
Calculates debts of the employer and employees, and generates payroll lines for the amounts that have corresponding payroll types.
Changes the status of the calculation procedures to Not calculated in the Calculation procedures state form.
Changes the calculation period to the next reporting period. All of the new payroll lines automatically move to the new period.
Updates the current calculation date as the next date in the Calculation calendar area in the Payroll parameters form.
Remove payroll period records that are specific to an employee for the new payroll period records.
You cannot make any modifications to a closed period after you perform calculations for the new period. Transaction amounts in the ledger, the bank, and in cash are fixed. However, you can reopen and make changes in a closed period if you have not performed any calculations for the new period. You can make changes, such as reversing and recreating a salary journal after you recalculate the off-budget funds.
You can close the period for all employees or for a specific employee.
Nota
You can close the payroll period only if the current calculation date is the last date in the current calculation period.
To close a payroll period, follow these steps:
Click Payroll (Russia) > Payroll calculation > Close the salary.
Nota
If you have already closed the period, a warning message displays, indicating that the modifications in the closed period cannot take place. If there are no errors in the payroll calculations, respond to this warning with a confirmation.
If required, click Select to specify additional criteria, such as employee codes , and then click OK to close the period for employees who meet the criteria. Alternatively, to close the period for all of the employees, do not specify any criteria.
In the Close the salary form, click OK to close the period.
Technical information for system administrators
If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.
Category |
Prerequisite |
|---|---|
Configuration keys |
Click System administration > Setup > Licensing > License configuration. Select the CIS Payroll and CIS Staff administration configuration keys. |
Security roles and duties |
To generate pay statements, you must be a member of a security role that includes the following duties.
|
Security roles and privileges |
To generate pay statements, you must be a member of a security role that includes the following privileges.
|