Basic Area Settings Sub-Elements
Elements, attributes, and possible values
<basicareasettings>
Path: <area><settings><basicareasettings>
Contains basic area settings.
Handling of the +/- sign
<show_dk_profit>
Path: <area><settings><basicareasettings><show_dk_profit>
The parameter definitions are inherited, for example, from a report to a drill-down template.
Defines how debit and credit values are shown on input templates and reports for scalable income accounts. Applies to all accounts which have sign handling setting Profit.
By default (if this parameter is not used in the input or report template definition file), figures are shown as they appear in the database multiplied by the D/C code of the account (debit +1 or credit -1). Note that intragroup items are multiplied by -1 when saved into the database and retrieved to an input template.
For more information and examples of the parameter usage, see Examples for Using show_dk Parameter.
Possible values:
-
no: All figures are shown on the input and report template as they appear in the database multiplied by the account's D/C code (debit +1 or credit -1).
A positive figure means the default balance of the account (debit/credit)
-
sign: All figures are shown on the input and report template as they appear in the database.
A positive figure means the debit balance of the account (negative = credit)
-
inverted sign: All figures are shown in the input and report template as multiplied by - 1.
A positive figure means the credit balance of the account (negative = debit)
<show_dk_balance>
Path: <area><settings><basicareasettings><show_dk_balance>
Defines how debit and credit values are shown on input templates and reports for scalable balance accounts. Applies to accounts which have sign handling setting Balance.
By default (if this parameter is not used in the input or report template definition file), figures are shown as they appear in the database multiplied by the D/C code of the account (debit +1 or credit -1). Note that intragroup items are multiplied by -1 when saved into the database and retrieved to an input template.
For more information and examples of the parameter usage, see Examples for Using show_dk Parameter.
Possible values:
no: All figures are shown on the input and report template as they appear in the database multiplied by the account's D/C code (debit +1 or credit -1).
sign: All figures are shown on the input and report template as they appear in the database.
inverted sign: All figures are shown in the input and report template as multiplied by – 1.
The parameter definitions are inherited, for example, from a report to a drill-down template.
<show_dk_other>
Path: <area><settings><basicareasettings><show_dk_other>
Defines how debit and credit values are shown on input templates and reports for scalable other accounts. Applies to accounts which have sign handling setting Other.
By default (if this parameter is not used in the input or report template definition file), figures are shown as they appear in the database multiplied by the D/C code of the account's (debit +1 or credit -1). Note that intragroup items are multiplied by -1 when saved into the database and retrieved to an input template.
For more information and examples of the parameter usage, see Examples for Using show_dk Parameter.
Possible values:
no: All figures are shown on the input and report template as they appear in the database multiplied by the account's D/C code (debit +1 or credit -1).
sign: All figures are shown on the input and report template as they appear in the database.
inverted sign: All figures are shown in the input and report template as multiplied by – 1.
The parameter definitions are inherited, for example, from a report to a drill-down template.
Handling of currencies
<currency>
Path: <area><settings><basicareasettings><currency>
Defines the currency used for calculation. Only used for numeric data fields (not for 'extra' or 'formula' fields; see <datafield>). In input, the <currency> element can be used only when the amount type is group (<datafield><numeric amount="group">). In reporting, the <currency> element can be used with both values of the amount attribute (group and unit). See Currency Conversion for an overview of currency conversion with different <currency> element and amount attribute settings.
The <currency> element in reports is inherited to drill-down and TR templates. If the drill-down and TR templates include their own <currency> elements, these definitions are stronger.
Converting with cumulative currency rates is not possible in Transparent Reporting when all invoices are shown. In this case an error message is shown to the user. When documents are shown by periods, converting with cumulative currency rates is possible.
Input and reporting is possible in a third currency (some other currency than unit or group currency) when the <currency> element is defined in the basic area or data column settings. The <currency> element defined in the data column settings is stronger than the one defined in the basic area setting. If the <currency> element is not defined in the data column settings, its value is inherited from the basic area settings. If the <currency> element is also missing also from the basic area settings, no currency conversions will be performed.
Possible values:
Identifier of the currency
Variable %USERCURRENCY%: The identifier of the currency selected in the input or report template Advanced Options tab (group currency, unit currency, or a third currency).
<currency_conversion_dimension>
Path: <area><settings><basicareasettings><currency_conversion_dimension>
Not in use.
Other area basic settings
<show_deleted accounts>
Path: <area><settings><basicareasettings><show_deleted_accounts>
Not in use.
<sum_by_accno>
Path: <area><settings><basicareasettings><sum_by_accno>
Not in use.
<drilldown_action>
Path: <area><settings><basicareasettings><drilldown_action>
Defines whether the account statement function is used in the area. With the account statement function users can enter data to type 2 document series (for example, 20000) by drilling down.
The account statement function can be used in predefined type input templates (<presentationtype>predefined</presentationtype> in area settings), but not in retrievefromdata type templates (<presentationtype>retrievefromdata</presentationtype>).
Possible values:
normal: The account statement function is not used in the area. This is the default value.
account_statement: The account statement function is used in the area.
<drilldown_copyformula>
Path: <area><settings><basicareasettings><drilldown_copyformula>
Sets a template to behave so that the internal transactions opened as drill-down rows get the same formula as set for the main account level cell.
Possible values:
true
false (default)
The setting has effect only if <area><settings><basicareasettings><drilldown_action>=account_statement (such as account statement drill-down for internal transactions) is in use in the same template
<add_accounts_from_excel>
Path: <area><settings><basicareasettings><add_accounts_from_excel>
Defines whether the definitions made in the Excel template overrides the definitions made in the xml definitions, for example, when fetching account data.
To increase the performance, the parameter can be used to basic reports which have maximum of 200 accounts defined in the Excel file of the template. If more than 200 accounts are defined, performance may decrease due to too many accounts.
add_accounts_from_excel element must be defined to all areas of the sheet. Areas without the parameter remain empty.
Possible values:
true
false (default)
<hide_sum_accounts>
Path: <area><settings><basicareasettings><hide_sum_accounts>
Defines whether sum rows are shown or hidden. Used in reconciliation reports.
Possible values:
true
false (default)
Examples for Using show_dk Parameter
This topic describes three examples for using the show_dk parameter.
The show_dk parameters only apply to scalable accounts.
Default Case
By default (if the show_dk parameter is not used in the input or report template definition file), figures are shown on input and report templates as they appear in the database multiplied by the D/C code of the account (debit +1 or credit -1).
Document series type |
Account |
Input |
Database |
Reported |
|---|---|---|---|---|
PL & BS (Input) |
Credit Account |
100 |
-100 |
100 |
PL & BS (Input) |
Debit Account |
50 |
50 |
50 |
Intragroup (Internal)* |
Credit Account |
10 |
10 |
-10 |
Intragroup (Internal)* |
Debit Account |
5 |
-5 |
-5 |
|
Eliminations (Other Entries) |
Credit Account |
10 |
-10 |
10 |
|
Eliminations (Other Entries) |
Debit Account |
5 |
5 |
5 |
*Intragroup transactions are multiplied by -1 when saved into the database. Intragroup transactions are also multiplied by -1 when retrieved from the database to an input column (to a column with the definition type=input ), but not when retrieved from the database to a report column (to a column with the definition type=report).
10000 and 70000 Doc. Series with show_dk Parameter
Input definition | |||
|---|---|---|---|
|
NO |
SIGN |
INVERTED SIGN |
Credit account |
1000 |
-1000 |
1000 |
Debit account |
1000 |
1000 |
-1000 |
Database |
|
|
|
|
DB |
DB |
DB |
Credit account |
-1000 |
-1000 |
-1000 |
Debit account |
1000 |
1000 |
1000 |
Report definition |
|
|
|
|
NO |
SIGN |
INVERTED SIGN |
Credit account |
1000 |
-1000 |
1000 |
Debit account |
1000 |
1000 |
-1000 |
20000 Doc. Series with show_dk Parameter
Input definition | |||
|---|---|---|---|
|
NO |
SIGN |
INVERTED SIGN |
Credit account |
1000 |
-1000 |
1000 |
Debit account |
1000 |
1000 |
-1000 |
Database |
|
|
|
|
DB |
DB |
DB |
Credit account |
1000 |
1000 |
1000 |
Debit account |
-1000 |
-1000 |
-1000 |
Report definition |
|
|
|
|
NO |
SIGN |
INVERTED SIGN |
Credit account |
-1000 |
1000 |
-1000 |
Debit account |
-1000 |
-1000 |
1000 |
Currency Conversion
The following table provides an overview of currency conversions with different <currency> element and <datacolumn><datafield><numeric> amount attribute values.
'amount' attribute |
<currency> element and user selections |
Used in |
Currency conversion |
|---|---|---|---|
unit |
No value for the <currency> element |
Input and report templates |
No calculations are done. Data is retrieved from the database in the currency of the selected unit. |
unit |
Third currency (for example, USD) as the value of the <currency> element |
Reports |
Unit amounts are converted to group currency and then to the third currency. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. A currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts are converted to group currency and then to the selected third currency. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. Unit currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts are converted to group currency and then to the unit currency of the selected unit. For reports which have different units (for example, generate reports or reports which have dim00 defined in the definition file), the values of all units are converted to the currency of the unit selected on the Basic Options tab. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. Group currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts is converted to group currency. |
group |
No value for the <currency> element |
Input and report templates |
No calculations are done. Data is retrieved from the database in the group currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. |
group |
Third currency (for example, USD) as the value of the <currency> element |
Input and report templates |
Group amounts are converted to the third currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. A currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
Group amounts are converted to the selected third currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. Unit currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
Group amounts are converted to the unit currency of the selected unit. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. Group currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
No currency conversions are done when retrieving data. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. |