详细信息

您现在的位置：网站首页 >> 百科问答 >> 详细信息

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

发布时间：2024-6-13　　

特价活动:>>>> 畅云管家新购、续费7折优惠，畅捷通T+cloud、好会计、易代账、好业财、好生意云产品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单计量单位修改