T6应收制单，3月份福办部门的很多张单据都核销制单不了！其他都是正常的

T6应收制单，3月份福办部门的很多张单据都核销制单不了！其他都是正常的。

查看账套数据发现上述核销涉及的发票'20190731006248' ,'20190731006361','20190731006391','20190731006453'中的累计收款数据不对，导致制单取数借贷不平衡 解决方案：

 先取消上述问题数据的核销后，用 UPDATE SaleBillVouchs SET iMoneySum = iNatSum - iRAmount , iExchSum = iSum - iRAmount_f FROM salebillvouchs JOIN ( SELECT a.ibvid , d.sbvid , CASE WHEN a.cSign = 'Z' THEN a.iRAmount ELSE -a.iRAmount END iRAmount , CASE WHEN a.cSign = 'Z' THEN a.iRAmount_f ELSE -a.iRAmount_f END iRAmount_f FROM ( SELECT a.iBVid , a.cCoVouchID cVouchID , MAX(a.cSign) AS cSign , SUM(CASE WHEN cCoVouchType LIKE '4%' THEN CASE WHEN cCoVouchType = '48' THEN iCAmount_f - iDAmount_f ELSE iDAmount_f - iCAmount_f END ELSE CASE WHEN a.cSign = 'F' THEN iCAmount_f - iDAmount_f ELSE iDAmount_f - iCAmount_f END END) AS iRAmount_f , SUM(CASE WHEN cCoVouchType LIKE '4%' THEN CASE WHEN cCoVouchType = '48' THEN iCAmount - iDAmount ELSE iDAmount - iCAmount END ELSE CASE WHEN a.cSign = 'F' THEN iCAmount - iDAmount ELSE iDAmount - iCAmount END END) AS iRAmount FROM ( ( ( ( ( ( Ap_Detail AS a LEFT JOIN Ap_VouchType AS b ON a.cCoVouchType = b.cTypeCode ) LEFT JOIN Inventory AS c ON a.cInvCode = c.cInvCode ) LEFT JOIN Customer AS d ON a.cDwCode = d.cCusCode ) LEFT JOIN Department AS e ON a.cDeptCode = e.cDepCode ) LEFT JOIN Person AS f ON a.cPerson = f.cPersonCode ) LEFT JOIN paycondition g ON a.cPayCode = g.cPayCode ) LEFT JOIN settlestyle h ON a.cSSCode = h.cSSCode WHERE iFlag < 3 AND a.cFlag = 'AR' GROUP BY cDwCode , cCoVouchType , cCoVouchID , a.iBVid ) a INNER JOIN salebillvouch d ON a.cVouchID = d.csbvcode INNER JOIN salebillvouchs b ON a.ibvid = b.autoID WHERE CASE WHEN a.cSign = 'Z' THEN a.iRAmount_f ELSE -a.iRAmount_f END <> b.iSum - b.iExchSum ) c ON salebillvouchs.autoid = c.ibvid AND salebillvouchs.sbvid = c.sbvid WHERE salebillvouchs.sbvid IN ( SELECT sbvid FROM salebillvouch WHERE csbvcode IN ( '20190731006248' ,'20190731006361','20190731006391','20190731006453' ) );

语句修复涉及发票的累计收款数据之后，在进行核销，核销后在进行制单，修复前请备份账套数据。