Page tree

Versions Compared

Key

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

995版本,账套启用后,运维平台就无法修改本位币编号和名称。

10.3版本,账套启用且开账使用后,仍可修改本位币编号和名称。
注意:软件里若已经有外币,修改时不要修改成和外币一样的编号名称,否则会出现两条一样的币种信息 且无法修改。
如果出现 可以执行该语句,把非本位币有重复的 编号和名称加上重复 两个字:UPDATE Ac_Currency SET UserCode=UserCode+'重复',FullName=FullName+'重复' 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))

Image Added



外币明细里面的值全部是原币,例如外币明细的期末余额所有币种之和等于应付查询树型表期末余额的原币金额。【期初余额】、【本期增加】、【本期减少】同理。

...