| 解决方案： |
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总帐，查现金及银行日记帐的美元户，翻倍问题解决，数据一切正常，其他美元户的科目数据也恢复正常。
由此可见，引起数据翻倍，不仅仅是科目级次不对造成，也有可能是其他原因造成的！
|