T+13.0 进货单上面现结金额多了，但是多的金额没传到付款单

进货单上面现结金额多了，但是多的金额没传到付款单，有很多，可以把进货单上面现结金额多的那条删除吗？

问题回复：

备份好数据，修复数据的脚本如下： 

--查询到的客户有错误的现结金额的进货单 SELECT * FROM dbo.PU_PurchaseArrival WHERE id IN ( SELECT idPurchaseArrivalDTO FROM dbo.PU_PurchaseArrival_MultiSettle GROUP BY idPurchaseArrivalDTO,idbankaccount,idsettlestyle HAVING COUNT(idPurchaseArrivalDTO+idbankaccount +idsettlestyle) > 1 ) 

--删除错误的现结金额数据 DELETE FROM dbo.PU_PurchaseArrival_MultiSettle WHERE id IN ( SELECT id FROM dbo.PU_PurchaseArrival_MultiSettle WHERE idPurchaseArrivalDTO IN ( SELECT idPurchaseArrivalDTO FROM dbo.PU_PurchaseArrival_MultiSettle GROUP BY idPurchaseArrivalDTO,idbankaccount,idsettlestyle HAVING COUNT(idPurchaseArrivalDTO+idbankaccount +idsettlestyle) > 1 ) GROUP BY id,idPurchaseArrivalDTO EXCEPT SELECT MAX(id) FROM dbo.PU_PurchaseArrival_MultiSettle WHERE idPurchaseArrivalDTO IN ( SELECT idPurchaseArrivalDTO FROM dbo.PU_PurchaseArrival_MultiSettle GROUP BY idPurchaseArrivalDTO,idbankaccount,idsettlestyle HAVING COUNT(idPurchaseArrivalDTO+idbankaccount +idsettlestyle) > 1 ) GROUP BY idPurchaseArrivalDTO )