1C:Enterprise 8.3. Practical Developer’s Guide. Lesson 18 (3:40). Using calculation registers. Employee accruals report

Employee accruals report

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).

Lesson 18 (3:40). Using calculation registers / Employee accruals report
Fig. 18.21. Resulting report

In Designer mode

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.

In 1C:Enterprise mode

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).

    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In 1C:Enterprise mode
    Fig. 18.27. Resulting report

Query for a data set

Let us specify the query data set.

  1. Select the Accruals register table as the data source (fig. 18.22).

    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In Designer mode / Query for a data set
    Fig. 18.22. Accruals table fields 
  2. Select the following fields from this table (fig. 18.23):
    • Employee
    • CalculationType 
    • BegOfActionPeriod
    • EndOfActionPeriod
    • Recorder
    • Result
    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In Designer mode / Query for a data set
    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).

    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In Designer mode / Query for a data set 
    Fig. 18.24. Unions/aliases
  4. Click OK.

    This completes the query creation.

Resources

Let us add the resources.

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

Settings

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
    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In Designer mode / Settings
    Fig. 18.25. Report structure and selected fields
  4. On the Sorting tab, specify sorting by Employee and Recorder fields (fig. 18.26).

    Lesson 18 (3:40). Using calculation registers / Employee accruals report / In Designer mode / Settings
    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.

Leave a Reply

Your email address will not be published.

 

1C:Enterprise Developer's Community