用友u8软件重新计算每个月的年初原值、月初原值、月末原值
2015-1-8 0:0:0 用友U8编辑用友u8软件重新计算每个月的年初原值、月初原值、月末原值
重新计算每个月的年初原值、月初原值、月末原值重新计算每个月的年初原值、月初原值、月末原值
原因分析：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如果您的问题还没有解决，可以到 T+搜索>>上找一下答案
相关阅读
- 采购入库单，有一些存货突然选不到，新增的存货也选不到，什么情况？2018-11-27 3:14:56
- 用友u8软件销售订单投产时报-请设置工厂日历或没有相应的BOM_02015-1-9 0:0:0
- 用友u8软件销售订单数据错乱2015-1-9 0:0:0
- 用友u8软件销售订单数量10X单价35等于35.012015-1-9 0:0:0
- 用友u8软件销售订单数量为何不扣减2015-1-9 0:0:0
- 用友u8软件销售订单无法保存2015-1-9 0:0:0
- 用友u8软件销售订单无法保存_02015-1-9 0:0:0
- 用友u8软件销售订单明细表格式恢复2015-1-9 0:0:0
- 用友u8软件销售订单显示按钮2015-1-9 0:0:0
- 用友u8软件销售订单没有存货代码字段2015-1-9 0:0:0
最新信息
- 用友u8软件改凭证提示已两清
- 用友u8软件如何取消采购发票结算
- 销货单的成本发生了变化，是否要做出库调整单？查询业务员的毛利时要按什么成本取值查询？
- 销货单的汇总如何打印出来？并且如何设置显示条形码？
- 销货单立账。只做了销售出库单未做销货单的单据也体现在应收明细账里面。但不知这种单独的销售出库单的应收是如何形成的金额。
- 销货单等业务单据，在修改后审核，通过“上张”与“下张”来翻动的单据排序的顺序能否设置？如何设置？
- 销货单统计表，这个开票状态是指的什么意思？
- 销货单统计里面只有数量没有金额，原来是有金额的
- 销货单自动生成出库单，销货单表头自定义专用项（驾驶员，电话等等），公用太少已经用完，专用为什么不能带入到出库单 （只打印出库单据）？ 自己自定义项也不能带入 求破解
- 销货单表头使用了自定义项，录入销货单时，录入了数据，发货单生成销售出库单后，销售出库单表头这两个自定义项没有显示！-如何解决？
客户需要更改负债表，加一项去年同期余额，不知道公式改如何添加 客户需要更改负债表，加一项去年同期余额，不知道公式改如何添加
您好，在格式状态下，点击上方的fx按钮进行添加公式。可查看帮助教程中的报表视频进行学习，也可在软件中报表界面点击F1进行帮助。
用友u8软件销售发票审核不了销售发票审核不了
销售发票审核不了原因分析：经查ufsystem库中UA_Account_sub表的对应账套年度的iModiPeri值不正确.问题解答：修改ufsystem库中UA_Account_sub表的对应账套年度的iModiPeri值即可.
