问题现象: | 总账与固定资产对账平衡,但在固定资产卡片中显示的固定资产原值与‘对账’结果中的固定资产原值不一致差92581.27元。 |
问题原因: | 经查fa_total表中数据有错误,请用如下语句进行修复. |
解决方案: | --1 update fa_total set dblYearValue = dblaccrualvalue, dblvalue = dblaccrualvalue, dblMonthValue = dblaccrualvalue where sDeptNum = '0101' and sTypeNum = '021' and iperiod in ('1','2','3','4','5','6','7','8','9','10','11') --2 update fa_total set dblYearValue = dblaccrualvalue, dblvalue = dblaccrualvalue, dblMonthValue = dblaccrualvalue where sDeptNum = '0205' and sTypeNum = '021' and iperiod in ('1','2','3','4','5','6','7','8','9','10','11') |
相关补丁: | |
版本: | 8.52 |
模块: | 固定资产 |
产品: | U852 |
问题名称: | U8.52卡片原值不一致 |
最后更新: | 2005-06-28 00:00:00 |