問題現(xiàn)象："銷售綜合統(tǒng)計表"中的"回款金額"不對
解決方案：在查詢分析器中針對錯誤帳套的06年度執(zhí)行下面的語句，根據(jù)銷售發(fā)票上的部門更改應(yīng)收應(yīng)付明細表中同一發(fā)票號的部門： 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