问题现象: | 应收应付年度结转时报错,经查应是由于"在ap_detail表中存在的单据在ap_closebill中不存在"引致的,但记录比较多,请帮忙! [2012-1-11 12:04:28 补充] 已上传数据201201110066 .rar |
问题原因: | |
解决方案: | 您好, 电话给您,被挂断,?? 经核对数据,现做如下答复: 结转失败,原因: ap_detail表中的单据记录,比Ap_CloseBill表中的记录多,即应收单据,应付单据的记录与审核后至ap_detial表中记录少了很多; 而且有些单据是上年度的单据,没法补回来,多出来的单据可以通过如下语句来查找: --应收: select from Ap_Detail where iFlag<3 And cFlag='AR' And cCoVouchType LIKE '4%' and cVouchID not in ( Select cVouchID From Ap_CloseBill Where cVouchType='48' and cFlag='AR' ) --应付: select from ap_detail Where iFlag<3 And cFlag='AP' And cCoVouchType LIKE '4%' and cVouchID not in ( Select cVouchID From Ap_CloseBill Where cVouchType='48' and cFlag='AP' ) 在不影响现有数据的情况下,可以通过如下方法来实现结转; 1、把2011年年度账备份了, 2、执行如下语句,把多余记录删除了,再做结转; 3、还原2011年年度账; 4、调整2012年期初数; 语句如下: delete from Ap_Detail where iFlag<3 And cFlag='AR' And cCoVouchType LIKE '4%' and cVouchID not in ( Select cVouchID From Ap_CloseBill Where cVouchType='48' and cFlag='AR' ) delete from ap_detail Where iFlag<3 And cFlag='AP' And cCoVouchType LIKE '4%' and cVouchID not in ( Select cVouchID From Ap_CloseBill Where cVouchType='48' and cFlag='AP' ) 【注意事项】修改前请务必做好数据备份; |
相关补丁: | |
版本: | 8.51A |
模块: | 应收应付 |
产品: | 财务会计 |
问题名称: | 应收应付年度结转时报错 |
最后更新: | 2012-01-21 23:56:05 |