T+cloud 资产负债表 应收 预付 应付 预收 金额不对

【问题详情】：

T+cloud  资产负债表 应收  预付   应付  预收 金额不对     应收实际金额 119683  负债表显示 117183 差 2500 ，预付 实际 29385  负债表 22385 差7000，应付实际 7000 负债表 0 差7000  ，预收 实际 4264  负债表 1764  差2500  ，并且联查公式取值  科目也是混乱的 这种怎么办？

【问题答复】：

参考如下内容查看公式设置是否错误。

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