Creating query-based calculation parameter

This section can be useful for those who can write queries in the 1C programming language.

To create a query-based calculation parameter:

Go to Payroll.
Under Catalogs, click Earnings calculation parameters.
In the Earnings calculation parameters catalog, click Create.
In the Calculation parameter (create) window, do one of the following:
- To populate the calculation parameter settings from a template, click Fill in from template. Then select a query-based template (Normal working days, Standard hours, Hours worked by jobs). To choose between the templates, consider the description of the default calculation parameters the templates are based on. As you select a template, the parameter general settings and query text are populated. You can edit them. To do this, go to steps 5-6.
- To fill in a query text manually, go to step 5.

Specify general settings of a calculation parameter:

Field	Description
Name	A calculation parameter name.
Identifier	A calculation parameter unique ID. It is applied to include the calculation parameter in the calculation formula of an earning or deduction. For details, see Creating earnings and deductions. By default, the ID is based on the calculation parameter name with spaces excluded and each word starting with a capital letter. You can edit the default ID.
Specify value manually in Payroll document	Clear the checkbox to indicate that a parameter is dynamic.
Specify query text manually	Select the checkbox to indicate that a parameter is query-based.

On the Query tab, click Edit query and enter the query text in the 1C programming language.
If you include parameters in the query text, they are automatically added to the Parameters tab.
Note. If 1C:Drive was installed with the Thick client option enabled, you can create a query text using the Query designer tool. To do this, click Query designer.
On the Parameters tab, specify the parameter values.
Click Save and close.

<< Prev Next >>