Is anyone have issues with Purchase Advisor? We are having an error on two parts, as of right now. I simply enter in the PartNum: '1' or '2' (Please don't ask why the part name, which may be the problem) and then the error comes up. Here is the error.
Error Detail
============
Column 'Company, PartNum' is constrained to be unique. Value 'AMC, 1' is already present.
Stack Trace
===========
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Epicor.Mfg.UI.Adapters.PurchaseAdvisorAdapter.GetPurchaseAdvisor(String cPartNum, Int32 iPONum, String cAPVType, String cClassID, String cOpCode, Int32
Error Detail
============
Column 'Company, PartNum' is constrained to be unique. Value 'AMC, 1' is already present.
Stack Trace
===========
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Epicor.Mfg.UI.Adapters.PurchaseAdvisorAdapter.GetPurchaseAdvisor(String cPartNum, Int32 iPONum, String cAPVType, String cClassID, String cOpCode, Int32