发布时间:2025-10-23
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。
资产负债表设置工程施工和工程结算公式时,当工程施工是贷方余额,工程结算减负数的工程施工的时候,系统计算不出数据,负负不能转变为+。另外现金流量表模板为啥不设置期初的公式,每建一个帐套都要改公式,每个客户都要改,非常麻烦
我这边恢复账套后查看取数正常,可以实现减负数,负负得正。 您的公式是:QM("1122","","年","月","贷")+QM("2203","","年","月","贷")+iff(QM("4404","","年","月","贷")-qm("4401","","年","月")>0,QM("4404","","年","月","贷")-qm("4401","","年","月"),0) 我这边在账套中建立了自定义模板,将您的公式拆解取数,QM("1122","","年","月","贷")+QM("2203","","年","月","贷")等于0,iff(QM("4404","","年","月","贷")-qm("4401","","年","月")>0,QM("4404","","年","月","贷")-qm("4401","","年","月"),0)等于1053817,因为(QM("4404","","年","月","贷")等于835425.41,qm("4401","","年","月")等于-218391.59,相减负负得正,刚好是1053817。
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)