畅捷通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