用友T+资产负债表应收科目取数讲解

现在有两种需求，具体如下：

一、应收账款余额在借方时，显示在资产负债表应账款中，余额在贷方时显示在资产负债表预收中。

二、在资产负债表上体现：如客户余额在借方时，取借方之和，当余额在贷方时，取贷方之和。

解决方案

一、应收账款余额在借方时，显示在资产负债表应账款中，余额在贷方时显示在资产负债表预收中。

如果应收账款科目启用了往来单位辅助核算，T-UFO 报表公式如下：

应收账款：QM("1122","","年","月","借")+QM("2203","","年","月","借")

预收账款：QM("1122","","年","月","贷")+QM("2203","","年","月","贷")

如果应收账款科目没有启用辅助核算，而且设定了很多二级明细科目，则实现不了此功能。

二、在资产负债表上体现：如客户余额在借方时，取借方之和，当余额在贷方时，取贷方之和。

（1）应收账款科目挂了往来辅助核算T-UFO 报表公式如下：

应收账款：QM("1122","","年","月","借","","","",[往来单位=""])+QM("2203","","年","月"," 借","","","",[往来单位=""])

预收账款：QM("1122","","年","月","贷","","","",[往来单位=""])+QM("2203","","年","月"," 贷","","","",[往来单位=""])

业务场景二：科目下设了二级T-UFO 报表公式如下：

应收账款：QM("1122","","年","月","借")+QM("2203","","年","月","借")

预收账款：QM("1122","","年","月","贷")+QM("2203","","年","月","贷")

业务扩展

应收账款科目使用了二级科目，如果想实现应收账款余额在借方时，显示在资产负债表应账款中，余额在贷方时显示在资产负债表预收中，可以实现吗？

答：实现不了，应收账款科目使用了二级科目，不管公式中是 QM("1122","","年","月","借")+QM("2203",""," 年 "," 月 "," 借 ") ， 还 是QM("112201",""," 年 "," 月 "," 借

")+QM("112202","","年","月","借")+QM("112203","","年","月","借")+QM("112204","","

年","月","借")取出来的数据都是：客户余额在借方时，取借方之和，当余额在贷方时，取贷方之和。