用银行存款支付到期商业承兑汇票款,应在现金流量表中"筹资活动现金流量"项目中列示( ) ??
2019-4-19 8:0:0 wondial如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- T3卸载就会跳到安装界面去,用360工具也卸载不了。请问这种情况哪位老师遇见过,我们应该如何处理。谢谢、在线等。2019-4-30 8:0:0
- 用友T3-用友通标准版明细账选择月份的下拉框中没有1、2月份2019-4-23 8:0:0
- 用友T3-用友通标准版打印的凭证上没有显示制单人、记账人的姓名2019-4-23 8:0:0
- 用友T3-用友通标准版录完期初后,总账系统和往来管理中往来科目期初余额不一致2019-4-23 8:0:0
- 用友T3-用友通标准版采购订单存货税率不同如何录入2019-4-23 8:0:0
- 用友T3-用友通标准版采购入库单时,参照不到存货2019-4-23 8:0:0
- 用友T3-用友通标准版材料出库单上的自定义项点击后没反应2019-4-23 8:0:0
- 用友T3-用友通标准版登入用友T3软件,提示演示期限已过期,请插加密狗进行远程注册。2019-4-23 8:0:0
- 用友T3-用友通标准版登入系统管理,账套两个字是灰色2019-4-23 8:0:0
- 用友T3-用友通标准版登录固定资产模块失败2019-4-23 8: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 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
U8.51A进入总帐模块时总提示-有人正在升级,请等待-U8.51A进入总帐模块时总提示"有人正在升级,请等待"
U8.51A-进入总帐模块时总提示"有人正在升级,请等待"
自动编号: | 16871 | 产品版本: | U8.51A |
产品模块: | 总账 | 所属行业: | 通用 |
适用产品: | U851A | 关 键 字: | 有人正在升级 |
问题名称: | 进入总帐模块时总提示"有人正在升级,请等待" | ||
问题现象: | 进入某年度帐的总帐模块时总提示"有人正在升级,请等待",点击确定后可以正常使用总帐模块 | ||
原因分析: | 比其他年度帐的ACCINFORMATION多一行记录,记录编号为999,记录说明为"是否有人在升级" | ||
解决方案: | 将该记录删除即可 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |