应收与总账对账不平衡-用友U8

对应版本:用友U8.52对应产品线：财务系统对应模块：应收模块问题现象:在应收管理模块中，进行“与总帐对帐”选择(客户+币种)对账时，出现对账不平衡，点击详细时，报“由于录入的期初单据或制单时改变了分录方向等造成对帐不平，无法展开成详细”，再改成‘科目+客户’时,为平衡。问题原因：经过测试确实存在此问题，经过跟踪按‘客户+币种’程序所选择出：selectcDwCodeAsWLCode,convert(varchar(100),’’)AsWLName,cexch_name,sum(casewhendRegDate=’2005-01-01’theniDAmountelse0end)AsDA,sum(casewhendRegDate>=’2005-01-01’theniCAmount_selse0end)AsCA_s,sum(casewhendRegDate>=’2005-01-01’andcexch_name’人民币’theniCAmount_felse0end)AsCA_f,sum(casewhendRegDate>=’2005-01-01’theniCAmountelse0end)AsCA,convert(money,0)Asqc_s,convert(money,0)Asqc_f,convert(money,0)Asqc,convert(money,0)Asjf_s,convert(money,0)Asjf_f,convert(money,0)Asjf,convert(money,0)Asdf_s,convert(money,0)Asdf_f,convert(money,0)AsdfINTO#tempDZFromAp_DetailWherecFlag=’AR’andiFlag=’2005-01-01’andcexch_name’人民币’theniCAmount_felse0end)AsCA_f,sum(casewhendRegDate>=’2005-01-01’theniCAmountelse0end)AsCA,convert(money,0)Asqc_s,convert(money,0)Asqc_f,convert(money,0)Asqc,convert(money,0)Asjf_s,convert(money,0)Asjf_f,convert(money,0)Asjf,convert(money,0)Asdf_s,convert(money,0)Asdf_f,convert(money,0)AsdfINTO#tempDZFromAp_DetailWherecCode=’1131’andiFlag解决方案：开发已做补丁，请替换UFAPBO.DLL文件,重新注册,可以解决此问题.(执行前请做好备份)

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