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

设置报表模板重分类时，系统公式=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("","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)