Currency Conversion

<< Click to display table of contents >>

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.