發(fā)布時間:2024-11-18
特價活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠,暢捷通T+cloud、好會計、易代賬、好業(yè)財、好生意云產(chǎn)品6-8折優(yōu)惠。
操作員在修改存貨檔案時,點開存貨檔案修改完成后,存貨一直保存不上應(yīng)如何操作,例如界面示圖修改完稅率字段后,點擊保存后沒反映?
1.檢查是否設(shè)置了存貨必錄項;
2.有使用過發(fā)票管理模塊,開票規(guī)格型號長度不能超過40個字符;
3.該問題一般是由于建立的存貨檔案中存在特殊字符導(dǎo)致的,把特殊字符處理一下即可。
1.在【系統(tǒng)管理】-【基礎(chǔ)檔案設(shè)置】中選擇存貨檢查是否設(shè)置了必錄項,例如設(shè)置了【換算率】和【換算說明】必錄,但是存貨是單計量的存貨,這個時候換算率和換算說明是不用錄入的,就會導(dǎo)致保存沒反應(yīng)
2.使用了發(fā)票管理模塊,存貨的開票規(guī)格型號超過了40個字符會導(dǎo)致保存不了存貨,在【基礎(chǔ)設(shè)置】-【存貨】中點開具體存貨進行檢查,
另外,開票規(guī)格型號僅支持填寫40個字符,如實際填寫字符超過了40個字符導(dǎo)致保存不了存貨,可在數(shù)據(jù)庫中爭對賬套庫執(zhí)行如下修復(fù)腳本:
UPDATE dbo.AA_InventoryEntity SET InvoiceSpecification = SUBSTRING(InvoiceSpecification, 1, 40) WHERE InvoiceSpecification IS NOT NULL
3.建立的存貨檔案中存在特殊字符導(dǎo)致的,把特殊字符處理一下即可,具體操作如下:
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ù)
客服電話:400-665-0028
關(guān)鍵字:用友財務(wù)軟件,暢捷通軟件,財務(wù)軟件,進銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會計,好生意,智+好業(yè)財,用友培訓(xùn)服務(wù)售后公司,暢捷通運營培訓(xùn)服務(wù)公司
版權(quán)所有:用友暢捷通軟件 Copyright © 2024 All rights reserved.