报表往来科目重分类只取一级科目JY/DY设置公式 您所在的位置:网站首页 报表科目重分类 报表往来科目重分类只取一级科目JY/DY设置公式

报表往来科目重分类只取一级科目JY/DY设置公式

2024-07-11 22:46| 来源: 网络整理| 查看: 265

设置报表模板重分类时,系统公式=Acct("","2202","DY","","","","")【系统取数逻辑】根据科目包含所有最明细科目,分别计算每个最明细科目的JY、DY,再简单汇总。设置明细科目、核算维度重分类设置如下帖子https://vip.kingdee.com/article/146306?productLineId=1&isKnowledge=2

报表往来科目重分类只取一级科目JY/DY设置公式:

应收年初:=IF(Acct("","1122","C","",0,1,1)>0,Acct("","1122","C","",0,1,1),0)+IF(Acct("","2203","C","",0,1,1)0,Acct("","1122","Y","",0,0,0),0)+IF(Acct("","2203","Y","",0,0,0)0,Acct("","2202","C","",0,1,1),0)+IF(Acct("","1123","C","",0,1,1)0,Acct("","2202","Y","",0,0,0),0)+IF(Acct("","1123","Y","",0,0,0)



【本文地址】

公司简介

联系我们

今日新闻

    推荐新闻

    专题文章
      CopyRight 2018-2019 实验室设备网 版权所有