厦门用友软件 畅捷通T+TUFO借与自借、贷与自贷的区别

TUFO借与自借、贷与自贷的区别

【问题现象】

TUFO报表中‘借’与‘自借’、‘贷’与‘自贷’取值有何不同，以科目1122应收账款为例

【问题解决】

情况一：科目1122应收账款只有一级科目，设科目期初为0

例如本月应收账款科目借方发生100，贷方发生50

则此时按【借】的公式QM("1122","","年","月","借")取的数是100-50=50

按【自借】的公式QM("1122","","年","月","自借")取的数也是100-50=50

按【贷】的公式QM("1122","","年","月","贷")取的数为0，因为贷方没有余额

同样，按【自贷】的公式QM("1122","","年","月","自贷")取的数也为0

情况二：科目1122有二级科目，若112201本月借方发生500，贷方发生200；若112202本月借方发生100，贷方发生200；若112203科目借方发生200，贷方发生300

则此时按【借】的公式QM("1122","","年","月","借")取的数是（500-200）=300即只取下级科目在借方余额的合计数

按【自借】的公式QM("1122","","年","月","自借")取的数是（500-200）+（100-200）+（200-300）=100即下级科目余额在借方减去下级科目余额在贷方后余额在借方的数

按【贷】的公式QM("1122","","年","月","贷")取的数是（200-100）+（300-200）=200即只取下级科目在贷方余额的合计数

按【自贷】的公式QM("1122","","年","月","自贷")取的数为（200-100）+（300-200）+（200-500）<0，所以取数为0

情况三：科目1122有二级科目，且挂了往来单位辅助核算，若112201本月A客户借方发生500，贷方发生300，B客户借方发生300，贷方发生400；若112202本月A客户借方发生600，贷方发生200，B客户借方发生100，贷方发生700

则此时按【借】的公式QM("1122","","年","月","借")取的数是500+300-700=100

公式挂上辅助核算QM("1122","","年","月","借","","本币","","",[往来单位=""])取数为（500-300）+（600-200）=600

按【自借】的公式QM("1122","","年","月","自借")取的数为（800-700）+（700-900）<0，所以取数为0

公式挂上辅助核算QM("1122","","年","月","自借","","本币","","",[往来单位=""])取数为（500-300）+（600-200）=600

按【贷】的公式QM("1122","","年","月","贷")取的数是（200+700）-（600+100）=200

公式挂上辅助核算QM("1122","","年","月","贷","","本币","","",[往来单位=""])取数为（400-300）+（700-100）=700

按【自贷】的公式QM("1122","","年","月","自贷")取的数为（700-800）+（900-700）=100

公式挂上辅助核算QM("1122","","年","月","自贷","","本币","","",[往来单位=""])取数为（400-300）+（700-100）=700