金蝶专业版存货核算系统不能结转,提示说有未记账的单据和单价为0的单据,实际上并为找到这种单据。
这种是一般是数据库问题,必须通过语句执行。
执行以下语句,可以解决该问题,执行语句类似于动手术,记得备份好。
1.查找有问题的单据:
SELECT *
FROM ICStockBill
WHERE (FInterID IN
(SELECT finterid
FROM ICStockBillentry
WHERE fprice = '0'))
2.取消有问题单据的审核状态和审核人:
UPDATE ICStockBill
SET FStatus = '0'
WHERE (FInterID IN
(SELECT finterid
FROM ICStockBillentry
WHERE fprice = '0'))
UPDATE ICStockBill
SET fcheckerid = null
WHERE (FInterID IN
(SELECT finterid
FROM ICStockBillentry
WHERE fprice = '0'))
3.删除有问题单据主表:
DELETE FROM ICStockBill
WHERE (FInterID IN
(SELECT finterid
FROM ICStockBillentry
WHERE fprice = '0'))
4.删除有问题单据明细表表:
DELETE FROM ICStockBillEntry
WHERE (FPrice = '0')
老问题了,最近遇到,处理成功,特再发一次。
文章评论