就算哪里有江淮帅铃t6的
2018-3-16 0:0:0 wondial就算哪里有江淮帅铃t6的
就算哪里有江淮帅铃t6的''如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友T3用友通系统重装后,没有账套备份,如何恢复账套2019-4-29 8:0:0
- 企业是接单生产模式,需求不稳定,经常出现紧急订单,如何判断这样的紧急订单会不会造成计划和生产的..2019-4-27 8:0:0
- 企业在车间管理中,可以依据工段、车间、设备、员工等多种资源进行明细式派工?2019-4-27 8:0:0
- 以物易物在用友T3用友通通2005中如何实现2019-4-27 8:0:0
- 什么是安全库存、最低库存、最高库存?用友软件U8+中是如何管理的?2019-4-27 8:0:0
- 一般企业普通采购流程分为哪几种?2019-4-23 8:0:0
- 会计在填制凭证时会出现漏录某张凭证的情况,系统支持补录会计凭证吗?_12019-4-23 8:0:0
- 企业的生产班组能生产哪些品种,产能有多大很明确,这种情况下ERP系统能不能代替人工按照生产计划..2019-4-23 8:0:0
- 什么是动态安全库存?U8+的动态安全库存是如何实现的?2019-4-23 8:0:0
- 为什么说用友U8+的成本管理是一个完整的成本管理体系?2019-4-23 8:0:0
最新信息
仓库要怎么管理,库存,申购等 _0仓库要怎么管理,库存,申购等'' 光靠人工管理肯定是效率低而且累,数据容易出错。所以还是需要借助软件工具来帮忙。实万仓储管理软件不错。你可以去试用一下,看否是你需要的。
U6普及版3.1重新计算每个月的年初原值、月初原值、月末原值U6普及版3.1重新计算每个月的年初原值、月初原值、月末原值
U6普及版3.1-重新计算每个月的年初原值、月初原值、月末原值
自动编号: | 19357 | 产品版本: | U6普及版3.1 |
产品模块: | 固定资产 | 所属行业: | 通用 |
适用产品: | 关 键 字: | ||
问题名称: | 重新计算每个月的年初原值、月初原值、月末原值 | ||
问题现象: | 如何利用语句重新计算每个月的年初原值、月初原值、月末原值 | ||
原因分析: | update fa_total set dblyearvalue = '年初原值' where sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = dblyearvalue where iperiod = '1' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '1' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '2' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '2' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '3' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '3' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '4' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from f | ||
解决方案: | update fa_total set dblyearvalue = '年初原值' where sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = dblyearvalue where iperiod = '1' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '1' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '2' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '2' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '3' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '3' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '4' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '4' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '5' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '5' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '6' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '6' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '7' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '7' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '8' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '8' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '9' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '9' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '10' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '10' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '11' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblmonthvalue = x.dblvalue from (select dblvalue from fa_total where iperiod = '11' and sdeptnum = '部门编码' and stypenum = '资产编码')as x where iperiod = '12' and sdeptnum = '部门编码' and stypenum = '资产编码' update fa_total set dblvalue = dblmonthvalue - dbldecvalue +dbladdvalue 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |