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

iufida

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）

情况三：科目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）

                               
登录/注册后可看大图

公式挂上辅助核算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