金蝶提示违反违反了PRIMARY KEY约束,PK_POZnvBal,不能在对象POinvBal中插入重复键
一般是手动或者通过插件对数据库进行了删除操作造成的
原因:一是部份物料已经不存在,二是表中存在有以后期间的记录
--解决方案
delete from poinvbal where fitemid not in (select fitemid from t_icitem)
delete from poinvbal where fyear=(
select fvalue from t_systemprofile where fcategory='ic' and fkey='currentyear'
) and fperiod>(select fvalue from t_systemprofile where fcategory='ic' and fkey='currentperiod')
--例如:违反了PRIMARY KEY约束,PK_ICInvBal,不能在对象ICinvBal中插入重复键处理方法
--Fyear(当前账期年) --Fperiod(当前账期月)
SELECT * FROM IcBal WHERE Fyear=2020 and Fperiod=1
--DELETE FROM IcBal WHERE Fyear=2020 and Fperiod=1
SELECT * FROM IcinvBal WHERE Fyear=2020 and Fperiod=1
--DELETE FROM IcinvBal WHERE Fyear=2020 and Fperiod=1