用友软件销售综合统计表查询不对

问题现象："销售综合统计表"中的"回款金额"不对

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