金蝶专业版利润表中本年累计数怎么设公式

如题所述

每个公司的科目和取数类型未必是一样的,做报表的时候,财务人员应该制定取数类型和方式。给你举个例子,我们的取数公式是 =ACCT("科目","SL","",0,0,0,"") ,其中SL是损益发生额。也可以写成这样 =ACCT("科目","SL","2018",2018,1,12,"RMB"),不写2018则默认为本年度,起止期间不写则默认为本年全部期间,币别不写则默认为本位币。
温馨提示:答案为网友推荐,仅供参考
第1个回答  2011-03-05
选择损益科目本年累计发生额,会计期间要选择本期,就可以了
第2个回答  推荐于2016-01-05
=ACCT("6401","SY","",0,0,0,"")+ACCT("6402","SY","",0,0,0,"")【本期的】
=ACCT("6401","SY","",0,-1,-1,"")+ACCT("6402","SY","",0,-1,-1,"")【上期的】本回答被网友采纳
第3个回答  2012-11-20
以营业收入为例
=ACCT("6001","SL","",0,0,0,"")+ACCT("6051","SL","",0,0,0,"")