Use values from the salary processing in a report or analysis

You can include the values from the salary processing in a report or analysis. The values from the salary processing consist of wage components, calculation bases or parameters. In addition, you can also include values from wage summaries.

Example:

You want to analyse the pension data for the preceding year. For this purpose, you add a new analysis in which you include the values of the premium basis, premium amounts, pension calculation basis and parameters.

You can only include values from the salary processing in certain data collections.

If the payroll configuration of wage components changes, you also have to change the report or analysis. That is why we recommend you use your own wage summaries. In a wage summary you can determine yourself which wage components, calculation bases and parameters are included. In addition, you can also determine whether a deduction should be included in a wage summary negatively or positively. An additional advantage is that if the payroll configuration changes because of new wage components, you only have to add them to the wage summary. This means you do not have to create a new report or analysis. You can find more information about this in the AFAS KnowledgeBase.

You can include the following values from the salary processing:

• Wage summary, List concept (Cumulative), Wage summary (periodic) and Wage summary (non-periodic)
• Basis en Basis (Cumulative)
• Value wage component en Value wage component (Cumulative)
• Value parameters from salary processing en Value parameters from master data
• Calculation basis en Calculation basis (cumulative)

To change the data collections for Payroll:

In this example you use a report that is based on the data collection Employee/wage details in columns (selected period only).

1. Go to: HR / Output / Management / Payroll report.
2. Open the report: you want to change.
3. Click on: Modify.

   

4. Click on: Modify.

   Profit displays the Extra fields view showing the fields added previously.

   1. Click on: New.
   2. Select the type of the field you want to add, for example Wage summary.
   3. Select the field, for example the Aangifte Loonbelasting: 1a. Brutoloon SV wage summary. You can change the description of this field that is shown in the data collection.
   4. Click on: Finish.

   Profit shows the new field in the Extra fields view. You can use the above steps to add additional fields.

   

5. Click on: OK.
6. Click on Next several times and then click on Finish to complete the wizard.

   You return to the report layout.

7. Click on: Modify.
8. Click on: Next.
9. Open the Extra fields category. This is where you find the fields you have added.
10. Move the fields to Fields in query:.

    

11. Click on Next several times and then click on Finish to complete the wizard.

See also

• Reservation for holiday allowance on the pay slip
• Change the order of the wage components
• Quantity and Basis on the pay slip