问题现象: | 存货中查到的期初及余额和总帐中是一样的,但在存货和总帐对帐时存货数据不对。 |
问题原因: | 由于存货期初中许多记录都没有录入“存货科目”,所以在与总帐对帐时是不统计这部分金额的。 |
解决方案: | 根据其设置存货科目的规则,在期初余额中录入存货科目,如果存货已经作了很久的业务,无法恢复期初余额记帐,可以使用下面语句将期初记录的存货科目加上: update ia_subsidiary set cinvhead='121102' where cwhcode='50' and cinvhead is null and cvoutype='34' update ia_subsidiary set cinvhead='121101' where cwhcode='51' and cinvhead is null and cvoutype='34' update ia_subsidiary set cinvhead='121104' where cwhcode='52' and cinvhead is null and cvoutype='34' update ia_subsidiary set cinvhead='121103' where cwhcode='53' and cinvhead is null and cvoutype='34' |
相关补丁: | |
版本: | 8.60sp |
模块: | 存货核算 |
产品: | U860SP--供应链--存货核算 |
问题名称: | 存货和总帐对帐时存货数据不对 |
最后更新: | 2006-08-14 00:00:00 |