You can set up each report cell independently in the Field setupform. Cell operations will vary, depending on the selected line type in the Line typefield. The following line types are available:

Line type

Data Source

Available voucher types

Transactions

Ledger transactions

Balance, Credit balance, Debit balance, Turnover, Credit activity, Debit activity, Turnover in correspondence, Turnover in correspondence Credit, Turnover in correspondence Debit, Active balance (debit), Active balance (credit)

Budget

Budget transactions

Balance, Credit balance, Debit balance, Turnover, Credit activity, Debit activity

Register

Tax registers transactions

Turnover

Constant

Determined by Financial reports generator settings

Function query

Numerical data from any table

Contractor

Customer/vendor/advance holder transactions

Active balance (debit), Active balance (credit) by counteragents, contracts, documents

  1. Click General ledger> Setup> Financial reports generator> Financial reports generator> Setupto open the Field setupform.

  2. In the lower pane, press CTRL+N to create a new line.

    Note Note

    The lower pane displays the calculation sequence for the cell value that is selected in the upper section of the Field setupform. One or more lines with amount calculation parameters can be created for each report cell in the lower section of the form. The lines are linked together with a mathematical operator.


  3. 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 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 the plus sign ( +).


  4. In the Line typefield, select the default data type for calculating the current line from the following options:

    • Transactions

    • Budget

    • Register

    • Constant

    • Function query

    • Contractor

    • Fixed requisite

    Note Note

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


  5. In the Datafield, enter the value to be used in the calculation.

    Note Note

    This field is activated when you select Constantin the Line typefield.


  6. In the Type of operationfield, select the type of operation.

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


  8. In the Fixed requisitefield, select the requisite for the cell report.

    Note Note

    This field is activated when you select Fixed requisitein the Line typefield.


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

  10. In the Account Intervalfield, select from the following options whether you want to calculate the cell for one account or for several accounts:

    • Account

    • Interval

  11. In the Accountfield, select the account for which the cell operation calculation is performed.

    Note Note

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


  12. In the Offset intervalfield, select from the following options whether one or several offset accounts are specified:

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


  13. In the Corr. Accountfield, select the ledger account that corresponds to the main account.

  14. Click the Generaltab. In the Budget modelfield, select the default budget model number.

    Note Note

    This field is activated when you select Budgetin the Datafield


  15. In the Balance detailfield, select what detail to use for calculating the active-passive balance.

    Note Note

    This field is available when you select Contractorin the Line typefield.


  16. Click the Type of transactionstab to enter transaction filter parameters based on reversing.

    Note Note

    This tab is available when you select Transactionsin the Line typefield.


  17. On the Reversing entrytab, in the Transaction usagefield, select the type of transaction to be taken into account when creating the report.

  18. Click the Type of operationtab to enter transaction filter parameters by voucher type.

  19. 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 Operations/Taxtab to specify default filter parameters.

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

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

  24. Click the Tax registerstab. In the Register codefield, select the tax calculation register code.

    Note Note

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


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

  26. Click the Dimensiontab to generate the report for a particular dimension code of ranges but not for all dimensions.

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

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

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

  30. Click Upto move the selected line one position up.

  31. Click Downto move the selected line one position down.

  32. Click Account intervalto open the Account intervalform.

    Note Note

    To activate the Account intervalbutton, select Intervalin the Account intervalor Offset intervalfield.


  33. Press CTRL+N to create a new line, and then select the ledger account range to be calculated in the Fromand Tofields.

    Note Note

    You can create a line for each account interval necessary.


  34. Click Edit the queryform to open the Query wizardto create and set up query parameters to calculate values for cell operations.

    Note Note

    To activate the Edit the querybutton, select Function queryin the Line typefield.


  35. Close the Account intervalform to return to the Field setupform.

  36. Press CTRL+S or close the form.

See Also