标准版本更新记录_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 https://www.360docs.net/doc/f513140090.html,='mchk' and a.id=b.id and https://www.360docs.net/doc/f513140090.html,='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

https://www.360docs.net/doc/f513140090.html,='NGSP_SYQYXG' and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='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

https://www.360docs.net/doc/f513140090.html,='NGSP_SYQY' and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='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.增加字段

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

https://www.360docs.net/doc/f513140090.html,='spjsdmx'and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='ysshl')

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

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

https://www.360docs.net/doc/f513140090.html,='spjsdmx'and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='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

https://www.360docs.net/doc/f513140090.html,='fdspgx'and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='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

a.fdbs=

b.fdbs

left join(select lshh,sktid,fdbs,count(1) mx_count from pos_mxls 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

isnull(a.je_count,0)<>isnull(b.je_count,0)

or isnull(a.mx_count,0)<>isnull(c.mx_count,0)or

isnull(a.je_count,0)<>isnull(d.je_count,0)

or isnull(a.mx_count,0)=0 or(isnull(a.sshje,0)<>0 and

isnull(a.je_count,0)=0))

begin

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

goto err_lab

end

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

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');

insert into tbstru (tbname,xlh,fdname)values('daysphwhz',7,'lshj'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',8,'ysje'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',9,'sshje'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',10,'chbje'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',11,'je'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',12,'ml'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',13,'she'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',14,'xspc'); insert into tbstru (tbname,xlh,fdname)values

('daysphwhz',15,'hschbje');

insert into tbstru (tbname,xlh,fdname)values('daysphwhz',16,'djbh'); insert into tbstru (tbname,xlh,fdname)values

('daysphwhz',17,'heschbje');

insert into tbstru (tbname,xlh,fdname)values('daysphwhz',18,'pqsx'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',19,'jgattr'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',20,'lks'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',21,'hw'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',22,'jwh'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',23,'dxpzs'); insert into tbstru (tbname,xlh,fdname)values('daysphwhz',24,'zxsje');

KSOA商品滞销查询更新

更新日期：2013-10-14 更新人：张建

申请日期：2013-10-14 申请人：张建

客户：泗洪时代

申请原因：ksoa标准版本商品滞销查询更新

适用版本：KSOA

确认日期：确认人：

1.查询方案

V301

KSOA近效期催销表

更新日期：2013-10-14 更新人：张建

申请日期：2013-10-14 申请人：张建

客户：泗洪时代

申请原因：ksoa标准版本近效期催销表BS版本增加选择品种，修改查询近效期品种数据重复bug

适用版本：KSOA、CCERP

确认日期：确认人：

1.更新bs表单

NGSP_JXQCXB

KSOA调价计划（总部）

更新日期：2013-10-15 更新人：张建

申请日期：2013-10-15 申请人：雷震

客户：天天好

申请原因：ksoa标准版本调价计划选择品种错误

适用版本：KSOA

确认日期：确认人：

2.更新如下脚本

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

https://www.360docs.net/doc/f513140090.html,='spkfk'and a.id=

b.id and https://www.360docs.net/doc/f513140090.html,='gjlshj')

alter table spkfk add gjlshj decimal(14,3)null default 0;

delete from tbstru where tbname='spkfk'and fdname='gjlshj';

insert into tbstru (tbname,xlh,fdname)values('spkfk',210,'gjlshj');