T+专属云2025余额表科目乱序排序不对，科目类型错误

因为客户的科目需要更新，导入的科目类型有问题，但是也导入成功了，科目编码没有问题，类型有问题

导致余额表中显示的科目，都是乱序的。

这种情况就需要从后台中更新下科目的类型。

解决方案：

1、先备份好账套，防止有误。

2、进入数据库执行以下语句(目前仅测试适用于2013小企业准则)

accountingyear = 2026，2026修改为实际的会计年度

use  UF账套数据库名称
go
UPDATE AA_Account
SET idaccounttypeDTO =
CASE
WHEN LEFT(CAST(code AS VARCHAR), 1) = '1' THEN 6
WHEN LEFT(CAST(code AS VARCHAR), 1) = '2' THEN 7
WHEN LEFT(CAST(code AS VARCHAR), 1) = '3' THEN 8
WHEN LEFT(CAST(code AS VARCHAR), 1) = '4' THEN 9
WHEN LEFT(CAST(code AS VARCHAR), 1) = '5' THEN 10
END
WHERE accountingyear = 2026
AND LEFT(CAST(code AS VARCHAR), 1) IN ('1', '2', '3', '4', '5')
AND (
(LEFT(CAST(code AS VARCHAR), 1) = '1' AND idaccounttypeDTO != 6) OR
(LEFT(CAST(code AS VARCHAR), 1) = '2' AND idaccounttypeDTO != 7) OR
(LEFT(CAST(code AS VARCHAR), 1) = '3' AND idaccounttypeDTO != 8) OR
(LEFT(CAST(code AS VARCHAR), 1) = '4' AND idaccounttypeDTO != 9) OR
(LEFT(CAST(code AS VARCHAR), 1) = '5' AND idaccounttypeDTO != 10)
);