| 解决方案： |
在查询分析器中针对错误帐套的06年度执行下面的语句，根据销售发票上的部门更改应收应付明细表中同一发票号的部门： update ap_detail set cDeptCode=cdepcode from ap_detail inner join ap_closebills on ap_detail.icoclosesid=ap_closebills.id where cDeptCode is null update ap_detail set cDeptCode=salebillvouch.cdepcode from ap_detail inner join salebillvouch on ap_detail.cDwcode=salebillvouch.ccuscode and ap_detail.cCoVouchtype=salebillvouch.cvouchtype and ap_detail.cCoVouchid=salebillvouch.csbvcode where cDeptCode is null update ap_detail set cDeptCode=purbillvouch.cdepcode from ap_detail inner join purbillvouch on ap_detail.cDwcode=purbillvouch.cvencode and ap_detail.cCoVouchtype=purbillvouch.cpbvbilltype and ap_detail.cCoVouchid=purbillvouch.cpbvcode where cDeptCode is null |