热线电话:
0576-88510701U8存货核算凭证查询中会计年度不显示2021、2022……年度
问题描述:
U8+存货核算2021年查询报表或查询凭证,会计年度选择不到2021年度。
解决方案:
一、补丁解决
U8+V16.0安装SP1补丁包、U8+V15.1和13.0安装存货核算模块(IA)和采购模块(PUOM)补丁。注意:请提前备份账套数据,安装补丁后需要对账套执行脚本补丁。
二、脚本解决
增加十个年度的数据(简体中文)。注意:请提前备份账套数据,再对问题账套执行脚本处理:
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')
三、工具解决
下载U8智慧企业看板小工具(长颈鹿),
下载地址:http://pan.yonyou.com/web/share.html?hash=xptlcY03TMM
进入工具箱-2021年度不显示问题,点击【执行脚本】按钮,通过工具解决。如下图:
台州用友软件服务中心,专注企业ERP管理,台州中小企业十佳机构。
涵盖了企业FI(财务管理)、CRM(客户关系管理)、HR(人力资源管理)、OA(办公自动化)、ERP(企业资源计划)等业务领域。,为客户提供完整的企业应用解决方案及专业、高效的本地化即时服务,推动企业快速成长;公司同时为企业提供信息化培训教育及管理咨询服务。
我们的联系方式:
QQ:32714335
电话:0576-88510701