特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品6-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。
客服电话:400-665-0028
关键字:财务软件,畅捷通软件,财务软件,进销存软件,U9官网,U8,KIS,K3,云星空,云星辰,T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,速达软件