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'.