畅捷通T+凭证编码不按顺序排序

【问题现象】：

凭证管理，查询所有凭证，发现凭证没有按凭证号排序

【解决方案】：

经查看，客户的凭证编码有3位，有4位，说明客户的凭证编码有问题

第一步：备份好账套数据，执行脚本，修复凭证编码位数，统一修改为4位，前面空位直接补0。

脚本：UPDATE dbo.GL_Doc SET code = RIGHT('000' + code, 4) WHERE LEN(code) < 4

第二步，整理凭证排序

update a set DocOrderNum= RIGHT('000'+CONVERT(VARCHAR(50),a.IdMarketingOrgan),4) + CAST(a.accountingyear as varchar(10))+isnull(replicate('0',2-len(a.accountingperiod)),'')

+cast(a.accountingperiod as varchar(30))+cast(b.sequencenumber as varchar(30)) +isnull(replicate('0',18-len(a.code)),'')+cast(a.code as varchar(30))

from gl_doc a left join AA_DocType b on a.iddoctype=b.id

where DocOrderNum != RIGHT('000'+CONVERT(VARCHAR(50),a.IdMarketingOrgan),4) + CAST(a.accountingyear as varchar(10))+isnull(replicate('0',2-len(a.accountingperiod)),'')

+cast(a.accountingperiod as varchar(30))+cast(b.sequencenumber as varchar(30)) +isnull(replicate('0',18-len(a.code)),'')+cast(a.code as varchar(30))