详细信息

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

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

发布时间：2024-7-22　　

特价活动:>>>> 畅云管家新购、续费7折优惠，畅捷通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。附件一是自定义模板分段取数的值，附件二是资产负债表取数的值，是一样的。

上一篇:T+科目有问题

下一篇:T+ 13.0标准版收款单中多结算明细“结算方式”中数据消失，导致不能联查销货单