急!资产负债表里的其他应收和其他应付同时缺少同一个...
如题,我把科目余额表的其他应收和其他应付明细导出来,自己做重分类后,发现资产负债表里的其他应收期末余额和其他应付期末余额同时缺少同一个金额5000元,我应如何查找这个差异?
月初出报表,求大神版主支招。
其中2241.03这个科目是6月才新增加的,直接在公式里复制黏贴改数字的,也不知道加的对不对。
其他应收款的报表公式
=ACCT("1231.01|职员|","JY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","JY","",0,0,0,"")+ACCT("1231.03|客户|","JY","",0,0,0,"")+ACCT("1231.04|关联公司|","JY","",0,0,0,"")+ACCT("1231.05|客户|","JY","",0,0,0,"")+ACCT("1231.99","JY","",0,0,0,"")+ACCT("2241.01|供应商|","JY","",0,0,0,"")+ACCT("2241.02|关联公司|","JY","",0,0,0,"")+ACCT("2241.03|职员|","JY","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","JY","",0,0,0,"")-ACCT("1242.02","Y","",0,0,0,"")
其他应付款的报表公式
=ACCT("2241.01|供应商|","DY","",0,0,0,"")+ACCT("2241.02|关联公司|","DY","",0,0,0,"")+ACCT("2241.03|职员|","Y","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","DY","",0,0,0,"")+ACCT("1231.01|职员|","DY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","DY","",0,0,0,"")+ACCT("1231.03|客户|","DY","",0,0,0,"")+ACCT("1231.04|关联公司|","DY","",0,0,0,"")+ACCT("1231.05|客户|","DY","",0,0,0,"")+ACCT("1231.99","DY","",0,0,0,"")
月初出报表,求大神版主支招。
其中2241.03这个科目是6月才新增加的,直接在公式里复制黏贴改数字的,也不知道加的对不对。
其他应收款的报表公式
=ACCT("1231.01|职员|","JY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","JY","",0,0,0,"")+ACCT("1231.03|客户|","JY","",0,0,0,"")+ACCT("1231.04|关联公司|","JY","",0,0,0,"")+ACCT("1231.05|客户|","JY","",0,0,0,"")+ACCT("1231.99","JY","",0,0,0,"")+ACCT("2241.01|供应商|","JY","",0,0,0,"")+ACCT("2241.02|关联公司|","JY","",0,0,0,"")+ACCT("2241.03|职员|","JY","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","JY","",0,0,0,"")-ACCT("1242.02","Y","",0,0,0,"")
其他应付款的报表公式
=ACCT("2241.01|供应商|","DY","",0,0,0,"")+ACCT("2241.02|关联公司|","DY","",0,0,0,"")+ACCT("2241.03|职员|","Y","",0,0,0,"")+ACCT("2241.99.01:2241.99.99","DY","",0,0,0,"")+ACCT("1231.01|职员|","DY","",0,0,0,"")+ACCT("1231.02.01:1231.02.04|客户|","DY","",0,0,0,"")+ACCT("1231.03|客户|","DY","",0,0,0,"")+ACCT("1231.04|关联公司|","DY","",0,0,0,"")+ACCT("1231.05|客户|","DY","",0,0,0,"")+ACCT("1231.99","DY","",0,0,0,"")
急!资产负债表里的其他应收和其他应付同时缺少同一个...
如题,我把科目余额表的其他应收和其他应付明细导出来,自己做重分类后,发现资产负债表里的其他应收期末余额和其他应付期末余额同时缺少同...
点击下载文档
本文2024-09-16 15:49:06发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-5248.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章