财务报表“上期金额” 发生跨年度时取数公式
根据报表功能,如果取“上期金额”时,为 Acct("006","5501.01","SY","","","-1","-1")。但此公司涉及到跨年度时,就取不到数值,即为每年1月份,需要取去年12月份金额时,就显示空白。
因此,需要使用如下公式:IF(RptInfo("RP")=1,Acct("006","5501.01","SY","","-1","12","12"),Acct("006","5501.01","SY","","","-1","-1"))
说明:使用IF 条件判断 当前期间是否为 1 月份,如果 RptInfo("RP")=1 成立,取Acct("006","5501.01","SY","","-1","12","12"), 如果RptInfo("RP")=1 不成立 取 Acct("006","5501.01","SY","","","-1","-1")
=IF(RptInfo("RP")=1,AcctCash("","CI01.01.01","Z","",-1,1,12),AcctCash("","CI01.01.01","Z","",0,1,-1)) 我的公式设置成这样 还是提示不能跨年
财务报表“上期金额” 发生跨年度时取数公式
根据报表功能,如果取“上期金额”时,为 Acct("006","5501.01","SY","","","-1","-1")。但此公司涉及到跨年度时,就取不到数值,即...
点击下载文档
本文2024-09-16 18:30:01发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-22540.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章