【使用心得】科目余额表某一科目总计错误,导致报表重分类错误
904次浏览
编辑于2019年01月08日 11:18:47
科目余额表某一科目总计错误,导致报表重分类错误例如:正常情况报表公式为下图,但是由于余额表总计错误,导致报表数据错乱
正确调整:期末其他应收=ACCT("1221.01|职员|002:230","JY","",0,0,0,"")+ACCT("1221.02.01|客户|01:ZZ","JY","",0,0,0,"")+ACCT("1221.03|客户|01:ZZ","JY","",0,0,0,"")+ACCT("1221.04","JY","",0,0,0,"")+ACCT("1221.05","JY","",0,0,0,"")+ACCT("2241.01|供应商|001:ZZ","JY","",0,0,0,"")+ACCT("2241.02|职员|002:230","JY","",0,0,0,"")+ACCT("2241.03|供应商|001:ZZ","JY","",0,0,0,"")+ACCT("2241.04|供应商|001:ZZ","JY","",0,0,0,"")-ACCT("1231.02","Y","",0,0,0,"") 其他应收年初余额=ACCT("1221.01|职员|002:230","JC","",0,1,1,"")+ACCT("1221.02.01|客户|01:ZZ","JC","",0,1,1,"")+ACCT("1221.03|客户|01:ZZ","JC","",0,1,1,"")+ACCT("1221.04","JC","",0,1,1,"")+ACCT("1221.05","JC","",0,1,1,"")+ACCT("2241.01|供应商|001:ZZ","JC","",0,1,1,"")+ACCT("2241.02|职员|002:230","JC","",0,1,1,"")+ACCT("2241.03|供应商|001:ZZ","JC","",0,1,1,"")+ACCT("2241.04|供应商|001:ZZ","JC","",0,1,1,"")-ACCT("1231.02","C","",0,1,1,"") 期末其他应付=ACCT("2241.01|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("2241.02|职员|002:230","DY","",0,0,0,"")+ACCT("2241.03|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("2241.04|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("1221.01|职员|002:230","DY","",0,0,0,"")+ACCT("1221.02.01|客户|01:ZZ","DY","",0,0,0,"")+ACCT("1221.03|客户|01:ZZ","DY","",0,0,0,"")+ACCT("1221.04","DY","",0,0,0,"")+ACCT("1221.05","DY","",0,0,0,"") 期初其他应付=ACCT("2241.01|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("2241.02|职员|002:230","DC","",0,1,1,"")+ACCT("2241.03|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("2241.04|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("1221.01|职员|002:230","DC","",0,1,1,"")+ACCT("1221.02.01|客户|01:ZZ","DC","",0,1,1,"")+ACCT("1221.03|客户|01:ZZ","DC","",0,1,1,"")+ACCT("1221.04","DC","",0,1,1,"")+ACCT("1221.05","DC","",0,1,1,"")
正确调整:期末其他应收=ACCT("1221.01|职员|002:230","JY","",0,0,0,"")+ACCT("1221.02.01|客户|01:ZZ","JY","",0,0,0,"")+ACCT("1221.03|客户|01:ZZ","JY","",0,0,0,"")+ACCT("1221.04","JY","",0,0,0,"")+ACCT("1221.05","JY","",0,0,0,"")+ACCT("2241.01|供应商|001:ZZ","JY","",0,0,0,"")+ACCT("2241.02|职员|002:230","JY","",0,0,0,"")+ACCT("2241.03|供应商|001:ZZ","JY","",0,0,0,"")+ACCT("2241.04|供应商|001:ZZ","JY","",0,0,0,"")-ACCT("1231.02","Y","",0,0,0,"") 其他应收年初余额=ACCT("1221.01|职员|002:230","JC","",0,1,1,"")+ACCT("1221.02.01|客户|01:ZZ","JC","",0,1,1,"")+ACCT("1221.03|客户|01:ZZ","JC","",0,1,1,"")+ACCT("1221.04","JC","",0,1,1,"")+ACCT("1221.05","JC","",0,1,1,"")+ACCT("2241.01|供应商|001:ZZ","JC","",0,1,1,"")+ACCT("2241.02|职员|002:230","JC","",0,1,1,"")+ACCT("2241.03|供应商|001:ZZ","JC","",0,1,1,"")+ACCT("2241.04|供应商|001:ZZ","JC","",0,1,1,"")-ACCT("1231.02","C","",0,1,1,"") 期末其他应付=ACCT("2241.01|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("2241.02|职员|002:230","DY","",0,0,0,"")+ACCT("2241.03|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("2241.04|供应商|001:ZZ","DY","",0,0,0,"")+ACCT("1221.01|职员|002:230","DY","",0,0,0,"")+ACCT("1221.02.01|客户|01:ZZ","DY","",0,0,0,"")+ACCT("1221.03|客户|01:ZZ","DY","",0,0,0,"")+ACCT("1221.04","DY","",0,0,0,"")+ACCT("1221.05","DY","",0,0,0,"") 期初其他应付=ACCT("2241.01|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("2241.02|职员|002:230","DC","",0,1,1,"")+ACCT("2241.03|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("2241.04|供应商|001:ZZ","DC","",0,1,1,"")+ACCT("1221.01|职员|002:230","DC","",0,1,1,"")+ACCT("1221.02.01|客户|01:ZZ","DC","",0,1,1,"")+ACCT("1221.03|客户|01:ZZ","DC","",0,1,1,"")+ACCT("1221.04","DC","",0,1,1,"")+ACCT("1221.05","DC","",0,1,1,"")