Adding Currency Fields to Views and Reports
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:
- Add the cost field to the data source.
-
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">
-
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}"