|
如果科目代码不是这样则该存储过程需要作相应的修改 delete from 资产负债表 where 会计期间 = @kjqj insert into 资产负债表(会计期间) values(@kjqj) update 资产负债表 set 现金及现金等价物 = b金额 from 资产负债表 as a (select sum(isnull(本期借方余额)isnull(本期贷方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 >= and 科目代码 <= ) as b where a会计期间 = @kjqj update 资产负债表 set 应收帐款 = b金额 from 资产负债表 as a (select sum(isnull(本期借方余额)isnull(本期贷方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 >= and 科目代码 <= and 科目代码<>) as b where a会计期间 = @kjqj 注意坏帐准备为贷方 update 资产负债表 set 坏帐准备 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 应收帐款净值 = 应收帐款 坏帐准备 update 资产负债表 set 流动资产总计 = 现金及现金等价物 + 应收帐款净值 update 资产负债表 set 固定资产原值 = b金额 from 资产负债表 as a (select sum(isnull(本期借方余额)isnull(本期贷方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 =) as b where a会计期间 = @kjqj 注意累计折旧为贷方 update 资产负债表 set 累计折旧 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 固定资产总计 = 固定资产原值 累计折旧 update 资产负债表 set 其他资产 = b金额 from 资产负债表 as a (select sum(isnull(本期借方余额)isnull(本期贷方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 >= and 科目代码 <= and 科目代码<> and 科目代码 <> ) as b where a会计期间 = @kjqj update 资产负债表 set 资产总计 = 流动资产总计 + 固定资产总计 + 其他资产 计算负债及所有者权益 负债类级别都是贷方金额 update 资产负债表 set 应付帐款 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 >= and 科目代码 <= ) as b where a会计期间 = @kjqj update 资产负债表 set 预收帐款 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 应付工资 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 其他负债 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 >= and 科目代码 <= and 科目代码 <> ) as b where a会计期间 = @kjqj update 资产负债表 set 负债总计 = 应付帐款 + 预收帐款 + 应付工资 + 其他负债 计算所有者权益 update 资产负债表 set 实收资本 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 资本公积 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 赢余公积 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 未分配利润 = b金额 from 资产负债表 as a (select sum(isnull(本期贷方余额)isnull(本期借方余额)) as 金额 from 科目余额表 where 会计期间 = @kjqj and 科目代码 = or 科目代码 = ) as b where a会计期间 = @kjqj update 资产负债表 set 所有者权益总计 = 实收资本 + 资本公积 + 赢余公积 + 未分配利润 update 资产负债表 set 负债及所有者权益总计 = 负债总计 + 所有者权益总计 commit GO [] [] [] |
