服务热线:

4006-6500-28

新闻资讯
联系我们

电话:400-665-0028


您当前位置:首页 > 新闻资讯  > 知识学习 > 正文知识学习
金蝶固定资产处理 --数据重写
添加时间:2022-6-1

下面脚本需要用户用备份账套反结账(最好是对每个卡片都进行改动保存一次)重新计提折旧修复了所有数据问题为前提的。

脚本是供不能反结账(有些客户要求不能跨年反结账或者 完全不能反任何一期数据的情况)或者怕财务数据会变化而不能反结账的情形(注意重新计提折旧凭证金额可能与以前凭证金额不一样了,那就说明以前计提是存在问题)。 脚本原理是通过反结账(可能加上重新改动保存凭证)重新计提折旧使计提折旧数据正确,把这部分正确的数据写入到不能反结账的正式账套中。

脚本以KIS专业版为原型研究,旗舰版和k3 基本可用(未严格测试),商贸版不能使用。


--select 'alter table '+ object_name(parent_id )+' disable trigger '+name ,* from sys.triggers where  object_name(parent_id ) like 't_fa%'

--select 'alter table '+ object_name(parent_id )+' enable trigger '+name ,* from sys.triggers where  object_name(parent_id ) like 't_fa%'

--select  '表 '+b.name+' 的触发器 '+a.name+' 被禁用了' from sys.triggers  a left join sysobjects b on a.parent_id = b.id where  a.is_disabled =1


alter table t_FADeviceBill disable trigger t_FADeviceBill_AutoNumber

alter table t_FADeviceGroupItem disable trigger t_FADeviceGroupItem_AutoNumber

alter table t_FADeviceItemDefine disable trigger t_FADeviceItemDefine_AutoNumber

alter table t_FACardItemDefine disable trigger t_FaCardItemDefine_AutoNumber

alter table t_FAAlterMode disable trigger t_FaAlterMode_AutoNumber

alter table t_FAStatus disable trigger t_FaStatus_AutoNumber

alter table t_FAGroup disable trigger t_FAGroup_AutoNumber

alter table t_FALocation disable trigger t_FaLocation_AutoNumber

alter table t_FADeprMethod disable trigger t_DeprMethod_AutoNumber

alter table t_FAEconomyUse disable trigger t_EconomyUse_AutoNumber

alter table t_FAAlter disable trigger t_FAAlter_AutoNumber

alter table t_FABalance disable trigger t_FABalance_AutoNumber

alter table t_FADevice disable trigger t_FADevice_AutoNumber

alter table t_FAGroupItem disable trigger t_FAGroupItem_AutoNumber


--下面表的删除是有顺序的,不要改动

delete t_FABalCard

delete t_FABalCardItem

delete t_FABalDept

delete t_FABalDevice

delete t_FABalExpense

delete t_FABalOrgFor

delete t_FABalPurchase

delete t_FACard

delete t_FACardItem

delete t_FACardItemDefine

delete t_FACardMulAlter

delete t_FAClear

delete t_FaDeprFormulaItems

delete t_FADept

delete t_FADeptMulAlter

delete t_FADevice

delete t_FADeviceBill

delete t_FADeviceGroupItem

delete t_FADeviceItem

delete t_FADeviceItemDefine

delete t_FADeviceMulAlter

delete t_FAEconomyUse

delete t_FAExpense

delete t_FAExpenseDetailMulAlter

delete t_FAExpenseMulAlter

delete t_FAGroup

delete t_FAGroupItem

delete t_FAImage

delete t_FALocation

delete t_FAOrgFor

delete t_FAOrgForMulAlter

delete t_FAPurchase

delete t_FAPurchaseDetailMulAlter

delete t_FAPurchaseMulAlter

delete t_FARptSheetSchemeItems

delete t_FASchemes

delete t_FASchmFilter

delete t_FASchmOption

delete t_FASchmSort

delete t_FASchmSumItems

delete t_FAStatus

delete t_FaTmpCard

delete t_FAUserDeprRate

delete t_Favorities

delete t_Favorities_Goods

delete t_FAVoucher

delete t_FAAlter

delete t_FAAlterMode

delete t_FABalance

delete t_FADeprMethod


--下面表的插入是有顺序的,与删除顺序应该是不一样的。先插入的数据说明是基础数据,删除的时候就需要后面再删除

/* 生成插入语句使用表的顺序

t_FADeprMethod,t_FAAlterMode,t_FAStatus,t_FAGroup,t_FAGroupItem,t_FAImage,t_FALocation,t_FAAlter,t_FADept,t_FACardItemDefine,t_FACardMulAlter,t_FAClear,t_FaDeprFormulaItems,t_FADevice,t_FADeviceBill,t_FAEconomyUse,t_FADeptMulAlter,t_FASchemes,t_FASchmFilter,t_FASchmOption,t_FASchmSort,t_FASchmSumItems,t_FAUserDeprRate,t_Favorities,t_Favorities_Goods,t_FAVoucher,t_FADeviceGroupItem,t_FADeviceItem,t_FADeviceItemDefine,t_FADeviceMulAlter,t_FAExpense,t_FAExpenseDetailMulAlter,t_FAExpenseMulAlter,t_FAOrgFor,t_FAOrgForMulAlter,t_FAPurchase,t_FAPurchaseDetailMulAlter,t_FAPurchaseMulAlter,t_FARptSheetSchemeItems,t_FaTmpCard,t_FABalance,t_FACard,t_FACardItem,t_FABalCard,t_FABalCardItem,t_FABalDept,t_FABalDevice,t_FABalExpense,t_FABalOrgFor,t_FABalPurchase

*/

--请在这里把上面/*  */内的表插入语句写入这里。没有插入语句将清空了所有固定数据,包括系统允许的基础数据,使用固定资产功能都将异常。注意插入语句的顺序按照上面的顺序。


alter table t_FADeviceBill enable trigger t_FADeviceBill_AutoNumber

alter table t_FADeviceGroupItem enable trigger t_FADeviceGroupItem_AutoNumber

alter table t_FADeviceItemDefine enable trigger t_FADeviceItemDefine_AutoNumber

alter table t_FACardItemDefine enable trigger t_FaCardItemDefine_AutoNumber

alter table t_FAAlterMode enable trigger t_FaAlterMode_AutoNumber

alter table t_FAStatus enable trigger t_FaStatus_AutoNumber

alter table t_FAGroup enable trigger t_FAGroup_AutoNumber

alter table t_FALocation enable trigger t_FaLocation_AutoNumber

alter table t_FADeprMethod enable trigger t_DeprMethod_AutoNumber

alter table t_FAEconomyUse enable trigger t_EconomyUse_AutoNumber

alter table t_FAAlter enable trigger t_FAAlter_AutoNumber

alter table t_FABalance enable trigger t_FABalance_AutoNumber

alter table t_FADevice enable trigger t_FADevice_AutoNumber

alter table t_FAGroupItem enable trigger t_FAGroupItem_AutoNumber

go