Adding Currency Fields to Views and Reports

Views and reports showing individual cost records in Budget and/or Payment Currency display the currency symbol before the amount value.

To display a field that stores amount in Budget Currency:

  • Add the field to the data source:

// Cost field to add to the view for the Budget Currency.

<field table="cost" name="amount_income">

To display a field that stores amount in Payment Currency:

  1. Add the cost field to the data source.
  1. Add the hidden field that contains the payment currency:

    // Cost field to add to the data source for Payment Currency.

    <field table="cost" name="amount_income_payment">

    // Hidden currency field to add to the data source.

    <field table="cost" name="payment_currency" hidden="true">

  2. Then add the cost field to the panel:

    // Cost field to add to the panel for Payment Currency.

    <field table="cost_trans" name="amount_income_payment">

If you want to hide a field when the VAT and multicurrency support is disabled, add the hidden attribute to the panel:

hidden="${activityParameters['AbCommonResources-EnableVatAndMultiCurrency']==0}"