用友软件代垫费无法生成其他应收单-用友T3

用友软件代垫费无法生成其他应收单

微信号：yyrjlls
技术咨询，有偿服务！
复制微信号

原因分析：数据错误

问题解答：2013年度帐中应收和应付模块的Accinformation表中系统启用日期字段都是Null，请用下面的脚本修复后，即可自动生成对应的应收单。请备份好用户帐套后执行。 --年度帐套应收应付启用日期缺失记录的修正 --请将下面的UFDATA_005_2012 改成对应的历史年度帐即可在2013年度帐套中执行 UPDATE AccInformation SET cValue = a.cValue FROM AccInformation INNER JOIN ( SELECT * FROM UFDATA_005_2012..AccInformation WHERE UFDATA_005_2012..AccInformation.csysid = 'AR' AND UFDATA_005_2012..AccInformation.cType = 'ddate') a ON AccInformation.cName = a.cName WHERE AccInformation.cValue IS NULL AND a.cValue IS NOT NULL AND AccInformation.csysid = 'AR' AND AccInformation.cType = 'ddate' --请将下面的UFDATA_005_2012 改成对应的历史年度帐即可 UPDATE AccInformation SET cValue = a.cValue FROM AccInformation INNER JOIN ( SELECT * FROM UFDATA_005_2012..AccInformation WHERE UFDATA_005_2012..AccInformation.csysid = 'AP' AND UFDATA_005_2012..AccInformation.cType = 'ddate') a ON AccInformation.cName = a.cName WHERE AccInformation.cValue IS NULL AND a.cValue IS NOT NULL AND AccInformation.csysid = 'AP' AND AccInformation.cType = 'ddate'

本文链接：https://www.bbsufida.com/t3/12659.html