Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

10.3版本,账套启用且开账使用后,仍可修改本位币编号和名称。
注意:软件里若已经有外币,修改时不要修改成和外币一样的编号名称,否则会出现两条一样的币种信息 且无法修改。
如果出现 可以执行该语句,把非本位币有重复的 编号和名称加上重复 两个字:UPDATE 两个字,然后自行在软件里面修改:UPDATE Ac_Currency SET UserCode=UserCode+'重复',FullName=FullName+'重复',Sysrow=0 WHERE CId<>1 AND( UserCode IN(SELECT UserCode FROM dbo.Ac_Currency GROUP BY UserCode HAVING COUNT(*)>1) OR FullName IN(SELECT FullName FROM dbo.Ac_Currency GROUP BY FullName HAVING COUNT(*)>1))

...