问题现象:每月在存货中选正常单据记账时全选后点记账后没反应,无法记账必须运行修改存货总帐的工具后即可记账,每月都有此问题。上传的数据是4月份的。帮忙看看是什么原因
解决方案:--请先做好数据备份!
--1.请在当前月未结帐前执行如下语句: delete from ia_summary where imoth>(select max(iperiod)+1 from gl_med where bflag_ia=1)
--2.再用以下语句删除存货总帐重复记录即可 declare @imoth as it set @imoth=0 while @imoth1) ia o ia_summary.cwhcode=ia.cwhcode ad ia_summary.civcode=ia.civcode ad ia_summary.imoth=ia.imoth where autoid ot i(select mi(autoid) from ia_summary where imoth=@imoth group by cwhcode,civcode,imoth havig cout(*)>1) ad ia_summary.imoth=@imoth set @imoth=@imoth+1 ed
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)