用友U8 用户用的是ERP-U8.60最新版本,从7.21升级升上来的。总帐出纳中的现金日记帐发生额及余额出现翻倍,银行日记帐也是同样如此。用友U8 用户用的是ERP-U8.60最新版本,从7.21升级升上来的。总帐出纳中的现金日记帐发生额及余额出现翻倍,银行日记帐也是同样如此。
问题原因:按常规,出现这情况应该是数据库中code表的科目级次错了。进数据库查看,奇怪!Code表的bend级次字段没错,是对的.进币种表foreigncurrency,发现只有美元一个币种,本位币人民币竟然没有(见下图)。既然人民币这条记录没有,那就添上这条记录,随后再去看日记帐,还是翻倍数据,不对???查演示帐套及其他帐套,发现人民币这条记录是建好帐就有,默认的,且都是在第一行,会不会是位置不对呢?那就把美元记录改成人民币记录,但系统不允许改。那怎么办呢? 解决方法:USE UFDATA_001_2005 UPDATE foreigncurrency SET cexch_code = 'USD1' WHERE (cexch_code = 'USD') insert INTO foreigncurrency(cexch_name,cexch_code,bcal,idec,nerror,iotherused) values ('美元','USD',1,5,0.00001,0) UPDATE PurBillVouch SET cexch_name = ‘美元’ WHERE (cexch_name = ‘美圆’) UPDATE SALEBILLVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE DISPATCHLIST SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE PO_POMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE SA_QUOMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE SO_SOMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE PU_ARRIVALVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE GL_ACCVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE AP_DETAIL SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE CODE SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE foreigncurrency SET cexch_name = '人民币', cexch_code = 'RMB', bcal = 0, idec = 0, nerror = 0, iotherused = - 1 WHERE (cexch_name = '美圆')通过SQL的查询分析器,执行上述SQL语句,成功将人民币这条记录添加进去。进860总帐,查现金及银行日记帐的美元户,翻倍问题解决,数据一切正常,其他美元户的科目数据也恢复正常。由此可见,引起数据翻倍,不仅仅是科目级次不对造成,也有可能是其他原因造成的!
解决方案:
问题原因:按常规,出现这情况应该是数据库中code表的科目级次错了。进数据库查看,奇怪!Code表的bend级次字段没错,是对的.进币种表foreigncurrency,发现只有美元一个币种,本位币人民币竟然没有(见下图)。既然人民币这条记录没有,那就添上这条记录,随后再去看日记帐,还是翻倍数据,不对???查演示帐套及其他帐套,发现人民币这条记录是建好帐就有,默认的,且都是在第一行,会不会是位置不对呢?那就把美元记录改成人民币记录,但系统不允许改。那怎么办呢? 解决方法:USE UFDATA_001_2005 UPDATE foreigncurrency SET cexch_code = 'USD1' WHERE (cexch_code = 'USD') insert INTO foreigncurrency(cexch_name,cexch_code,bcal,idec,nerror,iotherused) values ('美元','USD',1,5,0.00001,0) UPDATE PurBillVouch SET cexch_name = ‘美元’ WHERE (cexch_name = ‘美圆’) UPDATE SALEBILLVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE DISPATCHLIST SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE PO_POMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE SA_QUOMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE SO_SOMAIN SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE PU_ARRIVALVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE GL_ACCVOUCH SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE AP_DETAIL SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE CODE SET cexch_name = '美元' WHERE (cexch_name = '美圆') UPDATE foreigncurrency SET cexch_name = '人民币', cexch_code = 'RMB', bcal = 0, idec = 0, nerror = 0, iotherused = - 1 WHERE (cexch_name = '美圆')通过SQL的查询分析器,执行上述SQL语句,成功将人民币这条记录添加进去。进860总帐,查现金及银行日记帐的美元户,翻倍问题解决,数据一切正常,其他美元户的科目数据也恢复正常。由此可见,引起数据翻倍,不仅仅是科目级次不对造成,也有可能是其他原因造成的!