热门关键词用友BIP 用友U9 用友NC 用友U8 OA T+ 好业财

    详细信息

    您现在的位置:网站首页 >> 百科问答 >> 详细信息

    T+13.0资产负债表,当工程施工是贷方余额,工程结算减负数的工程施工的时候,系统计算不出数据

    特价活动:>>>> 畅云管家新购、续费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。 

     

     

    上一篇:T+Cloud报价单的含税金额不等于含税单价*数量?

    客服电话:400-665-0028

    关键字:财务软件,畅捷通软件,财务软件,进销存软件,U9官网,U8,KIS,K3,云星空,云星辰,T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,速达软件