T+报表中‘自借’与‘借方’的取数区别

情况一、科目挂了辅助核算，没有下级科目

例如：科目1123预付账款，挂了往来单位辅助核算，没有下级科目，重分类公式‘借方’与‘自借’取数结果一致。

情况二、科目挂了辅助核算，还有下级科目，下级科目也挂了辅助核算

一级科目挂了辅助核算，还有下级科目，下级科目也挂了辅助核算，那么报表取值方向选择“借方“与”自借“是有区别的。

1.查询一级科目1122应收账款，辅助项-往来单位，查询到借方余额为客户A1200

报表按一级科目汇总的每个往来单位自己计算后的借方余额取数，则是用公式QC("1122","","年","","自借","","","","",[往来单位=""])    QM("1122","","年","月","自借","","","","",[往来单位=""])

2.查询1122末级科目，辅助项-往来单位，查询出来的借方余额是科目112201客户A  1000  112202科目 客户A  200  客户B100   合计借方余额为1300

报表按每个末级科目往来单位合计借方余额取数，则是用公式QC("1122","","年","","借","","","","",[往来单位=""])QM("1122","","年","月","借","","","","",[往来单位=""])

以上讲解了报表重分类公式“自借”与“借方”方向上的取数规则，重分类公式“自贷”与“贷方”方向上取数规则也是一样的！