Troubleshooting: Change Item Code error - Violation of PRIMARY KEY constraint PK ItemLocationPrice

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.

Solution :

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

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations