| 问题现象: | 客户的现金设置了部门和项目的辅助核算,现在资产负债表的货币资金数与账上不符! | ||
| 原因分析: | 发现该客户账套中冗余信息,在数据不多的情况先。可以将 该账套中的设计货币资金帐科目1001、1002删除在冲洗录入 执行如下语句 delete gl_accsum where ccode like '1002%' delete gl_accass where ccode like '1002%' delete gl_accvouch where ccode like '1002%' and iperiod =0 delete gl_accsum where ccode like '1001%' delete gl_accass where ccode like '1001%' delete gl_accvouch where ccode like '1001%' and iperiod =0 |
||
| 解决方案: | 发现该客户账套中冗余信息,在数据不多的情况先。可以将 该账套中的设计货币资金帐科目1001、1002删除在冲洗录入 执行如下语句 delete gl_accsum where ccode like '1002%' delete gl_accass where ccode like '1002%' delete gl_accvouch where ccode like '1002%' and iperiod =0 delete gl_accsum where ccode like '1001%' delete gl_accass where ccode like '1001%' delete gl_accvouch where ccode like '1001%' and iperiod =0 部门的公式设计为 假设为101部门 货币资金期末的公式设计为:QM("1001",月,,,,"101","",,,,)+QM("1002",月,,,,"101","",,,,) |
||
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15453181/viewspace-441461/ ,如需转载,请注明出处,否则将追究法律责任。