The field "Base currency ID" appears more than once in the list of smart query output fields. Field names must be unique.

When creating a Smart Query from an ad-hoc revenue query with more than one 'amount' field of any type the user sees the error: The field "Base currency ID" appears more than once in the list of smart query output fields.  Field names must be unique.

This occurs because for each amount field the system adds a new [V_QUERY_REVENUE].[BASECURRENCYID] field to the query.
Pending.

Steps to Duplicate

1.  Create a new ad-hoc revenue query.
2.  Add any two amount fields: 'Amount, Original Pledge Amount, Original Payment Amount, etc'
3.  Save and close the query.
4.  Create a new Smart Query from the ad-hoc query.
5.  On saving the Smart Query the error will be displayed.

Was this article helpful?