金蝶报表公式

资产负债表:货币资金年初数=ACCT("1001:1012","","NC","",0,1,1)货币资金期末数=ACCT("1001:1012","","Y","",0,0,0)交易性金融资产年初数=ACCT("1101","","NC","",0,1,1)交易性金融资产期末数=ACCT("1101","","Y","",0,0,0)应收账款年初数=ACCT("1122","","JC","",0,1,1)-ACCT("1231","","NC","",0,1,1)+ACCT("220 3","","JC","",0,1,1)应收账款期末数=ACCT("1122","","JY","",0,0,0)-ACCT("1231","","Y","",0,0,0)+ACCT("2203 ","","JY","",0,0,0)预付款项年初数=ACCT("1123","","JC","",0,1,1)+ACCT("2202","","JC","",0,1,1)预付款项期末数=ACCT("1123","","JY","",0,0,0)+ACCT("2202","","JY","",0,0,0)持有至到期投资年初数=ACCT("1501","","NC","",0,1,1)-ACCT("1502","","NC","",0,1,1)持有至到期投资期末数=ACCT("1501","","Y","",0,0,0)-ACCT("1502","","Y","",0,0,0)长期应收款年初数=ACCT("1531","","NC","",0,1,1)-ACCT("1532","","NC","",0,1,1)长期应收款期末数=ACCT("1531","","Y","",0,0,0)-ACCT("1532","","Y","",0,0,0)长期股权投资年初数=ACCT("1511","","NC","",0,1,1)-ACCT("1512","","NC","",0,1,1)长期股权投资期末数==ACCT("1511","","Y","",0,0,0)-ACCT("1512","","Y","",0,0,0)固定资产年初据=ACCT("1601","","NC","",0,1,1)-ACCT("1602","","NC","",0,1,1)-ACCT("16 03","","NC","",0,1,1)固定资产期末据=ACCT("1601","","Y","",0,0,0)-ACCT("1602","","Y","",0,0,0)-ACCT("1603", "","Y","",0,0,0)无形资产年初数=ACCT("1701","","NC","",0,1,1)-ACCT("1702","","NC","",0,1,1)-ACCT("17 03","","NC","",0,1,1)无形资产期末数=ACCT("1701","","Y","",0,0,0)-ACCT("1702","","Y","",0,0,0)-ACCT("1703", "","Y","",0,0,0)应付账款年初数=ACCT("2202","","DC","",0,1,1)+ACCT("1123","","DC","",0,1,1)应付账款期末数=ACCT("2202","","DY","",0,0,0)+ACCT("1123","","DY","",0,0,0)预收款项年初=ACCT("2203","","DC","",0,1,1)+ACCT("1122","","DC","",0,1,1)预收款项期末=ACCT("2203","","DY","",0,0,0)+ACCT("1122","","DY","",0,0,0)长期应付款年初数=ACCT("2701","","NC","",0,1,1)-ACCT("2702","","NC","",0,1,1)长期应付款期末数=ACCT("2701","","Y","",0,0,0)-ACCT("2702","","Y","",0,0,0)所有者权益年初数=SUM(I30:I31)-I32+I33+I34所有者权益期末数=SUM(H30:H31)-H32+H33+H34未分配利润=ACCT("4104","","NC","",0,1,1)+ACCT("4103","","NC","",0,1,1)未分配利润期末数=ACCT("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ACCT("6001" ,"","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-ACCT("6401","","y","",0,0,0 )-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601", "","y","",0,0,0)-ACCT("6602","","y","",0,0,0)-ACCT("6603","","y","",0,0,0) -ACCT("6701","","y","",0,0,0)+ACCT("6101","","y","",0,0,0)+ACCT("6111" ,"","y","",0,0,0)+ACCT("6301","","y","",0,0,0)-ACCT("6711","","y","",0,0,0 )-ACCT("6801","","y","",0,0,0)存货年初数=ACCT("1401:1406","","NC","",0,1,1)-ACCT("1471","","NC","",0,1,1)+ACC T("5001","","NC","",0,1,1)+ACCT("1408","","NC","",0,1,1)+ACCT("1411"," ","NC","",0,1,1)-ACCT("1407","","NC","",0,1,1)存货期末数＝=ACCT("1401:1406","","Y","",0,0,0)-ACCT("1471","","Y","",0,0,0)+ACCT(" 5001","","Y","",0,0,0)+ACCT("1408","","Y","",0,0,0)+ACCT("1411","","Y"," ",0,0,0)-ACCT("1407","","Y","",0,0,0)利润表营业收入上期数＝=ACCT("6001","","SL","",-1、0,0,0)+ACCT("6051","","SL","",-1、0,0,0)营业收入本期数=ACCT("6001","","SL","",0,0,0)+ACCT("6051","","SL","",0,0,0)营业成本上期数=ACCT("6401","","SL","",-1、0,0,0)+ACCT("6402","","SL","",-1、0,0,0)营业成本本期数=ACCT("6401","","SL","",0,0,0)+ACCT("6402","","SL","",0,0,0)营业税金及附加上期数=ACCT("6403","","SL","",-1、0,0,0)营业税金及附加本期数= =ACCT("6403","","SL","",0,0,0)销售费用上期=ACCT("6601","","SL","",-1、0,0,0)销售费用本期=ACCT("6601","","SL","",0,0,0)管理费用上期数=ACCT("6602","","SL","",-1、0,0,0)管理费用本期数=ACCT("6602","","SL","",0,0,0)财务费用上期=ACCT("6603","","SL","",-1、0,0,0)财务费用本期=ACCT("6603","","SL","",0,0,0)资产减值损失=ACCT("6701","","SL","",-1、0,0,0)资产减值损失＝=ACCT("6701","","SL","",0,0,0)公允价值变动收益=ACCT("6101","","SL","",-1、0,0,0) 公允价值变动收益=ACCT("6101","","SL","",0,0,0)投资收益=ACCT("6111","","SL","",-1、0,0,0)投资收益=ACCT("6111","","SL","",0,0,0)营业利润=E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润=D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入=ACCT("6301","","SL","",-1、0,0,0)营业外收入＝ACCT("6301","","SL","",0,0,0)营业外支出=ACCT("6711","","SL","",-1、0,0,0)营业外支出=ACCT("6711","","SL","",0,0,0)利润总额=E14+E15-E16利润总额=D14+D15-D16所得税费用=ACCT("6801","","SL","",-1、0,0,0)所得税费用=ACCT("6801","","SL","",0,0,0)。

资产负债表：货币资金年初数=ACCT("1001:1012","","NC","",0,1,1)货币资金期末数=ACCT("1001:1012","","Y","",0,0,0)交易性金融资产年初数=ACCT("1101","","NC","",0,1,1)交易性金融资产期末数=ACCT("1101","","Y","",0,0,0)应收账款年初数=ACCT("1122","","JC","",0,1,1)-ACCT("1231","","NC","",0,1,1)+ACCT("220 3","","JC","",0,1,1)应收账款期末数=ACCT("1122","","JY","",0,0,0)-ACCT("1231","","Y","",0,0,0)+ACCT("2203 ","","JY","",0,0,0)预付款项年初数=ACCT("1123","","JC","",0,1,1)+ACCT("2202","","JC","",0,1,1)预付款项期末数=ACCT("1123","","JY","",0,0,0)+ACCT("2202","","JY","",0,0,0)持有至到期投资年初数=ACCT("1501","","NC","",0,1,1)-ACCT("1502","","NC","",0,1,1)持有至到期投资期末数=ACCT("1501","","Y","",0,0,0)-ACCT("1502","","Y","",0,0,0)长期应收款年初数=ACCT("1531","","NC","",0,1,1)-ACCT("1532","","NC","",0,1,1)长期应收款期末数=ACCT("1531","","Y","",0,0,0)-ACCT("1532","","Y","",0,0,0)长期股权投资年初数=ACCT("1511","","NC","",0,1,1)-ACCT("1512","","NC","",0,1,1)长期股权投资期末数==ACCT("1511","","Y","",0,0,0)-ACCT("1512","","Y","",0,0,0)固定资产年初据=ACCT("1601","","NC","",0,1,1)-ACCT("1602","","NC","",0,1,1)-ACCT("16 03","","NC","",0,1,1)固定资产期末据=ACCT("1601","","Y","",0,0,0)-ACCT("1602","","Y","",0,0,0)-ACCT("1603", "","Y","",0,0,0)无形资产年初数=ACCT("1701","","NC","",0,1,1)-ACCT("1702","","NC","",0,1,1)-ACCT("17 03","","NC","",0,1,1)无形资产期末数=ACCT("1701","","Y","",0,0,0)-ACCT("1702","","Y","",0,0,0)-ACCT("1703", "","Y","",0,0,0)应付账款年初数=ACCT("2202","","DC","",0,1,1)+ACCT("1123","","DC","",0,1,1)应付账款期末数=ACCT("2202","","DY","",0,0,0)+ACCT("1123","","DY","",0,0,0)预收款项年初=ACCT("2203","","DC","",0,1,1)+ACCT("1122","","DC","",0,1,1)预收款项期末=ACCT("2203","","DY","",0,0,0)+ACCT("1122","","DY","",0,0,0)=ACCT("2701","","NC","",0,1,1)-ACCT("2702","","NC","",0,1,1)=ACCT("2701","","Y","",0,0,0)-ACCT("2702","","Y","",0,0,0)所有者权益年初数=SUM(I30:I31)-I32+I33+I34所有者权益期末数=SUM(H30:H31)-H32+H33+H34未分配利润=ACCT("4104","","NC","",0,1,1)+ACCT("4103","","NC","",0,1,1)未分配利润期末数=ACCT("4104","","y","",0,0,0)+ACCT("4103","","y","",0,0,0)+ACCT("6001" ,"","y","",0,0,0)+ACCT("6051","","y","",0,0,0)-ACCT("6401","","y","",0,0,0 )-ACCT("6402","","y","",0,0,0)-ACCT("6403","","y","",0,0,0)-ACCT("6601", "","y","",0,0,0)-ACCT("6602","","y","",0,0,0)-ACCT("6603","","y","",0,0,0) -ACCT("6701","","y","",0,0,0)+ACCT("6101","","y","",0,0,0)+ACCT("6111" ,"","y","",0,0,0)+ACCT("6301","","y","",0,0,0)-ACCT("6711","","y","",0,0,0 )-ACCT("6801","","y","",0,0,0)存货年初数=ACCT("1401:1406","","NC","",0,1,1)-ACCT("1471","","NC","",0,1,1)+ACC T("5001","","NC","",0,1,1)+ACCT("1408","","NC","",0,1,1)+ACCT("1411"," ","NC","",0,1,1)-ACCT("1407","","NC","",0,1,1)存货期末数＝=ACCT("1401:1406","","Y","",0,0,0)-ACCT("1471","","Y","",0,0,0)+ACCT(" 5001","","Y","",0,0,0)+ACCT("1408","","Y","",0,0,0)+ACCT("1411","","Y"," ",0,0,0)-ACCT("1407","","Y","",0,0,0)利润表营业收入上期数＝=ACCT("6001","","SL","",-1.0,0,0)+ACCT("6051","","SL","",-1.0,0,0) 营业收入本期数=ACCT("6001","","SL","",0,0,0)+ACCT("6051","","SL","",0,0,0)营业成本上期数=ACCT("6401","","SL","",-1.0,0,0)+ACCT("6402","","SL","",-1.0,0,0) 营业成本本期数=ACCT("6401","","SL","",0,0,0)+ACCT("6402","","SL","",0,0,0)营业税金及附加上期数=ACCT("6403","","SL","",-1.0,0,0)营业税金及附加本期数= =ACCT("6403","","SL","",0,0,0)销售费用上期=ACCT("6601","","SL","",-1.0,0,0)销售费用本期=ACCT("6601","","SL","",0,0,0)管理费用上期数=ACCT("6602","","SL","",-1.0,0,0)管理费用本期数=ACCT("6602","","SL","",0,0,0)财务费用上期=ACCT("6603","","SL","",-1.0,0,0)财务费用本期=ACCT("6603","","SL","",0,0,0)资产减值损失=ACCT("6701","","SL","",-1.0,0,0)资产减值损失＝=ACCT("6701","","SL","",0,0,0)公允价值变动收益=ACCT("6101","","SL","",-1.0,0,0)公允价值变动收益=ACCT("6101","","SL","",0,0,0)投资收益=ACCT("6111","","SL","",-1.0,0,0)投资收益=ACCT("6111","","SL","",0,0,0)营业利润=E4-E5-E6-E7-E8-E9-E10+E11+E12营业利润=D4-D5-D6-D7-D8-D9-D10+D11+D12营业外收入=ACCT("6301","","SL","",-1.0,0,0)营业外收入＝ACCT("6301","","SL","",0,0,0)营业外支出=ACCT("6711","","SL","",-1.0,0,0)营业外支出=ACCT("6711","","SL","",0,0,0)利润总额=E14+E15-E16利润总额=D14+D15-D16所得税费用=ACCT("6801","","SL","",-1.0,0,0)所得税费用=ACCT("6801","","SL","",0,0,0)（注：文档可能无法思考全面，请浏览后下载，供参考。

金蝶软件报表公式设置引言：随着企业规模的扩大和业务复杂度的提高，金蝶软件成为了众多企业首选的管理软件之一。

在财务报表的生成过程中，设置正确的公式是确保数据准确性和报表可靠性的关键。

本文将介绍金蝶软件中报表公式的设置方法和技巧，帮助您更好地应用金蝶软件进行财务数据分析和报表生成。

一、公式的基本概念在金蝶软件中，报表公式是由特定的函数和操作符组成的，用于在报表中计算和展示数据。

这些公式可以基于其他报表数据、计算结果或固定值进行运算，并生成最终的报表结果。

公式可以用于计算财务指标、比率、增长率等各种重要的指标，帮助企业管理者更好地理解业务情况和进行决策。

二、公式的设置步骤1. 打开金蝶软件并选择相应的报表模板。

在报表设计界面中，可以看到各种报表元素和布局。

2. 在需要设置公式的单元格中双击，并选中“设置公式”选项。

在公式编辑器中，可以输入公式表达式和相关参数。

3. 根据具体的报表需求和计算逻辑，选择合适的函数和操作符，并填写相应的参数。

金蝶软件提供了丰富的函数库，包括数学函数、逻辑函数、文本函数等，可以满足不同的计算需求。

4. 在公式编辑器中，可以通过点击工具栏上的按钮来插入字段、运算符和函数。

也可以直接手动输入相应的表达式和参数。

5. 添加公式后，可以使用预览功能来验证公式的正确性。

点击“预览”按钮，系统将根据当前的数据和报表设计，计算出公式的结果，并在预览窗口中展示。

6. 如果公式设置正确，可以点击“确认”按钮保存设置。

系统将根据公式的定义，自动计算并更新报表数据。

三、公式设置的技巧1. 使用合适的函数：金蝶软件提供了丰富的函数库，可以满足不同的计算需求。

在设置公式时，应根据具体的计算逻辑选择合适的函数，以确保计算结果准确。

2. 引用正确的单元格：在设置公式时，应确保引用的单元格和数据区域是正确的。

错误的单元格引用可能导致计算错误或显示不准确的报表结果。

3. 使用绝对引用和相对引用：金蝶软件支持绝对引用和相对引用两种引用方式。

金蝶软件公式Revised on November 25, 2020金蝶报表函数取数公式取数公式类型说明(1) ACCT取数公式定义选择〖插入〗—>〖函数〗，系统将所有的报表取数公式列出，选择“金蝶报表函数”中的ＡＣＣＴ取数公式，双击鼠标左键，系统将弹出定义公式的界面，如下图所示：在进行ACCT取数公式中需要设置以下的一些参数：1、科目：首次使用可采用向导自动生成科目与核算项目参数，在科目录入框内单击F7显示如下：生成的公式描述如下：科目公式=“科目代码1：科目代码2|项目类别|项目代码1：项目代码2|项目类别|项目代码1:项目代码2”下面针对公式中“”内的内容进行说明：“”中的内容用于存放用户所选择的科目和核算项目代码。

公式中的科目代码，项目类别和项目代码，在字符“|”和“：”的分隔下可以进行20种组合，其中：“a”，“a1”，“a2”表示科目代码“b”表示核算项目类别名称“C”，“C1”，“C2”表示核算项目代码“a：”表示代码大于或等于科目a的所有科目“：a”表示代码小于或等于a的所有科目“a1：a2”表示代码大于或等于a1并且小于或等于a2的所有科目“C：”表示代码大于或等于C的所有核算项目“：C”表示代码小于或等于C的所有核算项目“C1：C2”表示代码大于或等于C1并且小于或等于C2的核算项目当核算项目类别b和代码C，C1，C2都缺省时，表示指定科目下设所有的核算项目类别。

当核算项目类别b不省略，而核算项目代码缺省时，表示指定核算项目类别b中所有核算项目。

举例：取数公式表达式：ACCT(“：123|客户|003：”，“C”)表示科目代码小于或等于123，下设科目核算项目：客户，客户代码大于或等于003的本位币的期初余额。

取数公式表达式：ACCT（“214|职员|0001：0012”，“Y”）表示科目代码为214，下设科目核算项目：职员，职员代码在0001到0012之间的本位币期末余额。

金蝶kis报表公式acct金蝶KIS是一款常用的财务管理软件，其中的报表功能十分强大，可以通过使用公式来计算和展示数据。

在金蝶KIS的报表中，可以使用acct函数来进行相关的计算和操作。

acct函数是金蝶KIS报表中常用的一个函数，可以用于对科目进行操作和计算。

它的基本语法如下：acct(科目编码, 计算方向, 公式类型, [计算发生发生额], [计算余额], [期间])其中，各个参数的含义如下：- 科目编码：需要进行操作或计算的科目的编码。

- 计算方向：指定计算的方向，可以是借方（D）或贷方（C）。

- 公式类型：指定计算的类型，可以是发生额（0），余额（1）或取期间发生额（2）。

- 计算发生发生额：当公式类型为发生额（0）时，可以指定计算的发生额表达式。

- 计算余额：当公式类型为余额（1）时，可以指定计算的余额表达式。

- 期间：指定计算的期间，可以是当前期间（0），期末（1）或期初（2）。

根据上述的基本语法，可以实现各种不同的功能和计算。

以下是一些常见的使用场景和参考内容：1. 计算科目的发生额：acct("科目编码", "借方", 0)或acct("科目编码", "贷方", 0)可以分别计算该科目的借方和贷方的发生额。

2. 计算科目的余额：acct("科目编码", "借方", 1)或acct("科目编码", "贷方", 1)可以分别计算该科目的借方和贷方的余额。

3. 计算科目在指定期间的发生额：acct("科目编码", "借方", 2, "", "", "期间")可以计算该科目在指定期间中的借方发生额。

4. 计算科目在指定期间的余额：acct("科目编码", "借方", 2, "", "", "期间")可以计算该科目在指定期间中的借方余额。

金蝶报表函数取数公式取数公式类型说明常用取数公式定义举例(1) ACCT取数公式定义选择〖插入〗—>〖函数〗，系统将所有的报表取数公式列出，选择“金蝶报表函数”中的ＡＣＣＴ取数公式，双击鼠标左键，系统将弹出定义公式的界面，如下图所示：在进行ACCT取数公式中需要设置以下的一些参数：1、科目：首次使用可采用向导自动生成科目与核算项目参数，在科目录入框内单击F7显示如下：生成的公式描述如下：科目公式=“科目代码1：科目代码2|项目类别|项目代码1：项目代码2|项目类别|项目代码1:项目代码2”下面针对公式中“”内的内容进行说明：“”中的内容用于存放用户所选择的科目和核算项目代码。

公式中的科目代码，项目类别和项目代码，在字符“|”和“：”的分隔下可以进行20种组合，得“a”，“a1”，“a2”表示科目代码“b”表示核算项目类别名称“C”，“C1”，“C2”表示核算项目代码“a：”表示代码大于或等于科目a的所有科目“：a”表示代码小于或等于a的所有科目“a1：a2”表示代码大于或等于a1并且小于或等于a2的所有科目“C：”表示代码大于或等于C的所有核算项目“：C”表示代码小于或等于C的所有核算项目“C1：C2”表示代码大于或等于C1并且小于或等于C2的核算项目当核算项目类别b和代码C，C1，C2都缺省时，表示指定科目下设所有的核算项目类别。

当核算项目类别b不省略，而核算项目代码缺省时，表示指定核算项目类别b 中所有核算项目。

举例：取数公式表达式：ACCT(“：123|客户|003：”，“C”)表示科目代码小于或等于123，下设科目核算项目：客户，客户代码大于或等于003的本位币的期初余额。

取数公式表达式：ACCT（“214|职员|0001：0012”，“Y”）表示科目代码为214，下设科目核算项目：职员，职员代码在0001到0012之间的本位币期末余额。

为方便用户操作，提供“*”为科目参数的通配符，每一个通配符只匹配一个字符，可对科目（核算项目也适用）进行模糊取数。

金蝶云星空报表公式
金蝶云星空报表公式是指在金蝶云星空报表中使用的计算公式，可以用于对数据进行计算、筛选、汇总等操作。

以下是一些常用的金蝶云星空报表公式：
1. SUM：用于求和，例如：SUM(A1:A10)表示求A1到A10单元格的和。

2. AVERAGE：用于求平均值，例如：AVERAGE(A1:A10)表示求A1到A10单元格的平均值。

3. MAX：用于求最大值，例如：MAX(A1:A10)表示求A1到A10单元格中的最大值。

4. MIN：用于求最小值，例如：MIN(A1:A10)表示求A1到A10单元格中的最小值。

5. IF：用于条件判断，例如：IF(A1>0,"正数","负数")表示如果A1大于0，则返回“正数”，否则返回“负数”。

6. COUNT：用于计数，例如：COUNT(A1:A10)表示计算A1到A10单元格中的数值个数。

7. CONCATENATE：用于字符串拼接，例如：CONCATENATE(A1," ",B1)表示将A1和B1单元格中的内容拼接在一起，中间用空格隔开。

以上是一些常用的金蝶云星空报表公式，还有很多其他的公式可以根据需要进行使用。

金蝶报表函数取数公式取数公式类型说明数据项说明必填项(是/否）ACCT总账科目取数公式.是ACCTGROUP集团账套科目取数公式.是A V G求平均数取数公式。

是COMPUTERTIME返回计算机当前日期。

是是COUNT统计数量取数公式,计算所有非空格单元格的个数。

CS_REF_F返回指定制作日期的合并报表，指定表页、是指定单元的值。

CURRENCYRATE集团汇率取数公式。

是DATE返回计算机当前日期。

是DATEDIFF求指定日期参数2与参数1之间的天数差。

是ITEMINFO返回指定核算项目的属性值.是KEYWORD取表页的关键字的取数公式.是MAX求最大值取数公式。

是MIN求最小值取数公式。

是PAGENAME取表页名称取数公式。

是PAGENO返回当前表页的值.是REF返回指定表页、指定单元格的值.是是REF_F 返回指定账套、指定报表、指定表页、指定单元格的值。

RPRDATA 返回指定格式的当前报表日期。

是RPTQUARTER季度取数公式.是是RPTSHEETDATE获取当前报表指定表页的开始日期或结束日期,并以指定日期格式返回。

ＳＵＭ求和取数公式。

是SYSINFO返回指定关键字的系统信息.是常用取数公式定义举例（1）ACCT取数公式定义选择〖插入〗—>〖函数〗,系统将所有的报表取数公式列出，选择“金蝶报表函数"中的ＡＣＣＴ取数公式，双击鼠标左键，系统将弹出定义公式的界面，如下图所示：在进行ACCT取数公式中需要设置以下的一些参数:1、科目:首次使用可采用向导自动生成科目与核算项目参数，在科目录入框内单击F7显示如下:生成的公式描述如下：科目公式=“科目代码1:科目代码2|项目类别｜项目代码1：项目代码2｜项目类别｜项目代码1:项目代码2”下面针对公式中“”内的内容进行说明：“"中的内容用于存放用户所选择的科目和核算项目代码。

公式中的科目代码，项目类别和项目代码，在字符“｜”和“：”的分隔下可以进行20种组合，得到不同范围的科目和核算项目.组合情况如下：A a：:a a1：a2A｜b a：｜b：a｜b a1：a2｜bA｜b｜c a：｜b｜c：a|b|c a1：a2｜b｜ca｜b｜c：a:｜b｜：c：a|b｜c：a1：a2｜b.c:a｜b|c1：c2a：｜b｜c1：c2：a｜b|c1：c2a1：a2|b｜c1：c2其中：“a”，“a1”，“a2”表示科目代码“b"表示核算项目类别名称“C”,“C1",“C2”表示核算项目代码“a："表示代码大于或等于科目a的所有科目“：a”表示代码小于或等于a的所有科目“a1：a2”表示代码大于或等于a1并且小于或等于a2的所有科目“C："表示代码大于或等于C的所有核算项目“:C”表示代码小于或等于C的所有核算项目“C1：C2”表示代码大于或等于C1并且小于或等于C2的核算项目当核算项目类别b和代码C，C1，C2都缺省时，表示指定科目下设所有的核算项目类别。

金蝶资产负债表其他应收公式金蝶资产负债表其他应收公式是指在金蝶财务软件中用于计算企业其他应收款项的公式。

其他应收款项是指企业在经营活动中形成的，与主营业务无直接关系的应收款项。

金蝶资产负债表其他应收公式的计算方法如下：其他应收款项 = 其他应收款项期初余额 + 本期新增其他应收款项 - 本期其他应收款项的减少其中，其他应收款项期初余额是指上一个会计期间末的其他应收款项余额。

本期新增其他应收款项是指本会计期间内新增的其他应收款项，包括企业从客户处收到的其他应收款项、从关联方处收到的其他应收款项等。

本期其他应收款项的减少是指本会计期间内其他应收款项的减少，包括企业向客户退还的其他应收款项、其他应收款项的坏账核销等。

金蝶资产负债表其他应收公式的目的是为了帮助企业准确计算和记录其他应收款项的变动情况，以便及时掌握企业的资金状况和经营风险。

通过对其他应收款项的计算和分析，企业可以及时采取措施，妥善处理与客户和关联方之间的应收款项，确保企业的资金流动性和偿债能力。

金蝶资产负债表其他应收公式的应用范围广泛，适用于各类企业和组织。

无论是制造业、贸易业还是服务业，都需要对其他应收款项进行准确计算和记录。

通过金蝶财务软件提供的其他应收公式，企业可以方便地进行其他应收款项的管理和分析，提高财务管理的效率和准确性。

除了金蝶资产负债表其他应收公式，金蝶财务软件还提供了其他财务指标和公式，如资产负债表总资产公式、利润表净利润公式等，帮助企业全面了解和掌握自身的财务状况。

这些公式的应用不仅可以提高企业的财务管理水平，还可以为企业的决策提供重要的参考依据。

总之，金蝶资产负债表其他应收公式是金蝶财务软件中用于计算企业其他应收款项的公式。

通过准确计算和记录其他应收款项的变动情况，企业可以及时掌握自身的资金状况和经营风险，提高财务管理的效率和准确性。

金蝶财务软件还提供了其他财务指标和公式，帮助企业全面了解和掌握自身的财务状况，为企业的决策提供重要的参考依据。