Has anyone else had any issues with using the purchase advisor for non-inventory parts? We have some shop supplies that our purchaser wants to see the history and with the upgrade from 10.0 to 10.1 we get an error that attBatch cannot be null. I have a call in to service, but if anyone else has a quick fix on this that would be helpful.
Here’s the error message.
Application Error Error Detail ============ Message: Failed to Auto-Search; Possible invalid primary adapter defined for Erp.UI.PurchaseAdvisorEntry Inner Exception Message: Column 'AttBatch' does not allow nulls. Program: Method: Inner Exception =============== Column 'AttBatch' does not allow nulls. at System.Data.DataColumn.CheckNullable(DataRow row) 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, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException) at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent) at Erp.UI.App.PurchaseAdvisorEntry.Transaction.createPartListViewRow() at Erp.UI.App.PurchaseAdvisorEntry.Transaction.GetPurchaseAdvisorData(Boolean partExists) at Erp.UI.App.PurchaseAdvisorEntry.Transaction.adapterInvokeSearch(SearchOptions o) at Ice.Lib.Framework.EpiMultiViewTransaction.InvokeSearch(SearchOptions opts) at Erp.UI.App.PurchaseAdvisorEntry.PurchaseAdvisorEntryForm.OnClickSearch(SearchOptions options) at Ice.Lib.Framework.EpiBaseForm.DoAutoSubscriberSearch(String sColumn) at Ice.Lib.Framework.EpiBaseForm.autoSubscriberSearch()