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

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

报表往来科目重分类只取一级科目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设置公式

设置报表模板重分类时,系统公式=Acct("","2202","DY","","","","")【系统取数逻辑】根据科目包含所有最明细科目,分别计算每个最明细科目...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息