【业务背景】

应交税金科目下有多个明细科目,需要根据二级明细科目的余额判断,当二级明细科目的余额为正数时放到资产负债表应交税费中,当二级明细科目的余额为负数时放到资产负债表其他流动资产项目中,如何设置取数公式?

如下图所示,需要在资产负债表应交税费中体现16,其他流动资产中体现2000,没有修改公式前,资产负债表应交税费项目取的是2221一级科目的余额即“-1984”。

【概述】

上述取数需求需要使用ACCT和IF函数嵌套使用实现,应交税费公式需要改为“=IF(Acct("","2221.01","Y","","","","")>0,Acct("","2221.01","Y","","","",""),0)+IF(Acct("","2221.03","Y","","","","")>0,Acct("","2221.03","Y","","","",""),0)”

其他流动资产公式在原有公式的基础上再加上应交税费下发明细科目的取数公式,即公式改为“=Acct("","1321","Y","",0,0,0)+IF(Acct("","2221.01","Y","","","","")<0,Acct("","2221.01","Y","","","",""),0)+IF(Acct("","2221.03","Y","","","","")<0,Acct("","2221.03","Y","","","",""),0)”,此时取数如图所示。

【备注】

上述案例中只涉及两个明细科目,如果还有其他明细科目,则是相同的设置逻辑,多个公式相加,每个公式都是ACCT和IF函数嵌套使用。

以上解决方案适用于金蝶云星空企业版和标准版全版本