T+13.0填盘点单提示仓库结存与货位结存不一致

发布时间：2024-6-13　

特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠，畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠，另有话费赠送。

问题描述：

填盘点单提示仓库结存与货位结存不一致

问题回复：

不需要货位补录，根本原因是批号中有特殊字符。备份账套，分别执行001和002附件。

001： UPDATE PU_PurchaseArrival_b SET batch = SUBSTRING(batch,2,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]?%' UPDATE PU_PurchaseArrival_b SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' UPDATE ST_RDRecord_b SET batch = SUBSTRING(batch,2,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]?%' UPDATE ST_RDRecord_b SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' UPDATE ST_LocationDetail SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' SELECT * INTO ST_LocationAccount_Tplus248574 FROM dbo.ST_LocationAccount TRUNCATE TABLE dbo.ST_LocationAccount EXEC dbo.SCM_SP_RebuildLocationAccount EXEC dbo.SCM_SP_RebuildCurrentStock；

002 ：UPDATE PU_PurchaseArrival_b SET batch = SUBSTRING(batch,2,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]?%' UPDATE PU_PurchaseArrival_b SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' UPDATE ST_RDRecord_b SET batch = SUBSTRING(batch,2,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]?%' UPDATE ST_RDRecord_b SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' UPDATE ST_LocationDetail SET batch = SUBSTRING(batch,3,LEN(batch)) WHERE dbo.ShowWhiteSpace (batch) LIKE '[[]TAB%' SELECT * INTO ST_LocationAccount_Tplus248574 FROM dbo.ST_LocationAccount TRUNCATE TABLE dbo.ST_LocationAccount EXEC dbo.SCM_SP_RebuildLocationAccount EXEC dbo.SCM_SP_RebuildCurrentStock

上一篇:T+13.0删除单据，但是日志管理里面不显示

下一篇:T+11.51单计量单位修改

百科问答

T+13.0填盘点单提示仓库结存与货位结存不一致