问题现象: | 有五家客户的单据在2011年做过核销,年度结转后,又带到2012年期初余额里了。以客户010200135为例,查询条件为客户010200135时,查出两条记录,若查询条件为客户010200135,科目1131,多出一条记录:收款单:0000005541,列表里此单据的余额不为0,点开单据后,看到余额为0(此单据在2011年做过核销)。 详见附件。 烦请集团老师协助远程处理,并告之问题产生的原因,谢谢! 客户联系人:薛先生:13552665465,61667730 |
问题原因: | |
解决方案: | 您好, 经与客户沟通,建议通过如下语句解决; 执行前,请做好备份; delete from Ap_Detail where cDwCode=N'010200135' and abs(icamount) = 180000.0000 delete from Ap_Detail where cDwCode=N'010400107' and abs(icamount) = 18500.0000 delete from Ap_Detail where cDwCode=N'060300074' and abs(icamount) = 19480.0000 delete from Ap_Detail where cDwCode=N'060300078' and abs(icamount) = 16000.0000 delete from Ap_Detail where cDwCode=N'070100416' and abs(icamount) = 9148.0000 delete from Ap_Detail where cDwCode=N'070400324' and abs(icamount) = 20000.0000 【注意事项】修改前请务必做好数据备份; |
相关补丁: | |
版本: | 8.71 |
模块: | 应收应付 |
产品: | 财务会计 |
问题名称: | 二商福岛远程—应收期初问题 |
最后更新: | 2012-01-17 14:48:47 |