解决KINGDEE帐套清除工具遗留问题

2007-12-29 19:58:10

执行KINGDEE帐套清除工具清除，发现还有少量的2006年的单据没有清除完毕，生产领料倒是一个不差都清除了，55555555

不知道这个工具怎么开发的，一点都不好用，遗留的问题总要解决，没办法，自己来处理吧,HOHO!

在SQL2K的查询分析里面执行下列语句：

update icstockbill set fcheckerid = null where fdate <'2007-01-01'
delete from icstockbill where fdate <'2007-01-01'

update icpurchase set fcheckerid = null where fdate <'2007-01-01'
delete from icpurchase where fdate <'2007-01-01'

update poorder set fcheckerid = null where fdate <'2007-01-01'
delete from poorder where fdate <'2007-01-01'

update POInStock set fcheckerid = null where fdate <'2007-01-01'
delete from POInStock where fdate <'2007-01-01'

update icsale set fcheckerid = null where fdate <'2007-01-01'
delete from icsale where fdate <'2007-01-01'

update seoutstock set fcheckerid = null where fdate <'2007-01-01'
delete from seoutstock where fdate <'2007-01-01'

update seorder set fcheckerid = null where fdate <'2007-01-01'
delete from seorder where fdate <'2007-01-01'

附件下载：
　　

06年帐清除之后单据删除

文章评论

zhengxx

2007-12-29 20:22:39

顶下先

[匿名]eric

2007-12-30 14:29:35

来学习一下先

2007-12-31 13:23:16

顶下。