Skip to content
+1-888-319-3663

COMMUNITY FORUM

Calculated Field Error – Ambiguous Column Name

Jay asked 3 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’.
 
 
Jothi replied 2 months ago

I have the same issue when you join the same table . Joined PA01201 on the PA Projects report and it errors on calculated field PA_Receipts_Amount + PA_Actual_Receipts_Amoun as [Total Receipts].

eOne – can u pls advise.

“select
PA_Receipts_Amount + PA_Actual_Receipts_Amoun as [Total Receipts]
from (select * from PA01201 with (NOLOCK)) T1
LEFT JOIN [PRO]..PA61040 T2 with (nolock)
on
T2.[PAPROJNUMBER] = T1.PAPROJNUMBER
LEFT JOIN [PRO]..PA01409 T3 with (nolock)
on
T3.[PAPROJNUMBER] = T1.PAPROJNUMBER
LEFT JOIN [PRO]..PA01201 T4 with (nolock)
on
T4.[CUSTNMBR] = T1.CUSTNMBR and T4.[PACONTNUMBER] = T1.PACONTNUMBER and T4.[PAPROJNUMBER] = T1.PAPROJNUMBER

Thanks,


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