Hello,
we are on 10.0 and recently created a UD field in our TEST environment. However we ended up not implementing the UD field into LIVE. Then we refreshed TEST with LIVE, TEST having the UD and LIVE not having it. Now when I try to search and open customer shipment records (it was a shiphead ud) I get and error with the name of the UD we created saying:
An error occurred while executing the command definition. See the inner exception for details.
Exception caught in: Epicor.ServiceModel
Error Detail
Description: An error occurred while executing the command definition. See the inner exception for details.
Inner Exception: Invalid column name ‘Incoterms_c’.
Program: System.Data.Entity.dll
Method: ExecuteStoreCommands
Original Exception Type: EntityCommandExecutionException
Framework Method: InvokeSingle
Framework Line Number: 0
Framework Column Number: 0
Framework Source: InvokeSingle<TContext,TQuery,TResult> at offset 1349 in file:line:column :0:0
Incoterms was the ud that was added.
my question is did we miss a step or how do I move forward from here? Should I try to create the UD field in the refreshed TEST environment and re-sync the data model or did we miss a step when refreshing from LIVE the first time? Wouldn’t the UD field be removed when TEST was refreshed, if not how do we remove it?
Thanks for taking the time to look at my issue.