特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品6-8折优惠。
问:清空年度账时提示: 账套[004]年度[2007]正在被使用
答:经查看没有操作使用也没有任务或锁定信息,可通过删除年度账来重新建立来操作。
以001账套删除2007年度账为例,SQL语句:
use UFSystem
delete from UA_Account_sub where cAcc_Id=001 and iYear=2024
delete from UA_BackupLog where cAcc_Id=001 and iYear=2024
delete from UA_BackupPlans where cAcc_Id=001 and iYear=2024
delete from UA_HoldAuth where cAcc_Id=001 and iYear=2024
delete from UA_Log where cAcc_Id=001 and iyear=2024
delete from UA_Period where cAcc_Id=001 and iYear=2024
delete from UA_Task where cAcc_Id=001 and iYear=2024
Drop database ufdata_001_2024
客服电话:400-665-0028
关键字:财务软件,畅捷通软件,财务软件,进销存软件,U9官网,U8,KIS,K3,云星空,云星辰,T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,速达软件