T3上度賬啟用了某模塊，但年度結(jié)轉(zhuǎn)后想反啟用
發(fā)布時(shí)間：2025-1-20
人工客服
特價(jià)活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠，暢捷通T+cloud、好會計(jì)、易代賬、好業(yè)財(cái)、好生意云產(chǎn)品6-8折優(yōu)惠。
T3上度賬啟用了某模塊，但年度結(jié)轉(zhuǎn)后想反啟用
通用腳本:
模塊反啟用需要在數(shù)據(jù)為中執(zhí)行，執(zhí)行語句前修改 cacc_id 為賬套編號，UFdata_001_2022
為用戶需要反啟用的賬套庫，執(zhí)行前請備份所有賬套數(shù)據(jù)，以免執(zhí)行到其他賬套中：
——庫存
Update ufdata_001_2022..accinformation set cvalue='cdefault' where csysid='st'and ctype='ddate'
Delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='st'and iyear='2022'
Delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='st'and iyear='9999'
~~~~~~~~~~~~~~~~~~~~~~~其他模塊反啟用語句~~~~~~~~~~~~~~~~~~~~~~~~~
——應(yīng)收
Update ufdata_001_2022..accinformation set cvalue='cdefault' where csysid='ar'and ctype='ddate'
Delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='ar' and iyear='2022'
Delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='ar' and iyear='9999'6
——應(yīng)付
update ufdata_001_2022..accinformation set cvalue='cdefault'wherecsysid='ap'and ctype='ddate'
delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='ap' and iyear='2022'
delete ufsystem..ua_account_sub where cacc_id='001' and csub_id='ap' and iyear='9999'
——采購
update ufdata_001_2022..accinformation setcvalue='cdefault'wherecsysid='pu'and ctype='ddate'
delete ufsystem..ua_account_sub where cacc_id='001'andcsub_id='pu'andiyear='2022'
delete ufsystem..ua_account_sub where cacc_id='001'andcsub_id='pu'andiyear='9999'
——銷售
update ufdata_001_2022..accinformation set cvalue='cdefault'wherecsysid='sa'and ctype='ddate'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='sa'and iyear='2022'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='sa'and iyear='9999'
——核算
update ufdata_001_2022..accinformation set cvalue='cdefault'where csysid='ia'and ctype='ddate'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='ia'and iyear='2022'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='ia'and iyear='9999'
——固定資產(chǎn)
update ufdata_001_2022..accinformation set cvalue='cdefault'where csysid='fa'and ctype='ddate'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='fa'and iyear='2022'
delete ufsystem..ua_account_sub where cacc_id='001'and csub_id='fa'and iyear='9999'
