解决方案: |
您好,经过检查分析,此数据原因是因为年结后修改期初明细导致,如:将A客户的余额或部分余额调整的B客户,总数虽然没有变但会导致问题现象,通过下面脚本可以将所有差异调整出来(脚本是检查2004年与2003年): select * from (select cdept_id,cperson_id,ccus_id,csup_id,citem_class,citem_id,ccode,sum(case when cbegind_c_engl='dr' then mb else -mb end) as mb from ufdata_001_2004..gl_accass where iperiod=1 group by cdept_id,cperson_id,ccus_id,csup_id,citem_class,citem_id,ccode) a full join (select cdept_id,cperson_id,ccus_id,csup_id,citem_class,citem_id,ccode,sum(case when cendd_c_engl='dr' then me else -me end) as me from ufdata_001_2003..gl_accass where iperiod=12 group by cdept_id,cperson_id,ccus_id,csup_id,citem_class,citem_id,ccode) b on isnull(a.cdept_id,0)=isnull(b.cdept_id,0) and isnull(a.cperson_id,0)=isnull(b.cperson_id,0) and isnull(a.ccus_id,0)=isnull(b.ccus_id,0) and isnull(a.csup_id,0)=isnull(b.csup_id,0) and isnull(a.citem_class,0)=isnull(b.citem_class,0) and isnull(a.citem_id,0)=isnull(b.citem_id,0) and a.ccode=b.ccode where isnull(a.mb,0)<>isnull(b.me,0) 鉴于上面原因无法通过脚本进行调整,可按照电话沟通内容:采用重新结帐或将所有凭证取消审核记帐反结帐到元月份然后在期初余额内手工修改。 |