问题现象:用友通T3财务软件供应链年结后,销售发货单列表打不开。
解决方案:备份好数据(重要),删除rpt表,从演示帐套导过来,也可以从其他查询正常的账套引入,只需修改脚本中的年度库名称即可。 备份好数据后,请参照以下图片中语句:
微信号:yyrjlls
加微咨询技术问题!
复制微信号
加微咨询技术问题!
复制微信号
drop table rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef select * into rpt_flddef from UFDATA_999_2011..rpt_flddef select * into rpt_fltdef from UFDATA_999_2011..rpt_fltdef select * into rpt_glbdef from UFDATA_999_2011..rpt_glbdef select * into rpt_grpdef from UFDATA_999_2011..rpt_grpdef select * into rpt_reldef from UFDATA_999_2011..rpt_reldef select * into rpt_folder from UFDATA_999_2011..rpt_folder select * into rpt_itmdef from UFDATA_999_2011..rpt_itmdef alter table rpt_flddef drop column CurGroupCol,CurSubTotalCol delete from GL_bfreq delete from GL_blreq
网友评论