报表往来科目重分类只取一级科目JY/DY设置公式
设置报表模板重分类时,系统公式=Acct("","2202","DY","","","","")【系统取数逻辑】根据科目包含所有最明细科目,分别计算每个最明细科目的JY、DY,再简单汇总。设置明细科目、核算维度重分类设置如下帖子https://wenku.my7c.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("","2203","C","",0,1,1),0)-Acct("","1231","Y","",0,1,1)
应收年末:=IF(Acct("","1122","Y","",0,0,0)>0,Acct("","1122","Y","",0,0,0),0)+IF(Acct("","2203","Y","",0,0,0)<0,-Acct("","2203","Y","",0,0,0),0)-Acct("","1231","Y","",0,0,0)
应付年初:=IF(Acct("","2202","C","",0,1,1)>0,Acct("","2202","C","",0,1,1),0)+IF(Acct("","1123","C","",0,1,1)<0,-Acct("","1123","C","",0,1,1),0)
应付年末:=IF(Acct("","2202","Y","",0,0,0)>0,Acct("","2202","Y","",0,0,0),0)+IF(Acct("","1123","Y","",0,0,0)<0,-Acct("","1123","Y","",0,0,0),0)
预付年初:=IF(Acct("","2202","C","",0,1,1)<0,-Acct("","2202","C","",0,1,1),0)+IF(Acct("","1123","C","",0,1,1)>0,Acct("","1123","C","",0,1,1),0)
预付年末:=IF(Acct("","2202","Y","",0,0,0)<0,-Acct("","2202","Y","",0,0,0),0)+IF(Acct("","1123","Y","",0,0,0)>0,Acct("","1123","Y","",0,0,0),0)
预收年初:=IF(Acct("","1122","C","",0,1,1)<0,-Acct("","1122","C","",0,1,1),0)+IF(Acct("","2203","C","",0,1,1)>0,Acct("","2203","C","",0,1,1),0)
预收年末:=IF(Acct("","1122","Y","",0,0,0)<0,-Acct("","1122","Y","",0,0,0),0)+IF(Acct("","2203","Y","",0,0,0)>0,Acct("","2203","Y","",0,0,0),0)
学习了
报表往来科目重分类只取一级科目JY/DY设置公式
本文2024-09-16 17:17:08发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14721.html