(FAQ)固定资产卡片清单上净值净额不对
金蝶云社区
1,352次浏览
编辑于2015年03月02日 00:00:00
【问题】: (FAQ)固定资产卡片清单上净值净额不对
版本: 7.0.3
模块: 固定资产
【答复】:
--重算净值 净值=原值-累计折旧 update t_fa_famoncard set FNeatValue=fassetvalue-faccudepr where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净额 净额=净值-减值准备 update t_fa_famoncard set fneatamt=fneatvalue-fdecvalue where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净值 净值=原值-累计折旧 update t_fa_facurcard set FNeatValue=fassetvalue-faccudepr where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净额 净额=净值-减值准备 update t_fa_facurcard set fneatamt=fneatvalue-fdecvalue where fcompanyid = (select fid from t_org_company where fnumber='公司编码')
版本: 7.0.3
模块: 固定资产
【答复】:
--重算净值 净值=原值-累计折旧 update t_fa_famoncard set FNeatValue=fassetvalue-faccudepr where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净额 净额=净值-减值准备 update t_fa_famoncard set fneatamt=fneatvalue-fdecvalue where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净值 净值=原值-累计折旧 update t_fa_facurcard set FNeatValue=fassetvalue-faccudepr where fcompanyid = (select fid from t_org_company where fnumber='公司编码') --重算净额 净额=净值-减值准备 update t_fa_facurcard set fneatamt=fneatvalue-fdecvalue where fcompanyid = (select fid from t_org_company where fnumber='公司编码')
推荐阅读