Skip to content


Calculated Field Error – Ambiguous Column Name

Jay asked 2 years ago
Smartlist – Sales – Receivables Transactions : Join Sales Transaction smartlist.
Creating calculated field using both smartlist data and getting an error for the field that exist in both smartlist, like “Discount taken Amount” field. here is an example Calculated field :  {Receivables Transactions:Sales Amount} – {Receivables Transactions:Applied Amount} – {Sales Transactions:Discount Taken Amount} – {Receivables Transactions:Write Off Amount}
ERROR : There is an error in the calculated field [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘DISTKNAM’.

If you would like to submit an answer or comment, please sign in to the eOne portal.