【問題現(xiàn)象】

操作員在修改存貨檔案時，點開存貨檔案修改完成后，存貨一直保存不上應如何操作，例如界面示圖修改完稅率字段后，點擊保存后沒反映？

【問題分析】

1.檢查是否設(shè)置了存貨必錄項；

2.有使用過發(fā)票管理模塊，開票規(guī)格型號長度不能超過40個字符；

3.該問題一般是由于建立的存貨檔案中存在特殊字符導致的，把特殊字符處理一下即可。

【解決方案】

1.在【系統(tǒng)管理】-【基礎(chǔ)檔案設(shè)置】中選擇存貨檢查是否設(shè)置了必錄項，例如設(shè)置了【換算率】和【換算說明】必錄，但是存貨是單計量的存貨，這個時候換算率和換算說明是不用錄入的，就會導致保存沒反應

2.使用了發(fā)票管理模塊，存貨的開票規(guī)格型號超過了40個字符會導致保存不了存貨，在【基礎(chǔ)設(shè)置】-【存貨】中點開具體存貨進行檢查，

另外，開票規(guī)格型號僅支持填寫40個字符，如實際填寫字符超過了40個字符導致保存不了存貨，可在數(shù)據(jù)庫中爭對賬套庫執(zhí)行如下修復腳本：

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

3.建立的存貨檔案中存在特殊字符導致的，把特殊字符處理一下即可，具體操作如下：

3.1先備份賬套數(shù)據(jù)；

3.2在數(shù)據(jù)庫中爭對賬套庫執(zhí)行如下腳本：

--創(chuàng)建存儲過程

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

--存貨

--備份存貨數(shù)據(jù)

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+服務(wù)