AnsweredAssumed Answered

Attempting to pull data from Great Plains, Cash Receipt transaction. Keep Getting Ambiguous column name 'Cash_Receipt!2!RMDTYPAL!element' error....

Question asked by DavidDarnell8041 on Sep 17, 2013
Latest reply on Sep 25, 2013 by anton_damiani

     I am attempting to pull data from Great Plains, Cash Receipt transaction.  Keep getting error: Ambiguous column name 'Cash_Receipt!2!RMDTYPAL!element'  which si believe is related to the fact that GP has the sme data element name in the profile twice. Once as the first data element and again down in the body of the list.  
     Any ideas about how to overcome this ambiguity?
     I tried re-naming the elements in my profile but that doesn't seem to have any effect, it is a error from the initial query which seemd prior to the profile...

     cli.System.Data.SqlClient.SqlException: Ambiguous column name 'Cash_Receipt!2!RMDTYPAL!element'.

Outcomes