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

最新推荐文章于 2023-03-02 14:16:36 发布

weixin_34150224

最新推荐文章于 2023-03-02 14:16:36 发布

阅读量85

点赞数

本文链接：https://blog.csdn.net/weixin_34150224/article/details/85137004

版权

执行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'

关注