问题现象:这几天年结问题真是越来越火热,继昨天的话题,继续说说库存模块常见报错。购销存结转,提示库存系统结转现存量数据失败。
解决方案:请备份好数据(重要),执行下图脚本;小伙伴们肯定会好奇语句中各表中文名疑问,不要着急,请参照往期回顾:
微信号: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
以上是部分脚本参考,具体请自行脑补。
网友评论