Pos3/5/FNB: Sync error Primary Key Error (UOM Conversion)

Question :

Error Message: Primary Key Error

Stack Trace: at AutoCount.Data.DataError.HandleSqlException(SqlException ex)

at AutoCount.Data.Sql.DBSql.SimpleSaveDataTable(DataTable table, String selectCmdText, Boolean returnIdentityColumnValue)

at AutoCount.Data.DBSetting.SimpleSaveDataTable(DataTable table, String selectCmdText, Boolean returnIdentityColumnValue)

at AutoCount.Data.DBSetting.SimpleSaveDataTable(DataTable table, String selectCmdText)

at AutoCount.Stock.StockUOMConversion.StockUOMConversionCommandSQL.SaveData(StockUOMConversion stockUOMConversion)

at AutoCount.Stock.StockUOMConversion.StockUOMConversion.Save()

at AutoCount.POS.Data.UOMConversionHelper.ApplyUOMConversion(DataTable detailTable, Int64 dockey, String docNo, Boolean noUpdateOriginalRow, Boolean isPosSync) in C:\Users\Admin\source\repos\AutoCount POS 5.x\AutoCount POS 5.x\AutoCount POS\PosPlugin\Data\UOMConversionHelper.cs:line 474

Possible Reason :

Most probably is user had used the next number on Document Numbering Format Maintenance.

Solution :

1. Go to Stock > Stock UOM Conversion > check the latest number already until what number.

2. Go to General Maintenance > Document Format Maintenance > Category: Stock > DocType: Stock UOM Conversion > Edit below format > change Next Number > OK

3. Go back POS Server Monitor Status screen > click Resync Error Trans

By: CK 20240304, Jacky 20240322 [000486]

Pos3/5/FNB: Sync error Primary Key Error (UOM Conversion)

Go to menu