资产负债表取数
- 浏览：2124 - 发布时间：2008-08-03 16:47:39.0
| 问题版本: |
76-用友通标准版10.3 |
问题模块: |
2-UFO报表 |
| 所属行业: |
0-通用 |
问题状态: |
1-用友渠道员工帐户 |
| 关 键 字: |
ufo |
适用产品: |
|
| 补 丁 号: |
|
开放状态: |
2-用友渠道员工帐户 |
| 原问题号: |
|
提交时间: |
2008-8-3 16:47:39 |
| 问题名称: |
资产负债表取数 |
| 问题现象: |
客户的现金设置了部门和项目的辅助核算，现在资产负债表的货币资金数与账上不符！ |
| 原因分析: |
发现该客户账套中冗余信息，在数据不多的情况先。可以将该账套中的设计货币资金帐科目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 |
| 解决方案: |
发现该客户账套中冗余信息，在数据不多的情况先。可以将该账套中的设交醣易式鹫士颇?001、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","",,,,) | |
