用友软件销售统计表时报错：操作数数据类型varchar对于sum运算符无效。-用友T3

用友软件销售统计表时报错：操作数数据类型varchar对于sum运算符无效。

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

原因分析：数据库中数据表rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef异常，数据错乱。

问题解答：请做好帐套备份，删除该年度帐中rpt开头的7张表，从演示帐套或正常帐套中把这7张表导过去。导入请在账套库下执行：drop table rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdefselect * into rpt_flddef from UFDATA_999_2011..rpt_flddefselect * into rpt_fltdef from UFDATA_999_2011..rpt_fltdefselect * into rpt_glbdef from UFDATA_999_2011..rpt_glbdefselect * into rpt_grpdef from UFDATA_999_2011..rpt_grpdefselect * into rpt_reldef from UFDATA_999_2011..rpt_reldefselect * into rpt_folder from UFDATA_999_2011..rpt_folderselect * into rpt_itmdef from UFDATA_999_2011..rpt_itmdefUFDATA_999_2011为999演示账套。

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