畅捷通T+软件固定资产模块反启用,删除固定资产所有数据SQL语句

[全站通告] 想快速节省您的时间并可接受付费的朋友,可扫右边二维码加博主微信-非诚勿扰!

【问题描述】
畅捷通T+软件,固定资产模块反启用。

场景:购买软件只有总账模块,不小心启用了固定资产,结账3期后就成演示期了。

【解决方法】

针对账套库执行如下脚本清除资产的所有数据,
执行前请与客户确认资产的所有数据都不要了,确认后备份账套再执行脚本,切记!!!
然后反启用固定资产。

delete from AM_Asset

delete from AM_Attachment

delete from AM_Maintain

delete from AM_UseDept

delete from AM_CheckRangeDetail

delete from AM_CheckDetail

delete from AM_CheckUseDept

delete from AM_CheckVoucher

delete from AM_OldCheckUseDept

delete from AM_DeprSummary

delete from AM_HandleVoucher

delete from AM_HandleVoucherChangeType

delete from AM_HandleVoucherDept

delete from AM_HandleVoucher_b

delete from AM_SplitDetail

delete from AM_SplitVoucher

delete from AM_T_SearchItem_Ext

delete from AM_T_SearchItemCtrlInfo_Ext

 

发表回复

加入本站SVIP会员,海量资源免费查看下载

目前为止共有167位优秀的SVIP会员加入! 立即加入!