You can use the functions directory to create and edit functional queries, which calculate requisites based on data from the database. You can use configured functions to create values for fixed requisites. The workflow used to create a report is similar to that used to configure a report cell in the financial reports generator.

Note Note

For more information, see (EEUR) Set up the financial reports generator.


  1. Click General ledger> Setup> Financial reports generator> Functionsto open the Functionsform.

  2. Press CTRL+N to create a new line.

  3. In the Functionfield, enter an identification code for the query.

  4. In the Namefield, enter a text description for the query.

  5. Click Setupto open the Query function setupform.

  6. Press CTRL+N to create a new line.

  7. In the Operatorfield, select the function to be applied to the calculated value.

    Note Note

    The Operatorfield is used to set up the sign of the amount that is exported into the cell, and is also used as a mathematical sign when setting up multi-line composite vouchers. All credit vouchers, Voucher type - Credit balance, Credit activity, and Turnover in correspondence credit, should be marked with a minus sign ( -). By default, a new voucher line has a plus sign ( +).


  8. In the Line typefield, select the default data type from the following options:

    • Transactions

    • Budget

    • Register

    • Constant

    • Function query

    • Contractor

    • Fixed requisite

      Note Note

      By default, this data type will assume the value that is entered for the cell. You can modify the value.


  9. On the Type of transactionstab, in the Type of operationfield, select the operation type.

  10. In the Balance typefield, select the balance type.

    Note Note

    This field is activated if you select Balance, Credit balance, Debit balance, Active balance (debit), or Passive balance (credit)in the Type of operationfield.


  11. In the Periodfield, select the default voucher calculation period.

  12. In the Account intervalfield, select from the following options to calculate the cell for one account or for several accounts:

    • Account

    • Interval

  13. In the Accountfield, select the account that the calculation is to be performed for.

    Note Note

    This field is activated if you select Accountin the Account Intervalfield.


  14. In the Offset intervalfield, select from the following options to specify one or several offset accounts:

    • Account

    • Interval

      Note Note

      This field is activated when you select Turnover in correspondence, Turnover in correspondence Credit, or Turnover in correspondence Debitin the Type of operationfield.


  15. In the Offset accountfield, select the ledger account that corresponds to the main account.

    Note Note

    This field is activated if you select Accountin the Offset Intervalfield.


  16. In the Transaction usagefield, select the type of transaction to be used when creating the report.

  17. Click the Operations/Taxtab, and then press CTRL+N to create a new line.

  18. In the Posting layerfield, select the correct accounting type.

  19. Click the Type of operationtab, and then press CTRL+N to create a new line.

  20. In the Transaction typefield, select the required voucher type.

    Note Note

    The voucher type determines which module's transactions are used in generating the report.


  21. Click the Dimensionstab, and then press CTRL+N to create a new line.

  22. In the Dimensionfield, select the correct dimension type.

  23. In the Fromand Tofields, select starting and ending codes for the dimension range whose transactions are to be included in the report.

  24. On the Budgettab, in the Budget modelfield, select the default budget model number.

    Note Note

    This tab is available only when you select Budgetin the Line typefield.


  25. On the Tax registerstab, in the Register codefield, select the tax calculation register code.

    Note Note

    This tab is available only when you select Registerin the Line typefield.


  26. In the Register field, select the register field name.

  27. On the Constanttab, in the Datafield, enter the value to be used in the calculation.

    Note Note

    The constant value can be a number or a line. This tab is available only when you select Constantin the Line typefield.

    You can set up formulas that contain several Constanttype lines or line or integer values. Values are detected automatically. If numeric values are set in two consecutive lines, an arithmetic operation is completed; if at least one of them is a line, a line is created.

    For example, see the following formula:

    According to this formula, the calculations will produce the following line: 2500Rubles500Rubles900Rubles.

    Parameters that are calculated for other line types are similar to the parameters of the corresponding line types when you set cells in the financial reports generator.


Operation

Line type

Value

+

Constant

50

*

Constant

50

/

Constant

Rubles

+

Constant

500

+

Constant

Rubles

+

Constant

300

*

Constant

3

+

Constant

Rubles

See Also