标准版本更新记录 - 1 -

标准版本更新记录

目录

首营审批增加营业执照年检日期 ........................................................................................... 1 KSOA错误修复 ......................................................................................................................... 2 KSOA日清错误修复 ................................................................................................................. 4 KSOA日清错误修复 ................................................................................................................. 4 KSOA商品滞销查询更新 ......................................................................................................... 6 KSOA调价计划（总部） ......................................................................................................... 6

首营审批增加营业执照年检日期

更新日期：2013-09-24 申请日期：2013-09-18 客户：泰州华为、无锡锡新

申请原因：首营审批增加营业执照年检日期 适用版本：CCERP、KSOA

确认日期：

更新人：张建 申请人：唐建平

确认人：

1. 增加字段

if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name='mchk' and a.id=b.id and b.name='ngsp_yyzznjrq')

alter table mchk add ngsp_yyzznjrq char(10) null default '';

delete from tbstru where tbname='mchk' and fdname='ngsp_yyzznjrq';

insert into tbstru (tbname,xlh,fdname) values ('mchk',141,'ngsp_yyzznjrq');

if not exists(select * from fldlist where fdname='ngsp_yyzznjrq') insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values ('ngsp_yyzznjrq','营业执照年检日期','字符',10,0);

if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name='NGSP_SYQYXG' and a.id=b.id and b.name='ngsp_yyzznjrq')

alter table NGSP_SYQYXG add ngsp_yyzznjrq char(10) null default '';

delete from tbstru where tbname='NGSP_SYQYXG' and fdname='ngsp_yyzznjrq'; insert into tbstru (tbname,xlh,fdname) values ('NGSP_SYQYXG',119,'ngsp_yyzznjrq');

if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name='NGSP_SYQY' and a.id=b.id and b.name='ngsp_yyzznjrq')

alter table NGSP_SYQY add ngsp_yyzznjrq char(10) null default '';

delete from tbstru where tbname='NGSP_SYQY' and fdname='ngsp_yyzznjrq';

insert into tbstru (tbname,xlh,fdname) values ('NGSP_SYQY',116,'ngsp_yyzznjrq'); 2. 更新表单 涉及表单

NGSP_SYQY_GSAJ01 NGSP_SYQY_GSBJ021 NGSP_SYQY_GSCJ031 NGSP_SYQY_GSDJ041 NGSP_SYQY_XG NGSP_SYQY_XGZX NGSP_SYQY_BL NGSP_SYQY_CX NGSP_SYQY_YYCX

NGSP_SYKH_GSAJ01 NGSP_SYKH_GSBJ021 NGSP_SYKH_GSCJ031 NGSP_SYKH_GSDJ041 NGSP_SYKH_XG NGSP_SYKH_XGZX NGSP_SYKH_BL NGSP_SYKH_CX NGSP_SYKH_YYCX

3. 更新存储过程 涉及存储过程 NGSP_gspxy_yc

KSOA错误修复

更新日期：2013-09-24 更新人：张建 申请日期：2013-09-24 申请人：卜练练 客户：无锡烨辉

申请原因：ksoa标准版本错误 适用版本：KSOA

确认日期： 确认人：

一、拒收审核和拒收记录查询报错\列名ysshl和ssshl无效\ 1. 增加字段

a.name='spjsdmx' and a.id=b.id and b.name='ysshl')

alter table spjsdmx add ysshl decimal (14,2) null default 0;

if not exists(select b.*,a.* from sysobjects a,syscolumns b where

delete from tbstru where tbname='spjsdmx' and fdname='ysshl';

insert into tbstru (tbname,xlh,fdname) values ('spjsdmx',34,'ysshl');

if not exists(select * from fldlist where fdname='ysshl') insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values ('ysshl','验收数量','实数',14,2);

if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name='spjsdmx' and a.id=b.id and b.name='ssshl')

alter table spjsdmx add ssshl decimal (14,2) null default 0; delete from tbstru where tbname='spjsdmx' and fdname='ssshl';

insert into tbstru (tbname,xlh,fdname) values ('spjsdmx',35,'ssshl');

if not exists(select * from fldlist where fdname='ssshl') insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values ('ssshl','实收数量','实数',14,2);

二、高于库存上限和货位上限预警没有过滤掉库存上限为零的情况 1. 更新存储过程

SOF_xt_jy，该存储过程改动较多，可考虑完全覆盖 三、零售价调整存盘当抬头勾选“是否更新状态”时，报错“字段zhuangt无效” 1. 更新字段

if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name='fdspgx' and a.id=b.id and b.name='zhuangt') alter table fdspgx add zhuangt char(10) null default ''; delete from tbstru where tbname='fdspgx' and fdname='zhuangt';

insert into tbstru (tbname,xlh,fdname) values ('fdspgx',26,'zhuangt');

四、410请货报计量规格校验错误 1. 更新存储过程

Autogetmx

Autogetmx存储过程，410单据所有品种语句时增加jlgg的取值。

五、“会员发卡管理”功能打不开

功能注册被删除，注册功能“会员发卡管理”

1. 执行脚本

if exists(select * from gnlist where mkbh = 'A1' and gnbh = 'pos_card_faka') insert

into

gnlist(gnbh,mkbh,gnmch,runexe,para,tubidx,jsjg)

发

卡

管

理

values('pos_card_fakagl','A1','会员','OpenBillMenu','pos_card_fakagl',-1,'')

KSOA日清错误修复

更新日期：2013-09-25 申请日期：2013-09-25 客户：徐州恩奇

申请原因：ksoa标准版本日清发现daysphz,dayskyhz,retjels,retmast不一致 适用版本：KSOA 确认日期：

确认人：

更新人：张建

申请人：赵辉

1. 更新存储过程

SBP_ls_rq

--Lan Q T 2013-09-25 增加三张表条目数不一致拦截,较之前的数据相比,更正了mx_count,je_count为的错误

if exists (select top 1 1 from #t_mast a

left join pos_mast b on a.lshh=b.lshh and a.sktid=b.sktid and left join (select lshh,sktid,fdbs,count(1) mx_count from pos_mxls a.fdbs=b.fdbs

group by lshh,sktid,fdbs) c on a.lshh=c.lshh and a.sktid=c.sktid and a.fdbs=c.fdbs

left join (select lshh,sktid,fdbs,count(1) je_count from pos_jels group by lshh,sktid,fdbs) d on a.lshh=d.lshh and a.sktid=d.sktid and a.fdbs=d.fdbs

where isnull(a.mx_count,0)<>isnull(b.mx_count,0) or or isnull(a.mx_count,0)<>isnull(c.mx_count,0) or or isnull(a.mx_count,0)=0 or (isnull(a.sshje,0)<>0 and isnull(a.je_count,0)<>isnull(b.je_count,0) isnull(a.je_count,0)<>isnull(d.je_count,0) isnull(a.je_count,0)=0)) begin

另外删除部分插入数据对yishj=’中’的控制,该语句无效果

raiserror('数据异常！存在明细条目数不匹配',16,1) goto err_lab

end

KSOA日清错误修复

更新日期：2013-09-28 更新人：张建 申请日期：2013-09-28 申请人：卜练练 客户：无锡烨辉

申请原因：ksoa标准版本日清发现daysphwhz插入重复健 适用版本：KSOA

确认日期：

确认人：

1. 手工修改daysphwhz主键

原主键为jzid、fdbs、spid，现更改为jzid、fdbs、spid、hw 2. 手工添加该表在时空中的注册

if not exists(select * from sysobjects where name='daysphwhz') create table daysphwhz (

jzid char(11) null default '', fdbs char(3) null default '', spid varchar(11) null default '', plh char(11) null default '', rq char(10) null default '', shl decimal(14,2) null default 0, lshj decimal(14,3) null default 0, ysje decimal(14,2) null default 0, sshje decimal(14,2) null default 0, chbje decimal(14,2) null default 0, je decimal(14,2) null default 0, ml decimal(14,2) null default 0, she decimal(14,2) null default 0, xspc integer null default 0,

hschbje decimal(14,2) null default 0, djbh varchar(15) null default '', heschbje decimal(14,2) null default 0, pqsx char(20) null default '', jgattr varchar(40) null default '', lks integer null default 0, hw char(11) null default '', jwh varchar(20) null default '', dxpzs

zxsje decimal(14,2) null default 0 );

if not exists(select * from tblist where tbname='daysphwhz') insert into tblist (tbname,chnname,tbtype) values ('daysphwhz','机构商品货位汇总','业务表');

delete from tbstru where tbname='daysphwhz';

insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',1,'jzid'); insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',2,'fdbs'); insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',3,'spid'); insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',4,'plh'); insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',5,'rq'); insert into tbstru (tbname,xlh,fdname) values ('daysphwhz',6,'shl');

本文来源：https://www.bwwdw.com/article/eeiv.html