Let us see how one can use the data that is stored in the calculation register to get an aggregate employee accruals report (fig. 18.21).

Fig. 18.21. Resulting report

Let us proceed to report creation.

1. Create a Report configuration object named EmployeeAccruals.
2. Run the Data composition schema wizard.
3. Add Data set – query and run the Query builder.

Let us check the report.

1. Start 1C:Enterprise in the debug mode.
2. In the Payroll section, open the Employee accruals report and then click Create (fig. 18.27).
   
   
   Fig. 18.27. Resulting report

Let us specify the query data set.

1. Select the Accruals register table as the data source (fig. 18.22).
   
   
   Fig. 18.22. Accruals table fields 
2. Select the following fields from this table (fig. 18.23):
   • Employee
   • CalculationType 
   • BegOfActionPeriod
   • EndOfActionPeriod
   • Recorder
   • Result
   
   Fig. 18.23. Fields selected for the query
3. Click the Unions/Aliases tab and set the aliases for the BegOfActionPeriod and EndOfActionPeriod fields (fig. 18.24).
   
    
   Fig. 18.24. Unions/aliases
4. Click OK.
   
   This completes the query creation.

Let us add the resources.

• On the Resources tab, specify that the total is calculated by the Result field.

Let us specify the report structure.

1. On the Settings tab, create a grouping by the Employee field.
2. Within this grouping, create a subordinate <Detailed records> grouping.
3. On the Selected fields tab, select the fields that you want displayed in the report (fig. 18.25):
   • CalculationType
   • Beginning Date
   • EndDate
   • Recorder
   • Result
   
   Fig. 18.25. Report structure and selected fields
4. On the Sorting tab, specify sorting by Employee and Recorder fields (fig. 18.26).
   
   
   Fig. 18.26. Report sorting settings
5. On the Other settings tab, set the report title to Employee accruals.
6. Close the data composition schema wizard and then, in the editor of the EmployeeAccruals report configuration object, click the Subsystems tab.
7. Include the report in the Payroll and Accounting subsystems.