问题现象: | 本月结账发现对账提示总账辅助账对账不平,检查数据发现从2月份开始出现不平的情况,错误信息是借方金额不平,贷方金额不平和金额不平三种提示,检查不平科目的数据发现,从2月份开始gl_accass中客户、供应商存在重复记录,清除重复记录后,借方贷方对账正常,但是2月期初金额和1月份的期末金额不一致,烦请集团帮忙处理,多谢!数据上传至u8henan目录下瑞华.zip 徐涛 13849055472 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【注意事项】修改前请务必做好数据备份; 1、恢复记账到期初 2、期末-对账-检查,生成错误记录表gl_merror 3、执行脚本删除垃圾好数据 delete from gl_accass where csup_id in ( select b.cvencode From gl_merror a join vendor b on rtrim(ltrim(a.cassname))=b.cvenname where a.ccode=2121 ) delete from gl_accass where csup_id in ( select b.cvencode From gl_merror a join vendor b on rtrim(ltrim(a.cassname))=b.cvenname where a.ccode=1151 ) delete from gl_accass where ccus_id in ( select b.ccuscode From gl_merror a join customer b on rtrim(ltrim(a.cassname))=b.ccusname where a.ccode=2131 ) delete from gl_accass where ccus_id in ( select b.ccuscode From gl_merror a join customer b on rtrim(ltrim(a.cassname))=b.ccusname where a.ccode=1131 ) 4、手动补充1151科目gl_accass表数据,30G997金额 1230;02Z028 金额68800 5、重新记账、结账 |
相关补丁: | |
版本: | 8.90 |
模块: | 总账 |
产品: | 财务会计 |
问题名称: | 总账辅助账对账不平 |
最后更新: | 2011-07-26 23:19:28 |