When any user chooses the Purchase Order Transaction Nav Pane with a certain date range they get the error:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK##0381949'. Cannot insert duplicate key in object 'dbo.##0381949'.
The Temp table above doesn't contain any duplicates, neither do the POP10100 or POP10110 tables. It only happens in one company. I've also narrowed it down to a certain number of dates.
I've seen different fixes for post upgrade, SOP tables, and GL or UPR tables, but none for the Purchasing tables.
If anyone has seen something like this or has any ideas please let me know.
Debug Shows this:
'CustomDates OK Button_CHG on form syTrxList'
'ApplyDateRestriction of form syTrxList', 3592, 1
'List_Refresh of form syListObj', 1-0-0-1-0-0-0-0, 4, 0, 0
'RefreshList of form syTrxList', 0, 4, 0
'Refresh of form ListObj_PurchasingTrx', 1-0-0-1-0-0-0-0, 4, "Document Number", 2
'LoadPurchasingTrxListData', 0, "##0381949", 12, 1007, 7/2/2012, 8/3/2012, 1, 0, 2, "", 0
