销售综合统计表查询不对-用友U8

对应版本:用友U8.51A对应产品线：供应链对应模块：销售管理模块问题现象:”销售综合统计表”中的”回款金额”不对问题原因：由于应收应付明细表（ap_detail)中，有些销售发票的部门为空，导致查询时，无法将收款数据插入到临时表中，所以查询不出来数据。解决方案：在查询分析器中针对错误帐套的06年度执行下面的语句，根据销售发票上的部门更改应收应付明细表中同一发票号的部门：updateap_detailsetcDeptCode=cdepcodefromap_detailinnerjoinap_closebillsonap_detail.icoclosesid=ap_closebills.idwherecDeptCodeisnullupdateap_detailsetcDeptCode=salebillvouch.cdepcodefromap_detailinnerjoinsalebillvouchonap_detail.cDwcode=salebillvouch.ccuscodeandap_detail.cCoVouchtype=salebillvouch.cvouchtypeandap_detail.cCoVouchid=salebillvouch.csbvcodewherecDeptCodeisnullupdateap_detailsetcDeptCode=purbillvouch.cdepcodefromap_detailinnerjoinpurbillvouchonap_detail.cDwcode=purbillvouch.cvencodeandap_detail.cCoVouchtype=purbillvouch.cpbvbilltypeandap_detail.cCoVouchid=purbillvouch.cpbvcodewherecDeptCodeisnull

本文链接：https://www.bbsufida.com/u8/45730.html