Question : Merge item code prompted application error – Violation of PRIMARY KEY constraint PK_ItemLocationPrice. Cannot insert duplicate key in object dbo.ItemLocationPrice.
Version : 1.8 / 1.9 / 2.0
Possible Reason :
Both Item 1 and Item 2 have records for Item Price by Location. This is a conflict for item merge.
1) Go to Stock > More Stock Maintenance > Item Price by Location Maintenance.
2) Check the checkbox of one selected record to delete and click on Save.
3) Perform again change and merge item code, it will be completed successfully.
By : Zhi Lin 200807, Lay Swan 200824, P200826
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations