| 解决方案： |
--成本分配入库单时单价不正确
--注意要更新单据的月份(这里是1月就有此情况,所以没有加入日期条件)
use ufdata_168_2006
go
UPDATE RdRecords
SET iUnitCost = NULL, iPrice = NULL, iSum = NULL
WHERE (ID IN
(SELECT ID
FROM RdRecord
WHERE (bRdFlag = 1) AND (cVouchType = '10')))
go
UPDATE RdRecords
SET cFree1 = NULL, cFree2 = NULL, cPosition = NULL, cFree3 = NULL, cFree4 = NULL,
cFree5 = NULL, cFree6 = NULL, cFree7 = NULL, cFree8 = NULL, cFree9 = NULL,
cFree10 = NULL
WHERE (ID IN
(SELECT ID
FROM RdRecord
WHERE (bRdFlag = 1) AND (cVouchType = '10')))
go |