苏州用友软件-用友软件-用友云-益友智创
153006269499
当前位置：
关于U8+存货核算2021年查询报表或查询凭证，会计年度显示不了2021年度的解决方案
来源: | 作者:YIYOU | 发布时间: 2021-04-04 | 3039 次浏览 | 分享到:
关于U8+存货核算2021年查询报表或查询凭证，会计年度显示不了2021年度的解决方案

解决方案：

方案一、补丁解决：U8+V16.0安装SP1补丁包、U8+V15.1和13.0安装存货核算模块（IA结尾）补丁。注意：请提前备份账套数据，安装补丁后需要对问题账套执行脚本补丁。

方案二、脚本解决：请提前备份账套数据，再通过SQL对问题账套执行脚本处理：
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2021' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2021,N'zh-cn',2021,21,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2022' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2022,N'zh-cn',2022,22,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2023' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2023,N'zh-cn',2023,23,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2024' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2024,N'zh-cn',2024,24,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2025' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2025,N'zh-cn',2025,25,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2026' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2026,N'zh-cn',2026,26,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2027' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2027,N'zh-cn',2027,27,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2028' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2028,N'zh-cn',2028,28,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2029' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2029,N'zh-cn',2029,29,N'U870')
if not exists(select EnumType from aa_enum where EnumType=N'IA.iYear' and enumcode=N'2030' and LocaleId=N'zh-cn')
insert into aa_enum (EnumType,EnumCode,LocaleId,EnumName,EnumIndex,cProjectNO)values(N'IA.iYear',2030,N'zh-cn',2030,30,N'U870')