t3升级过来的数据,docordernum不正确所致,备份好数据,在问题账套执行以下脚本即可,
update gl_doc set docordernum=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<>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))