清空年度账时提示已经有客户使用[333]账套[2009]，年度账，不能清除!

问题现象：清空年度账时提示已经有客户使用[333]账套[2009]，年度账，不能清除!

解决方案：经查看没有操作使用也没有任务或锁定信息，可通过在数据库中删除年度账来重新建立来操作。

微信号：yyrjlls
扫码 有偿解决 用友软件技术问题!
复制微信号

以333账套删除2009年度账为例，SQL语句：

use UFSystem

delete from UA_Account_sub where cAcc_Id=333 and iYear=2009

delete from UA_BackupLog where cAcc_Id=333 and iYear=2009

delete from UA_BackupPlans where cAcc_Id=333 and iYear=2009

delete from UA_HoldAuth where cAcc_Id=333 and iYear=2009

delete from UA_Log where cAcc_Id=333 and iyear=2009

delete from UA_Period where cAcc_Id=333 and iYear=2009

delete from UA_Task where cAcc_Id=333 and iYear=2009

Drop database ufdata_333_2009