基础设置存货中在修改保存存货时界面很卡应如何操作？

【问题现象】

操作员在修改存货档案时，点开存货档案修改完成后，存货一直保存不上应如何操作，例如界面示图修改完税率字段后，点击保存后没反映？

【问题分析】

1.检查是否设置了存货必录项；

2.有使用过发票管理模块，开票规格型号长度不能超过40个字符；

3.该问题一般是由于建立的存货档案中存在特殊字符导致的，把特殊字符处理一下即可。

【解决方案】

1.在【系统管理】-【基础档案设置】中选择存货检查是否设置了必录项，例如设置了【换算率】和【换算说明】必录，但是存货是单计量的存货，这个时候换算率和换算说明是不用录入的，就会导致保存没反应

2.使用了发票管理模块，存货的开票规格型号超过了40个字符会导致保存不了存货，在【基础设置】-【存货】中点开具体存货进行检查，

另外，开票规格型号仅支持填写40个字符，如实际填写字符超过了40个字符导致保存不了存货，可在数据库中争对账套库执行如下修复脚本：

UPDATE dbo.AA_InventoryEntity SET InvoiceSpecification = SUBSTRING(InvoiceSpecification, 1, 40) WHERE InvoiceSpecification IS NOT NULL

3.建立的存货档案中存在特殊字符导致的，把特殊字符处理一下即可，具体操作如下：

3.1先备份账套数据；

3.2在数据库中争对账套库执行如下脚本：

--创建存储过程

IF EXISTS(SELECT NAME FROM SYS.objects WHERE NAME ='ShowWhiteSpace' AND TYPE ='FN')

DROP FUNCTION dbo.ShowWhiteSpace

GO

CREATE FUNCTION dbo.ShowWhiteSpace (@str varchar(8000))

RETURNS varchar(8000)

AS

BEGIN

DECLARE @ShowWhiteSpace VARCHAR(8000);

SET @ShowWhiteSpace = @str

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(32), '[?]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(13), '[CR]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(10), '[LF]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(9), '[TAB]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(1), '[SOH]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(2), '[STX]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(3), '[ETX]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(4), '[EOT]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(5), '[ENQ]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(6), '[ACK]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(7), '[BEL]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(8), '[BS]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(11), '[VT]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(12), '[FF]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(14), '[SO]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(15), '[SI]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(16), '[DLE]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(17), '[DC1]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(18), '[DC2]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(19), '[DC3]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(20), '[DC4]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(21), '[NAK]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(22), '[SYN]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(23), '[ETB]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(24), '[CAN]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(25), '[EM]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(26), '[SUB]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(27), '[ESC]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(28), '[FS]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(29), '[GS]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(30), '[RS]')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(31), '[US]')

RETURN(@ShowWhiteSpace)

END

GO

IF EXISTS(SELECT NAME FROM SYS.objects WHERE NAME ='DeleteWhiteSpace' AND TYPE ='FN')

DROP FUNCTION dbo.DeleteWhiteSpace

GO

CREATE FUNCTION dbo.DeleteWhiteSpace (@str varchar(8000))

RETURNS varchar(8000)

AS

BEGIN

DECLARE @ShowWhiteSpace varchar(8000);

SET @ShowWhiteSpace = @str

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(32), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(13), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(10), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(9), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(1), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(2), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(3), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(4), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(5), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(6), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(7), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(8), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(11), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(12), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(14), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(15), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(16), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(17), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(18), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(19), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(20), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(21), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(22), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(23), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(24), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(25), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(26), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(27), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(28), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(29), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(30), '')

SET @ShowWhiteSpace = REPLACE( @ShowWhiteSpace, CHAR(31), '')

RETURN(@ShowWhiteSpace)

END

GO

--存货

--备份存货数据

SELECT * INTO AA_Inventory_SERVICE_103716 FROM dbo.AA_Inventory

WHERE

code <> dbo.ShowWhiteSpace(code)

OR name <> dbo.ShowWhiteSpace(name)

OR specification <> dbo.ShowWhiteSpace(specification)

OR shorthand <> dbo.ShowWhiteSpace(shorthand)

OR InventoryDescript <> dbo.ShowWhiteSpace(InventoryDescript)

UPDATE dbo.AA_InventoryEntity set code = dbo.DeleteWhiteSpace(code)

WHERE code <> dbo.ShowWhiteSpace(code) AND code IS NOT null

UPDATE dbo.AA_InventoryEntity set name = dbo.DeleteWhiteSpace(name)

WHERE name <> dbo.ShowWhiteSpace(name) AND name IS NOT null

UPDATE dbo.AA_InventoryEntity set specification = dbo.DeleteWhiteSpace(specification)

WHERE specification <> dbo.ShowWhiteSpace(specification) AND specification IS NOT null

UPDATE dbo.AA_InventoryEntity set shorthand = dbo.DeleteWhiteSpace(shorthand)

WHERE shorthand <> dbo.ShowWhiteSpace(shorthand) AND shorthand IS NOT null

UPDATE dbo.AA_InventoryEntity set InventoryDescript = dbo.DeleteWhiteSpace(InventoryDescript)

WHERE InventoryDescript <> dbo.ShowWhiteSpace(InventoryDescript) AND InventoryDescript IS NOT null

GO

3.3操作完成后重启T+服务